| Automatic Startup - second instance [message #330867] |
Tue, 01 July 2008 09:37  |
marcossantos
Messages: 123
Registered: June 2008
|
Senior Member |
|
|
I have two instance in a Database Server. I have to implement automatic startup for the two instance. For only one, its work. But, when I add other instance, not work.
My code in /etc/init.d/oracle:
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole"
su - $ORA_OWNER -c "$ORA_HOME/bin/isqlplusctl start"
;;
'stop')
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME"
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNER -c "$ORA_HOME/bin/isqlplusctl stop"
su - $ORA_OWNER -c "$ORA_HOME/bin/emctl stop dbconsole"
;;
How can I auto starting two instance after reboot?
Marcos
|
|
|
|
|
|
|
|
|
|
| Re: Automatic Startup - second instance [message #330889 is a reply to message #330867] |
Tue, 01 July 2008 12:31  |
marcossantos
Messages: 123
Registered: June 2008
|
Senior Member |
|
|
Thanks.
There are this: alert_rman.log in .../admi/bdump.
..........................................................
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 1
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 285212672
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 0
sga_target = 1258291200
__streams_pool_size = 0
sga_target = 1258291200
control_files = /dados/control/rman/control01.ctl, /dados/control/rman/control02.ctl, /dados/control/oradata/rman/control03.ctl
db_block_size = 8192
__db_cache_size = 922746880
compatible = 10.2.0.1.0
log_archive_format = arch_%d_%t_%r_%s.arc
db_file_multiblock_read_count= 16
db_recovery_file_dest = /dados/db/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=rmanXDB)
job_queue_processes = 10
background_dump_dest = /dados/db/oracle/admin/rman/bdump
user_dump_dest = /dados/db/oracle/admin/rman/udump
core_dump_dest = /dados/db/oracle/admin/rman/cdump
audit_file_dest = /dados/db/oracle/admin/rman/adump
db_name = rman
open_cursors = 300
pga_aggregate_target = 418381824
PMON started with pid=2, OS id=2184
PSP0 started with pid=3, OS id=2186
MMAN started with pid=4, OS id=2188
DBW0 started with pid=5, OS id=2190
LGWR started with pid=6, OS id=2192
CKPT started with pid=7, OS id=2194
SMON started with pid=8, OS id=2196
RECO started with pid=9, OS id=2198
CJQ0 started with pid=10, OS id=2200
MMON started with pid=11, OS id=2202
Tue Jul 1 09:28:11 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2204
Tue Jul 1 09:28:11 2008
starting up 1 shared server(s) ...
Tue Jul 1 09:28:11 2008
starting up 1 shared server(s) ...
Tue Jul 1 09:28:11 2008
ALTER DATABASE MOUNT Tue Jul 1 09:28:16 2008
Setting recovery target incarnation to 2
Tue Jul 1 09:28:16 2008
Successful mount of redo thread 1, with mount id 1545378348
Tue Jul 1 09:28:16 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Jul 1 09:28:16 2008
ALTER DATABASE OPEN
Tue Jul 1 09:28:16 2008
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Tue Jul 1 09:28:16 2008
Started redo scan
Tue Jul 1 09:28:16 2008
Completed redo scan
34 redo blocks read, 19 data blocks need recovery
Tue Jul 1 09:28:16 2008
Started redo application at
Thread 1: logseq 10, block 2012
Tue Jul 1 09:28:16 2008
Recovery of Online Redo Log: Thread 1 Group 3 Seq 10 Reading mem 0
Mem# 0 errs 0: /dados/redolog/rman/redo03.log
Tue Jul 1 09:28:16 2008
Completed redo application
Tue Jul 1 09:28:16 2008
Completed crash recovery at
Thread 1: logseq 10, block 2046, scn 807346
19 data blocks read, 19 data blocks written, 34 redo blocks read
Tue Jul 1 09:28:16 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=2220
Tue Jul 1 09:28:16 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=20, OS id=2222
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=20, OS id=2222
Tue Jul 1 09:28:16 2008
Thread 1 advanced to log sequence 11
Thread 1 opened at log sequence 11
Current log# 1 seq# 11 mem# 0: /dados/redolog/rman/redo01.log
Successful open of redo thread 1
Tue Jul 1 09:28:16 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jul 1 09:28:16 2008
ARC0: STARTING ARCH PROCESSES
Tue Jul 1 09:28:16 2008
SMON: enabling cache recovery
Tue Jul 1 09:28:16 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
db_recovery_file_dest_size of 2048 MB is 28.56% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Jul 1 09:28:16 2008
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=21, OS id=2224
Tue Jul 1 09:28:16 2008
Successfully onlined Undo Tablespace 1.
Tue Jul 1 09:28:16 2008
SMON: enabling tx recovery
Tue Jul 1 09:28:16 2008
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=22, OS id=2226
Tue Jul 1 09:28:17 2008
Completed: ALTER DATABASE OPEN
Tue Jul 1 09:34:16 2008
Shutting down archive processes
Tue Jul 1 09:34:21 2008
ARCH shutting down
Tue Jul 1 09:34:21 2008
ARCH shutting down
ARC2: Archival stopped
...............................................................
Marcos
|
|
|
|
|
|
| Re: Automatic Startup - second instance [message #330892 is a reply to message #330867] |
Tue, 01 July 2008 12:43 |
marcossantos
Messages: 123
Registered: June 2008
|
Senior Member |
|
|
Ok.
Exactly.
I have two instance: orapro and rman.
Entries in oratab.
orapro:/dados/db/oracle/product/10.2.0/db_1:Y
rman:/dados/db/oracle/product/10.2.0/db_1:Y
The previous post was only for tell that exist the entries in oratab.
inst1 and inst2 only example.
Thanks.
Marcos
|
|
|
|
|
|
|
|
|
|
| Re: Automatic Startup - second instance [message #331226 is a reply to message #330899] |
Wed, 02 July 2008 12:31 |
marcossantos
Messages: 123
Registered: June 2008
|
Senior Member |
|
|
Problem is solved.
The problem was run-level.
I has executed the following commands:
$chmod +x /etc/init.d/oracle
Its is my startup script for 10g.
$/sbin/chkconfig --level 345 oracle on
$/sbin/chkconfig --add oracle
Checking now:
$/sbin/chkconfig --list
oracle 0:off 1:off 2:off 3:on 4:on 5:on 6:off
The output is showing how above.
I have run-level 3,4 and 5 setting up "on".
Now, reboot.
Best regards
Marcos Santos
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
