Service Manager / Service Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

issue while connecting database oracle 11g

SOLVED
Go to Solution
Trusted Contributor

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

2 REPLIES
HPE Expert

Re: issue while connecting database oracle 11g

It looks like the ORACLE_HOME variable is not set correctly.
Highlighted
Advisor

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,