Is the database opened with the same $ORACLE_HOME in the script run by root
as when you start it as oracle? Check $PATH and $LD_LIBRARY_PATH too in both
startup methods.
roblop <roblop_at_friko2.onet.pl> schreef in berichtnieuws
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:47:23 CDT
