IT Asset Manager / Connect-IT Support and News Forum
Showing results for 
Search instead for 
Do you mean 

AM 9.32 logon denied on Oracle 11g RAC

SOLVED
Go to Solution
Trusted Contributor

AM 9.32 logon denied on Oracle 11g RAC

Hi experts,

I'm facing an error while trying to connect from AM 9.32 client to an Oracle 11g RAC.

 

My TNS looks like:

AMPROD = 
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = srv2)(PORT = 1521))
   (ADDRESS = (PROTOCOL = TCP)(HOST = srv3)(PORT = 1521))
   (LOAD_BALANCE = YES)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = AMPROD)
     (FAILOVER_MODE =
       (BACKUP = AMPROD_PRECONNECT)
         (TYPE = SELECT)(METHOD = PRECONNECT)(RETRIES = 180)(DELAY = 5)
      )
   )
)

AMPROD_PRECONNECT =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = srv2)(PORT = 1521))
   (ADDRESS = (PROTOCOL = TCP)(HOST = srv3)(PORT = 1521))
   (LOAD_BALANCE = YES)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = AMPROD_PRECONNECT)
     (FAILOVER_MODE =
       (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5)
     )
   )
)

 I can retrieve a response with a TNSPING and can connect with SQLPLUS and everything was fine.

 

If i try to connect with AM Client i receive this error:

// Application: HP Asset Manager 9.32.9772
// Executable: C:\Program Files\HP\Asset Manager 9.32 en\bin\am.ovl
// User: bianchi

2013/11/20 10:17:13.262 0 1 [Thrd#:3580](-2006) Oracle error: ORA-01017: invalid username/password; logon denied
2013/11/20 10:17:13.262 0 1 [Thrd#:3580](-2006) Unable to connect to database 'AMPROD' (UserId='admin'). Oracle code=-1
2013/11/20 10:17:13.262 0 1 [Thrd#:3580](-2006) Unable to connect to this database engine.

 

Oviously username and password are correct.

 

Please help...

1 ACCEPTED SOLUTIONS
Trusted Contributor

Re: AM 9.32 logon denied on Oracle 11g RAC

Ok,

Solution found with our dba.

Both entrys in tns need BASIC as method.

 

AMPROD = 
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = srv2)(PORT = 1521))
   (ADDRESS = (PROTOCOL = TCP)(HOST = srv3)(PORT = 1521))
   (LOAD_BALANCE = YES)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = AMPROD)
     (FAILOVER_MODE =
       (BACKUP = AMPROD_PRECONNECT)
         (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5)
      )
   )
)

 

2 REPLIES
Trusted Contributor

Re: AM 9.32 logon denied on Oracle 11g RAC

Ok,

Solution found with our dba.

Both entrys in tns need BASIC as method.

 

AMPROD = 
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = srv2)(PORT = 1521))
   (ADDRESS = (PROTOCOL = TCP)(HOST = srv3)(PORT = 1521))
   (LOAD_BALANCE = YES)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = AMPROD)
     (FAILOVER_MODE =
       (BACKUP = AMPROD_PRECONNECT)
         (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5)
      )
   )
)

 

Highlighted
HPE Expert

Re: AM 9.32 logon denied on Oracle 11g RAC

Thanks good info Flavio !

HP Support - If this post or any post helps you resolve an issue, please be sure to mark it as an acceptable solution.
Like a post, Please click Kudos to show appreciation !