Paginas

2014-01-28

Conexión remota a una instancia ASM

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