亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: Oracle12監(jiān)聽(tīng)配置問(wèn)題，始終連接不上pdb數(shù)據(jù)庫(kù) [打印本頁(yè)]

作者: 老陳73 時(shí)間: 2016-07-01 12:01
標(biāo)題: Oracle12監(jiān)聽(tīng)配置問(wèn)題，始終連接不上pdb數(shù)據(jù)庫(kù)
環(huán)境變量：
$ echo $ORACLE_HOME
/home/oracle/12/db1

$ echo $ORACLE_SID
orcl12c

數(shù)據(jù)庫(kù)狀態(tài) ：
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
orcl12c

SQL> show pdbs

CON_ID CON_NAME    OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
   2 PDB$SEED    READ ONLY  NO
   3 PDBORCL    READ WRITE NO

監(jiān)聽(tīng)配置文件：
listener.ora

LISTENER =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 128.128.10.9

(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC = (GLOBAL_DBNAME = orcl12c)(SID_NAME = orcl12c))
  (SID_DESC = (GLOBAL_DBNAME = pdborcl)(SID_NAME = orcl12c))
)

tnsnames.ora

ORCL12C =
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )
  (CONNECT_DATA =
(SERVICE_NAME = orcl12c)
  )
)

pdborcl =
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )
  (CONNECT_DATA =
(SERVICE_NAME = pdborcl)
  )
)

作者: 老陳73 時(shí)間: 2016-07-04 20:01
數(shù)據(jù)庫(kù)重裝之后，連上了。

歡迎光臨 Chinaunix (http://www.72891.cn/)