Re: issue while connecting database oracle 11g (482 Views)
Reply
Trusted Contributor
vnarend
Posts: 212
Registered: ‎07-27-2011
Message 1 of 3 (499 Views)
Accepted Solution

issue while connecting database oracle 11g

Hi All,

 

Gettign the follwoignerror while connecting the database under smconfig.log

 

 

6290(  7759) 12/23/2011 18:42:58  RTE I Using "utalloc" memory manager
  6290(  7759) 12/23/2011 18:42:58  RTE I Command line: /opt/HP/ServiceManager9.30/Server/RUN/smserver -sqlverifyconnection -log:/opt/HP/ServiceManager9.30/Server/smconfig.log
  6290(  7759) 12/23/2011 18:42:58  RTE E Failed getting SIOCGIFCONF attributes of a socket.
  6290(  7759) 12/23/2011 18:42:58  RTE E OCIEnvNlsCreate() failed with return code -1, please check the ORACLE_HOME environment variable
  6290(  7759) 12/23/2011 18:42:58  RTE E Oracle SQL database connection failed
  6290(  7759) 12/23/2011 18:42:58  RTE E failed to allocate handle in sqociConnect()
  6290(  7759) 12/23/2011 18:42:58  RTE E Failed to connect to RDBMS server, terminating.
  6290(  7759) 12/23/2011 18:42:58  RTE I -Memory : S(283200) O(184828) MAX(468028) - MALLOC's Total(3850)
  6290(  7759) 12/23/2011 18:42:58  RTE I Thread termination in progress
  6290(  7759) 12/23/2011 18:42:58  RTE E Unable to obtain lock in interm().
  6290(  7759) 12/23/2011 18:42:58  RTE D Total number of recorded stacks: 0
  6290(  7759) 12/23/2011 18:42:58  RTE I Process termination cleanup complete (exit code=1)

 

Please help me what could be the issue.

 

Thanks,

VND

HP Expert
Francis Feugue
Posts: 137
Registered: ‎06-21-2007
Message 2 of 3 (487 Views)

Re: issue while connecting database oracle 11g

It looks like the ORACLE_HOME variable is not set correctly.
Advisor
Kang_C_Xu
Posts: 14
Registered: ‎06-30-2011
Message 3 of 3 (482 Views)

Re: issue while connecting database oracle 11g

Hi, Vnarend

 

Please first use sqlplus <user name>/<psw>@DBName to test Oracle connection.

 

Then please verify the environment variables set like ORACLE_HOME, TNS_PAT ...etc

 

Best Regards,

 

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.