Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Highlighted
Trusted Contributor.. Flavio Bianchi Trusted Contributor..
Trusted Contributor..
718 views

AM 9.32 logon denied on Oracle 11g RAC

Jump to solution

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

Tags (1)
0 Likes
1 Solution

Accepted Solutions
Trusted Contributor.. Flavio Bianchi Trusted Contributor..
Trusted Contributor..

Re: AM 9.32 logon denied on Oracle 11g RAC

Jump to solution

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

 

0 Likes
2 Replies
Trusted Contributor.. Flavio Bianchi Trusted Contributor..
Trusted Contributor..

Re: AM 9.32 logon denied on Oracle 11g RAC

Jump to solution

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

 

0 Likes
Priya_B Absent Member.
Absent Member.

Re: AM 9.32 logon denied on Oracle 11g RAC

Jump to solution

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 !
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.