Home » RDBMS Server » Server Administration » tnsping sqlnet.ora not listing (Oracle 12c, linux)
tnsping sqlnet.ora not listing [message #685810] Thu, 31 March 2022 10:53 Go to next message
Messages: 73
Registered: August 2008

i am kind of confuse on the issue of tnsping.

when i do tnsping dbname:

it resolves fine but it does not list parameter file: sqlnet.ora Please help on that...

used parameter file: does not list

[user@servernam dbhome_1]$ tnsping dbname

TNS Ping Utility for Linux: Version - Production on 31-MAR-2022 10:45:33

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = servername)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dbname)))
OK (0 msec)
Re: tnsping sqlnet.ora not listing [message #685812 is a reply to message #685810] Thu, 31 March 2022 14:37 Go to previous message
Michel Cadot
Messages: 68597
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have you a sqlnet.ora file?
Is it accessible?
Is it in the default path or in TNS_ADMIN one?

If tnsping does not show it this is because it does not find and use it.

[Updated on: Thu, 31 March 2022 14:39]

Report message to a moderator

Previous Topic: Large SHARED_POOL_RESERVED_SIZE, inflated V$SQL
Next Topic: Defragmentation of partitioned indexes to reclaim space.
Goto Forum:

Current Time: Sat Feb 24 01:16:14 CST 2024