AM 9.32 logon denied on Oracle 11g RAC (282 Views)
Reply
Trusted Contributor
Flavio Bianchi
Posts: 116
Registered: ‎05-11-2009
Message 1 of 3 (282 Views)
Accepted Solution

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

Trusted Contributor
Flavio Bianchi
Posts: 116
Registered: ‎05-11-2009
Message 2 of 3 (272 Views)

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)
      )
   )
)

 

HP Expert
Priya_B
Posts: 534
Registered: ‎10-25-2012
Message 3 of 3 (251 Views)

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 !
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.