connect to remote database via sqlnet

Hi all,

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.DIRECTORY_PATH= (ONAMES)
NAMES.PREFERRED_SERVERS = (ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1575))
(ADDRESS=(PROTOCOL=TCP)(HOST=server0)(PORT=1575)))


#NAMES.DEFAULT_DOMAIN = domain.com

#SQLNET.AUTHENTICATION_SERVICES= (NTS)

#SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf

It is possible to replay, if you also post tnsnames.ora and listener.ora file.

Regards,
Rems, DBA from Latvia

tnsnames.ora:

DEV=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = p608469)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dev)
)
)

listener.ora:

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = P608469)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(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

Quote:

---

Originally posted by leonard905
Hi all,

How can I connect to a remote database using sqlnet.ora.

---

It's simple, you can't.

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.