How can I connect to a remote database using sqlnet.ora. I modify the contents of the sqlnet.ora file and made several attempts to connect via sqlplus but unsuccessful. Got a ora-12154 error message. Is anything wrong with my sqlnet.ora configuration? I also have a local db on my machine. Below is the contents of the sqlnet.ora file:
AUTOMATIC_IPC = OFF
SQLNET.EXPIRE_TIME = 2147483647
trace_level_client = off
trace_file_client = sqlnet
log_file_client = sqlnet
names.default_domain = world
name.default_zone = world
NAMES.PREFERRED_SERVERS = (ADDRESS_LIST =
#NAMES.DEFAULT_DOMAIN = domain.com
#SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf
It is possible to replay, if you also post tnsnames.ora and listener.ora file.
Rems, DBA from Latvia
(ADDRESS = (PROTOCOL = TCP)(HOST = p608469)(PORT = 1521))
(SERVICE_NAME = dev)
(ADDRESS = (PROTOCOL = TCP)(HOST = P608469)(PORT = 1521))
(GLOBAL_DBNAME = dev)
(ORACLE_HOME = c:\)
(SID_NAME = dev)
Any help? I have listed the contents of tnsnames.ora and listener.ora files above.
any suggestions is helpful
It's simple, you can't.
Originally posted by leonard905
How can I connect to a remote database using sqlnet.ora.
Until you can use sqlplus to connect to your remote database, your database links will never work (basically). Configure your client. Once your client is configured and you can connect via sqlplus, you will be able to connect through a db link.
It looks like you are using Oracle Names as your naming method. Make sure your remote db is listed in your names server.
Click Here to Expand Forum to Full Width