Unsolved

This post is more than 5 years old

142 Posts

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?

142 Posts

March 31st, 2009 05:00

I am littlebit sure about current Net Service Name (ENCORA), as when i am putting that I am getting "insufficient privileges" error,

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]::.

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

March 31st, 2009 05:00

Check http://ora-12154.ora-code.com/

With NW, you can get this when you have not default installation so TNS_ADMIN needs to be set in nmo script.

142 Posts

March 31st, 2009 05:00

I am still not confirmed with the NET SERVICE NAME

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]::.

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

March 31st, 2009 05:00

Well, Oracle says permissions are the issue. That means that your Oracle user for database or catalog (if used) do not have required permission (roles granted in Oracle language).

142 Posts

March 31st, 2009 22:00

Is their any way to find out the current user is having which permissions?

So that I can drill down more...

6 Operator

 • 

14.4K Posts

 • 

56.2K Points

April 1st, 2009 01:00

Yes, you can do that in Oracle SQL. But simply leave that to Oracle guy - this is their part.

142 Posts

April 1st, 2009 06:00

OK!

41 Posts

April 4th, 2009 08:00

Hi,

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
}

96 Posts

April 5th, 2009 22:00

On Linux/Unix systems, Networker runs under the root account, check that root is part of the dba group.
Is this on a cluster ? are you using Oracle.NET ?

2 Intern

 • 

139 Posts

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.

No Events found!

Top