Oracle not available

From: roblop <roblop_at_friko2.onet.pl>
Date: Sun, 2 Jun 2002 00:07:02 +0200
Message-ID: <adbgf5$2801$1@news2.ipartners.pl>

Oracle 8.1.7.0.0 on Solaris 10/01 without patch.

I connect to database as internal with svrmgrl. I type startup and ENTER. Database will open properly. I shutdown database (shutdown immediate). I exit svrmgrl.
Now I startup database with dbstart script: su - root, cd /etc/init.d, ./oracle start. Database will open properly. Now I type exit and as user oracle connect as internal with svrmgrl (connect internal). I type select * from dual; and I have error ORA-01034 ORACLE NOT AVAILABLE.
I check processes:
ps -ef | grep oracle

 oracle  1567     1  0 23:49:58 ?        0:00 ora_snp2_WAR1
  oracle  1557     1  0 23:49:57 ?        0:00 ora_ckpt_WAR1
  oracle  1551     1  0 23:49:57 ?        0:00 ora_pmon_WAR1
  oracle  1555     1  0 23:49:57 ?        0:00 ora_lgwr_WAR1
  oracle  1553     1  0 23:49:57 ?        0:00 ora_dbw0_WAR1
  oracle  1559     1  0 23:49:57 ?        0:00 ora_smon_WAR1

I my opinion OK.

I connect as internal with svrmgrl but this time with alias (connect internal_at_war1). I type select * from dual; and no error.

Why connect internal doesn't connect properly ? Where is error ? What's wrong ?

Regards, Roblop. Received on Sat Jun 01 2002 - 17:07:02 CDT