Action: If you suspect the problem is the wrong type of service handler, perform these steps:If (server=value) is set is in the connect descriptor, ensure that the value is set to the appropriate service handler type for the database, that is, dedicated for dedicated server or shared for dispatchers. You can use the Listener Control utility SERVICES command to see what service handlers are currently registered with the listener. See Also: "SERVICES Command" If USE_DEDICATED_SERVER is set to ON in the sqlnet.ora file, then ensure the database is configured to use dedicated servers. If it is not, set this parameter to off. Ensure that the database instance is running. If the instance not running, start it so that it can register with the listener.
"SERVICES Command"
If USE_DEDICATED_SERVER is set to ON in the sqlnet.ora file, then ensure the database is configured to use dedicated servers. If it is not, set this parameter to off.
Ensure that the database instance is running. If the instance not running, start it so that it can register with the listener.
把数据库默认的实例改成地二个实例,
就是把注册表ORACEL下的ORACLE_SID 的值修改,
然后connect system/manager 默认是连接ORACLE_SID
设的实例,如有报错,查看报错信息。
报错和刚才是一样的,Ora_12520:TNS 监听程序无法找到需要的服务器类型的可用句柄。