ORA-01034: ORACLE not available

Hello,
I have Oracle8 running on a Solaris box. I am plagued by this 01034 error message. I've read through all of the posts regarding this issue and have not found a resolution.

I have checked: ps -ef and produced the following output:

dbauser  1800     1  0 13:00:43 ?        0:00 ora_dbw0_LEAF
dbauser  1798     1  0 13:00:43 ?        0:00 ora_pmon_LEAF
dbauser  1804     1  1 13:00:43 ?        0:08 ora_ckpt_LEAF
dbauser  1802     1  0 13:00:43 ?        0:00 ora_lgwr_LEAF
dbauser  1808     1  0 13:00:43 ?        0:00 ora_reco_LEAF

I can also connect (using svrmgrl and sqlplus) internal and query the database with NO problem. When I try to connect using tnsnames.ora I get the ORA-01034 message.

I have also checked my /etc/system file and made sure my settings where correct, and they appear to be:

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=200
set semsys:seminfo_semmni=70

My ORACLE_HOME, ORACLE_SID and TNS_ADMIN variables are all set properly. I have also made sure that the tnslsnr is running and that I have a proper entry in the listener.ora file.

What else could be the cause of this strange behavior? I have examined my trace files and have found nothing to clue me into why Oracle is not there (when it is clearly *there*). I have also examined the .trc files in $ORACLE_HOME/rdbms/log and looked for stack traces and only found the ORA-01034 message.

I have also checked the connectivity using tnsping and trcroute and connectivity is not an issue. Is there anything I may have overlooked? I am nearing my whits-end on this bloody thing. Any guidance, or pointers would be most appreciated.

Regards,
Dave Palmer

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 19 1999 - 13:13:24 CST