OGG-02615和OGG-00664 Oracle连接问题
Tags： OGGOGG-00664OGG-02615故障处理
👉 本文共约450个字，系统预计阅读时间或需2分钟。
本页目录 隐藏
OGG-02615和OGG-00664
OGG-02615 Login to the database as user ogg failed because of error ORA-12545: Connect failed because target host or object does not exist.
OGG-00664 OCI Error ORA (status = 12545-ORA-12545: Connect failed because target host or object does not exist
replicate的参数文件：
1 2 3 4 5 | replicat orep2 setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) setenv (ORACLE_HOME="/u01/app/oracle/product/12.2.0/dbhome_1") userid ogg, password ogg 。。。。。 |
尽管使用sqlplus ogg/ogg可以直接登陆数据库，但是这里仍然会报错
解决：修改参数文件中的userid后加上tnsname：
1 2 3 4 5 | replicat orep2 setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) setenv (ORACLE_HOME="/u01/app/oracle/product/12.2.0/dbhome_1") userid ogg@ora12c, password ogg 。。。。。 |
重启ogg进程即可。
OGG-00664 OCI Error during OCIServerAttach (status = 12541-ORA-12541: TNS:no listener)
错误信息：
OGG-00664 OCI Error during OCIServerAttach (status = 12541-ORA-12541: TNS:no listener).
处理方法：
本人提供Oracle、MySQL、PG等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
启动数据库的监听器。
OGG-00664 OCI Error during OCIServerAttach (status = 12545-Error while trying to retrieve text for error ORA-12545)
2015-06-09 22:31:11 ERROR OGG-00664 OCI Error during OCIServerAttach (status = 12545-Error while trying to retrieve text for error ORA-12545).
ORACLE_HOME设置有问题。
解决办法：setenv (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
