issue while connecting database oracle 11g (448 Views)
Reply
Trusted Contributor
vnarend
Posts: 206
Registered: ‎07-27-2011
Message 1 of 3 (448 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

Please use plain text.
HP Expert
Francis Feugue
Posts: 137
Registered: ‎06-21-2007
Message 2 of 3 (436 Views)

Re: issue while connecting database oracle 11g

It looks like the ORACLE_HOME variable is not set correctly.
Please use plain text.
Advisor
Kang_C_Xu
Posts: 13
Registered: ‎06-30-2011
Message 3 of 3 (431 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,

 

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