Re: AM 9.32 logon denied on Oracle 11g RAC (170 Views)
Reply
Trusted Contributor
Flavio Bianchi
Posts: 110
Registered: ‎05-11-2009
Message 1 of 3 (201 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...

Please use plain text.
Trusted Contributor
Flavio Bianchi
Posts: 110
Registered: ‎05-11-2009
Message 2 of 3 (191 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)
      )
   )
)

 

Please use plain text.
HP Expert
Priya_B
Posts: 534
Registered: ‎10-25-2012
Message 3 of 3 (170 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 !
Please use plain text.
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