Unsolved
This post is more than 5 years old
142 Posts
0
4563
March 31st, 2009 04:00
ORA-12154 TNS:could not resolve service name : ORACLE BACKUP
Hi All,
We are configuring ORACLE host backup.
We have installed Agent on the same. And now while creating the client it is giving following error :
Database connection failed for OraServiceName ORA-12154 TNS:could not resolve service name.
What will be the reason?
We are configuring ORACLE host backup.
We have installed Agent on the same. And now while creating the client it is giving following error :
Database connection failed for OraServiceName ORA-12154 TNS:could not resolve service name.
What will be the reason?
No Events found!


ashxos
142 Posts
0
March 31st, 2009 05:00
while when I am putting "abcd or anything" it is giving "Database connection failed for OraServiceName ORA-12154 TNS:could not resolve service name" this error
My Database Admin told me that the username and password given to you is correct.
So what will be the reason for refusing my connection?
Message was edited by:
.::[ashX]::.
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
March 31st, 2009 05:00
With NW, you can get this when you have not default installation so TNS_ADMIN needs to be set in nmo script.
ashxos
142 Posts
0
March 31st, 2009 05:00
Now I have changed the service name to ENCORA (I hope so it is right)
Now it is giving following error :
Database connection failed for ENCORA: ORA-01031 : insufficient privileges
I am not sure that it is right or not.
Message was edited by:
.::[ashX]::.
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
March 31st, 2009 05:00
ashxos
142 Posts
0
March 31st, 2009 22:00
So that I can drill down more...
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
April 1st, 2009 01:00
ashxos
142 Posts
0
April 1st, 2009 06:00
mridulsingh
41 Posts
0
April 4th, 2009 08:00
You need to check if the service for the oracle instance you are trying to backup is running on the DB server. Also to take the oracle backup you could try to connect with RMAN using sys as:
connect target sys/password@DB_instance
{
Scritp
}
cfaller
96 Posts
0
April 5th, 2009 22:00
Is this on a cluster ? are you using Oracle.NET ?
SabarnaDeb
2 Intern
•
139 Posts
0
March 16th, 2012 03:00
Create separate unique Net_Service_name only for networker backup, not for other applications or processes etc. In my case, it is working.