-
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
leonard905
leonard905@yahoo.com
-
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)
)
)
leonard905
leonard905@yahoo.com
-
Any help? I have listed the contents of tnsnames.ora and listener.ora files above.
any suggestions is helpful
leonard905
leonard905@yahoo.com
-
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|