topic oracle database in Operating System - HP-UX

oracle database

allan_48 — Thu, 31 Mar 2005 04:33:11 GMT

I've installed the oracle8 on my HP-UX system(HP-UX 11i). I've installed oracle with the option of NOT creating the database.I've created an instance already, but When I am trying to create my own database using the svrmgrl command it prompts an error saying that "ORA-12547: TNS:lost contact". This error occurs when I'm trying to use the connect internal command. I've tried to check on listener and it is ok. by the i have an oracle 7.3.4 on my system.

Regards
Allan

Re: oracle database

Peter Godron — Thu, 31 Mar 2005 04:44:24 GMT

Allan,
I assume you have set the ORACLE_SID etc.?
Also check the requirements for 8 on 11i, especially shmmax.
After that I would refer to the Oracle metlink site for troubleshooting.
Regards

Re: oracle database

Peter Godron — Thu, 31 Mar 2005 04:46:40 GMT

Allan,
sorry, as an afterthought: any details in the alert.log file?
Pete

Re: oracle database

Yogeeraj_1 — Thu, 31 Mar 2005 08:23:03 GMT

hi,

metalink note Note:115752.1 mentions about:

The need to verify your ORACLE_SID is set and exported:

For sh and ksh:
% ORACLE_SID=
% export ORACLE_SID

For csh:
% setenv ORACLE_SID

Also, why not install 8i?

regards
yogeeraj

Re: oracle database

TwoProc — Thu, 31 Mar 2005 11:09:21 GMT

Allan, why not 9i? instead of an old 8.0 system?
Ok ...
Check value of ORACLE_SID - is it correct? Is the path pointed to by ORACLE_HOME correct? Is ORACLE_HOME/bin in your path?
If those are correct try:
tnsping
or tnsping80 (depending ...)

Re: oracle database

Indira Aramandla — Thu, 31 Mar 2005 20:03:55 GMT

Hi Allan,

This error "ORA-12547: TNS:lostâ when using the svrmgrl command might happen on HP-UX 11.0 and Oracle 8i Release 2 if you do not set ORACLE_SID an environment and export it, then you will get this error message

Also check the following are set properly and exported.
ORACLE_HOME
ORACLE_SID
LD_LIBRARY_PATH
SHLIB_PATH

Attached is the note that Yogeeraj mentioned from metalink explaining resolving ORA-12547 WITH ORACLE 7.3.x to 8i on HP-UX.

Indira