UNSOLVED

ashxos

updated

18 years ago

A

ashxos

142 Posts

0

4641

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?
  • ashxos

    142 Posts

    1808

    0

    Posted 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]::.
  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    1808

    0

    Posted 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.
  • ashxos

    142 Posts

    1808

    0

    Posted 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]::.
  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    1808

    0

    Posted 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).
  • ashxos

    142 Posts

    1808

    0

    Posted 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...
  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    1808

    0

    Posted April 1st, 2009 01:00

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

    142 Posts

    1808

    0

    Posted April 1st, 2009 06:00

    OK!
  • mridulsingh

    41 Posts

    1808

    0

    Posted 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
    }
  • cfaller

    96 Posts

    1808

    0

    Posted 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 ?
  • SabarnaDeb

    2 Intern

    •

    139 Posts

    214

    0

    Posted 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.