Operating System - HP-UX
1753500 Members
4121 Online
108794 Solutions
New Discussion юеВ

Oracle 8.0.5 svrmgrl startup problem

 
jacky400
Advisor

Oracle 8.0.5 svrmgrl startup problem

OS:11.0 32-bit
Database:Oracle 8.0.5

when i start the svrmgrl ,i have following problem (it is a fresh install)

oracle@osstest%svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> connect internal/oracle
Connected.
SVRMGR> startup
ORA-03113: end-of-file on communication channel
SVRMGR> connect internal/oracle
Connected.
SVRMGR> oradebug ipc
Shared memory information written to trace file.
-------------------- Semaphores --------------------
Total number of semaphores = 25
Number of semaphores per set = 25
Number of semaphore sets = 1
Semaphore identifiers:
13287
SVRMGR>


All the semaphores kernel parameter like semmnni,semmus etc is set to max allowable value
3 REPLIES 3
Brian Crabtree
Honored Contributor

Re: Oracle 8.0.5 svrmgrl startup problem

Check your alert log for error messages.

You can find this file in your background_dump_dest location under alert_SID.log or in the $ORACLE_HOME/rdbms/log directory (same name).

Most likely, you have a bad parameter in your init.ora (located in $ORACLE_HOME/dbs), however it might show up in the alertlog. Otherwise, you will have to go through the pfile and see if you can find the error. Oracle doesn't like tabs in this file, so I would check for that first.

Hope this helps.

Thanks,

Brian
Thierry Poels_1
Honored Contributor

Re: Oracle 8.0.5 svrmgrl startup problem

hi,

next to the init.ora also check your kernel parameters. When running more than 1 DB you might need to increase the advised defaults.

Try to avoid the habbit of using svrmgr, it's obsoleted as of Oracle8, and will not be supplied anymore with Oracle9 and above. Use "sqlplus /nolog" + "connect / as sysdba". If you start replacing svrmgr with sqlplus now, then you'll have less work when you migrate to Oracle9. (talking out of experience ;)

regards,
Thierry.
All unix flavours are exactly the same . . . . . . . . . . for end users anyway.
Victor Fridyev
Honored Contributor

Re: Oracle 8.0.5 svrmgrl startup problem

Hi,

It seems to me you fogot to define ORACLE_SID and unset TWO_TASK. Please check your ORACLE environment.
Entities are not to be multiplied beyond necessity - RTFM