Re: Oracle not available

Did you set the ORACLE_SID variable? That's most likely the cause of your problem.

Alex Ivascu

"roblop" <roblop_at_friko2.onet.pl> wrote in message news:adbgf5$2801$1_at_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:33:56 CDT