Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Engo Bokoko
Occasional Contributor

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

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.
After Remembering Myself, Anything Desappears.
1 REPLY
Steven Gillard_2
Honored Contributor
Solution

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

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