Oracle Database
--
Questions
--
Followers
Top Experts
$tnsping orc
I get the following errot
used parameter files
/u00/app/oracle/product/11
Hi getting this error
TNS-03505 failed to resolve name
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Also post the results from a command prompt of: what tnsping
Make sure that the fully qualified hostname in ORACLE_HOSTNAME env variable is in the
/etc/hosts , listener.ora and tnsnames.ora files.
Regards,
Tomas Helgi
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
When I runtnsping from the server I get the error
TNS-03505.failed to resolve name
All this files are under $ORALCE_HOME/network/admin
sqlnet.ora
SQLNET.AUTHENTICATION_SERV
NAMES.DIRECTORY_PATH=(TNSN
listener.ora
LISTENER =
(DESCRIPTION_LIST
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST= abc)(PORT=1521))
)
)
tnsnames.ora
ORCL
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = abc) (PORT = 1521)0
)
(CONNECT_DATA =
(SERVER =DEDICATED)
(SERVICE_NAME = ORCL)
)
TNS-03505.failed to resolve name
All this files are under $ORALCE_HOME/network/admin
sqlnet.ora
SQLNET.AUTHENTICATION_SERV
NAMES.DIRECTORY_PATH=(TNSN
listener.ora
LISTENER =
(DESCRIPTION_LIST
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST= abc)(PORT=1521))
)
)
tnsnames.ora
ORCL
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = abc) (PORT = 1521)
)
(CONNECT_DATA =
(SERVER =DEDICATED)
(SERVICE_NAME = ORCL)
)
you're looking for "orc"
but your tns entry is "orcl"
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
TNS-03505.failed to resolve name
All this files are under $ORALCE_HOME/network/admin
sqlnet.ora
SQLNET.AUTHENTICATION_SERV
NAMES.DIRECTORY_PATH=(TNSN
listener.ora
LISTENER =
(DESCRIPTION_LIST
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST= abc)(PORT=1521))
)
)
tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = abc) (PORT = 1521)
)
(CONNECT_DATA =
(SERVER =DEDICATED)
(SERVICE_NAME = ORCL)
)
can you check it again please as getting same error
Is there only one Oracle product on that server?
You need to provide a SID_LIST_LISTENER in your listener.ora file
describing the ORACLE_HOME etc that belongs to the SID.
Also try to add (if that doesn't work) the param EZCONECT to the
NAMES.DIRECTORY_PATH=(TNSN
Regards,
Tomas Helgi
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
used parameter files
/u00/app/oracle/product/11
TNS-03505 failed to resolve name
yes
/u00/app/oracle/product/11
?
did you fix the tnsname.ora error I pointed out?
neither "orc" nor "orcl" are defined given the tnsnames.ora you have specified because it has improper content
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Yes
Again, the TNS-03505 is not listener related.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
/u00/app/oracle/product/11
ls -al /u00/app/oracle/product/11
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
-wr-r--r--
listener.ora
tnsnames.ora
sqlnet.ora
shrept.lst
sqlnet.ora
it should be easier for you and it makes sure the content is preserved
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
-rw-r--r-- 1 oracle oracle dba 830 set 12 12:12 listener sameowner for all the files
From a command prompt post the results of:
export TNS_ADMIN=/u00/app/oracle/
tnsping orcl
Is there a reason you cannot copy/paste the screen results?
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
i have got the solution from the previous answers
We were just curious as to the final solution.
Personally I wasn't aware that the tnsnames.ora file needed at least one comment at the top. I knew it was picky about syntax but not that picky.
Feel free to accept your last post as the answer. This might help others in the future.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
If you receive the emails from this question saying 'Objection Posted', it is a bug. No one is objecting to the closure.
A bug has been filed on this issue.
having a # on a blank line won't hurt your tnsnames.ora
if you had the # on one of the lines in your ORCL stanza then it would mess it up.
I agree with the sentiment above.
If we were helpful, then split however you feel is appropriate.
If we were not, then don't give either of us points.
Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Oracle Database
--
Questions
--
Followers
Top Experts
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.