Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

oracle database

SOLVED
Go to solution
allan_48
Occasional Contributor

oracle database

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
5 REPLIES
Peter Godron
Honored Contributor

Re: oracle database

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
Peter Godron
Honored Contributor

Re: oracle database

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

Re: oracle database

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
TwoProc
Honored Contributor

Re: oracle database

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

We are the people our parents warned us about --Jimmy Buffett
Indira Aramandla
Honored Contributor

Re: oracle database

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
Never give up, Keep Trying