Pessoal nao consigo utilizar o sqlplus , alguem pode me ajudar abaixo o
sqlnet.ora tnsnames.ora e listener.ora
NULL /u01/app/oracle/product/10.1.0/network/admin > more sqlnet.ora
NAMES.DEFAULT_DOMAIN = localdomain
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
more listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.51.162.10)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = site1)
(GLOBAL_DB_NAME = site1)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0)
)
(SID_DESC =
(SID_NAME = cent1)
(GLOBAL_DB_NAME = cent1)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0)
)
(SID_DESC =
(SID_NAME = site2)
(GLOBAL_DB_NAME = site2)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0)
)
(SID_DESC =
(SID_NAME = cent2)
(GLOBAL_DB_NAME = cent2)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0)
)
(SID_DESC =
(SID_NAME = site3)
(GLOBAL_DB_NAME = site3)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0)
)
(SID_DESC =
(SID_NAME = cent3)
(GLOBAL_DB_NAME = cent3)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0)
)
)
TRACE_LEVEL_LISTENER = 16
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
logging = off
logging LISTENER = off
Tnsnames.ora
DEV.server.servidor.site3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.51.162.10)(PORT = 1521))
)
(CONNECT_DATA =
(SID = site3)
)
)
=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.51.162.10)(PORT = 1521))
)
(CONNECT_DATA =
(SID = site3)
)
)
Flickr agora em português. Você clica, todo mundo vê. Saiba mais.
[As partes desta mensagem que não continham texto foram removidas]