Instance "orcl1", status READY, has 1 handler(s) for this service...Service "pdb1" has 1 ...
Service "orclXDB" has 1instance(s). Instance "orcl1", status READY, has 1 handler(s) for thisservice... Handler(s): "D000" established:0 refused:0 current:0 max:1022 state:ready DISPATCHER <machine: db1, pid: 2167> (ADDRESS=(PROTOCOL=tcp)(HOST=db1.tianlesoftware.com)(PORT=38731))...
Instance "your_instance_name", status READY, has 1 handler(s) for this service... 如果实例没有注册到监听器,你可能需要检查数据库实例的配置或网络连接问题。 通过以上步骤,你应该能够诊断并解决 ora-12514 错误。如果问题仍然存在,可能需要进一步检查网络配置或联系数据库管理员。
Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully 命令:[oracle@gpdb ~]$ sqlplus / as sysdba SQL> startup SQL> alter system register; SQL> quit [oracle@gpdb ~]$ lsnrctl status 输出: LSNRCTL for ...
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully启动后,提示Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...这个提示一般认为很正常,是由于实例没有注册到监听服务中去,于是注册实例SQL> alter system register; System alte...
oracle 11g LSNRCTL> servicesConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=primary-orcl)(PORT=1521)))Services Summary...Service "primary" has 1 instance(s).Instance "orcl",status UNKNOWN,has 1 handler(s) for this service...Handler(s):"DEDICA
Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl)(PORT=1521))) Services Summary... Service "cdb1" has1instance(s). Instance "cdb1", status READY, has1handler(s)forthis service... Handler(s): "DEDICATED" established:0refused:0state:readyLOCALSERVER ...
Service "test0924XDB" has 1 instance(s). Instance "test0924", status READY, has 1 handler(s) for this service... The command completed successfully 监听程序控制实用程序的语法 可以从实用程序内部(提示符语法)或命令行发出lsnrctl命令。以下两个命令具有 ...
3.然后直接google Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... 网上说可能是/etc/hosts问题,参考:http://gaoshan.blog.51cto.com/742525/477281 我的hosts 是 192.168.0.10 fansyPC 没有问题,但是需要 127.0.0.1 localhost 这一句?加上后,重新启动完成。
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully 命令:[oracle@gpdb ~]$ sqlplus / as sysdba SQL> startup SQL> alter system register; SQL> quit [oracle@gpdb ~]$ lsnrctl status ...