dategurd 安装碰到的一次 ORA_27101(类似数据库启动失败)
dategurd 安装碰到的一次ORA_27101
前不久在安装数据库同步的时候 主备库都已经能够正常同步
在使用 plsql 连接主库的时候出现ORA_27101,
找了半天还以为datagurd 安装时候出现问题,但是两个数据库都能正常启动,监听也正常开启
listener.ora 文件
LISTENER =
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=168.5.16.246)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = pbcpcr)
(ORACLE_HOME = /opt/app/oracle/product/11.2.0/dbhome_1/)
(SID_NAME = pbcpcr)
)
)
tnsnames.ora 文件
pbcpcr =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.5.16.246)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pbcpcr)
)
)
pbcpcr1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.5.16.247)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pbcpcr1)
)
)
)
后再在无意中把另一个linux的listener.ora ,tnsnames.ora 全部复制上去plsql就连接成功了!!!!
后来最终确认问题在dbhome_1后面多了一个斜杠
整整查了两天的问题解决了。