合 OGG-02615和OGG-00664 Oracle连接问题
Tags： 故障处理OGGOGG-02615OGG-00664
👉 本文共约446个字，系统预计阅读时间或需2分钟。
目录
- OGG-02615和OGG-00664
- OGG-00664 OCI Error ORA (status = 12545-ORA-12545: Connect failed because target host or object does not exist
- OGG-00664 OCI Error during OCIServerAttach (status = 12541-ORA-12541: TNS:no listener)
- OGG-00664 OCI Error during OCIServerAttach (status = 12545-Error while trying to retrieve text for error ORA-12545)
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进程即可。
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
