Connecting to ASM instance remotely using Oracle Net and tools like SQL*Plus.
This note will resolve help resolve the following errors when trying to connect to an ASM isntance remotely
ORA-12505 TNS:listener could not resolve SID given in connect descriptor
ORA-12541: TNS:no listener
ORA-15000: command disallowed by current instance type
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ORA-1031: insufficient privileges
This solution cannot be accomplished using Network Manager (GUI)
The solution is to
* Edit the listener.ora on ASM server
* Edit the tnsnames.ora on the client
* Setup your remote login password for your ASM instance on the ASM server
* Set your SYS password using ORAPWD for the ASM instance
* Use the properly formatted connect string to connect with your tool
Ver el procedimiento en la nota:
How to connect to ASM instance from a remote client (Oracle Net) (Doc ID 340277.1)
No hay comentarios:
Publicar un comentario