| Automatic database startup and shutdown [message #420795] |
Wed, 02 September 2009 05:21  |
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
|
Member |
|
|
hi all,
i have an oracle 10 db. i am configuring the automatic dbstart on the solaris server. while testing the scripts manually, i am getting an error;
SUN6>/etc/init.d/dbstart start
/etc/init.d/dbstart: test: argument expected
SUN6>
please help.
Sailesh
|
|
|
|
| Re: Automatic database startup and shutdown [message #420834 is a reply to message #420795] |
Wed, 02 September 2009 09:43  |
TomG
Messages: 11
Registered: December 2008
|
Junior Member |
|
|
Hi
I don't know the content of your script but I'm not sure you should run this one manually.
Did you try the $ORACLE_HOME/bin/dbstart instead ?
This should raise the instances pointed by "Y"(es) in oratab file.
Tom
|
|
|
|
|
|
| Re: Automatic database startup and shutdown [message #420848 is a reply to message #420795] |
Wed, 02 September 2009 10:56 |
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
|
Member |
|
|
Hi,
The database started when i did a ps -ef|grep smon. But after verifying the log files, i got an error:
bash-3.00# more /oracle/app/oracle/product/10gdb/startup.log
./dbstart: Starting up database "webcms"
Wed Sep 2 19:24:15 MUT 2009
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 2 19:24:16 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 1660944384 bytes
Fixed Size 1979104 bytes
Variable Size 721423648 bytes
Database Buffers 922746880 bytes
Redo Buffers 14794752 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Produc
tion
With the Partitioning, OLAP and Data Mining options
./dbstart: Database instance "webcms" warm started.
./dbstart: Starting up database "ghtest"
Wed Sep 2 19:24:28 MUT 2009
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 2 19:24:28 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 1325400064 bytes
Fixed Size 1978464 bytes
Variable Size 335548320 bytes
Database Buffers 973078528 bytes
Redo Buffers 14794752 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Produc
tion
With the Partitioning, OLAP and Data Mining options
./dbstart: Database instance "ghtest" warm started
can just help?
Sailesh
|
|
|
|
|
|
| Re: Automatic database startup and shutdown [message #420876 is a reply to message #420856] |
Wed, 02 September 2009 23:24 |
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
|
Member |
|
|
hi,
Please find results:
SUN6>pwd
/oracle/app/oracle/product/10gdb
SUN6>env | sort
ORACLE_SID=ghtest
export ORACLE_SID
sqlplus
/ as sysdba
shutdown abort
startup
exitHOME=/home/oracle
HOSTNAME=sun6
HZ=100
LANG=C
LD_LIBRARY_PATH=:/oracle/app/oracle/product/10gdb/lib:/oracle/app/oracle/product/10gdb/network/lib
LOGNAME=oracle
MAIL=/var/mail/oracle
ORACLE_BASE=/oracle/app/oracle
ORACLE_HOME=/oracle/app/oracle/product/10gdb
ORACLE_SID=ghtest
PATH=/oracle/app/oracle/product/10gdb/bin:/usr/bin:/usr/sfw/bin:/usr/bin:/usr/ucb:/etc:.
SHELL=/bin/sh
TERM=xterm
TZ=Indian/Mauritius
SUN6>SUN6>SUN6>
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 3 08:21:05 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> ORACLE instance shut down.
SQL> ORACLE instance started.
Total System Global Area 1325400064 bytes
Fixed Size 1978464 bytes
Variable Size 335548320 bytes
Database Buffers 973078528 bytes
Redo Buffers 14794752 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
SQL>
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
