Creating the ORACLE instance doesn't work with "sqlplus /nolog" command instead of "svrmgrl"

[Engo Bokoko]

Hi there.

Just to remind you that we're not migrating from 7.3.4 to 8.0.6 yet.

I'd like to create another instance by using the Command "sqlplus /nolog" not "svrmgrl" because of the future migration to 9i version which recommands us to use "sqlplus /nolog".

I've followed your instructions and this is what I've found :

1. the "svrmgrl" command allows me to startup the database after commenting/removing hte parmater LOCK_SHARED_MEMORY setted in the initora123.ora file (With this, I'm happy and thanks for your assistance)

------------------------------------------------------------------------

# By default, this is false.
#lock_shared_memory = false

# define parallel server (multi-instance) parameters
# ifile = ora_system:initps.ora

# define two control files by default
control_files = ($ORACLE_HOME/admin/etrecia/oradata/ctrl1ora123.ctl,$ORACLE_HOME
/admin/etrecia/oradata/ctrl2ora123.ctl,$ORACLE_HOME/admin/etrecia/oradata/ctrl3o
ra123.ctl)
compatible=8.0.6.0.0
~
~
~
"initora123.ora" 164 lines, 7780 characters

cyb_hpux [ /cyborg/app/oracle/product/806/bin ] $ echo $ORACLE_HOME
/cyborg/app/oracle/product/806
cyb_hpux [ /cyborg/app/oracle/product/806/bin ] $ echo $ORACLE_SID
ora123

cyb_hpux [ /cyborg/app/oracle/product/806/bin ] $ svrmgrl

Oracle Server Manager Release 3.0.6.0.0 - Production

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

Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
PL/SQL Release 8.0.6.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> connect system/manager as sydba
MGR-03525: expected SYSDBA or SYSOPER, not "sydba"
SVRMGR> connect system/manager as sysdba
Connected.
SVRMGR> startup nomount
ORACLE instance started.
Total System Global Area 8682472 bytes
Fixed Size 52200 bytes
Variable Size 6299648 bytes
Database Buffers 2252800 bytes
Redo Buffers 77824 bytes
SVRMGR> shutdown
ORA-01507: database not mounted
ORACLE instance shut down.
SVRMGR> quit
Server Manager complete.
cyb_hpux [ /cyborg/app/oracle/product/806/bin ] $ sqlplus /nolog

SQL*Plus: Release 8.0.6.0.0 - Production on Fri Mar 8 10:19:19 2002

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SQL> connect system/manager as sysdba
Connected.
SQL> startup nomount
unknown command beginning "startup no..." - rest of line ignored.
SQL>

------------------------------------------------------------------------

2. the 'sqlplus' command doesn't allow me to startup the ORACLE instance:

cyb_hpux [ /cyborg/app/oracle/product/806/bin ] $ sqlplus /nolog

SQL*Plus: Release 8.0.6.0.0 - Production on Fri Mar 8 10:12:17 2002

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SQL> conn system/manager as sysdba
Connected.
SQL> startup nomount
unknown command beginning "startup no..." - rest of line ignored.
SQL> quit
ERROR:
ORA-01012: not logged on

Disconnected

=========================================================================

Would you please explain me why "sqlplus /nolog" command can not be run successfully with Version 8.x? (Because it is a part of Oracle 8 Entreprise Edition, we have the choice to select one of the two commands).

I'll appreciate your assistance.

Best Regards,

Engo.

[Steven Gillard_2 · Accepted solution]

I believe that the full set of svrmgrl commands weren't available in sqlplus until 8i (8.1.5 and up). So in 8.0.6 I you're stuck with using svrmgrl.

Regards,
Steve