Home » RDBMS Server » Server Administration » Automatic Startup - second instance (RHEL 10g 10.2.0.1.0)
Automatic Startup - second instance [message #330867] Tue, 01 July 2008 09:37 Go to next message
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 #330868 is a reply to message #330867] Tue, 01 July 2008 09:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Did you put your new instance in oratab file?

Regards
Michel
Re: Automatic Startup - second instance [message #330869 is a reply to message #330867] Tue, 01 July 2008 09:50 Go to previous messageGo to next message
marcossantos
Messages: 123
Registered: June 2008
Senior Member
Thank you for your answer,

There are two entries in /etc/oratab


inst1:/dados/db/oracle/product/10.2.0/db_1:Y
inst2:/dados/db/oracle/product/10.2.0/db_1:Y


Marcos
Re: Automatic Startup - second instance [message #330870 is a reply to message #330869] Tue, 01 July 2008 10:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Have you anything in second instance alert.log file?

Regards
Michel
Re: Automatic Startup - second instance [message #330889 is a reply to message #330867] Tue, 01 July 2008 12:31 Go to previous messageGo to next message
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 #330890 is a reply to message #330889] Tue, 01 July 2008 12:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Your oratab shows 2 instances inst1 and inst2, you display alert.log for another instance: rman.
Which one/s is/are correct?

Regards
Michel
Re: Automatic Startup - second instance [message #330892 is a reply to message #330867] Tue, 01 July 2008 12:43 Go to previous messageGo to next message
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 #330896 is a reply to message #330892] Tue, 01 July 2008 13:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you don't post what you really have, we can't help.
Now how can I know what you pots is reality or not and how can I analyze it?
You waste my time.

Regards
Michel
Re: Automatic Startup - second instance [message #330899 is a reply to message #330867] Tue, 01 July 2008 13:28 Go to previous messageGo to next message
marcossantos
Messages: 123
Registered: June 2008
Senior Member
Ok...

What is the name of instances, not is important. Entries are there in oratab.Its setting up for "Y". This is important.

thanks


Marcos.





Re: Automatic Startup - second instance [message #330900 is a reply to message #330867] Tue, 01 July 2008 13:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>This is important.
Only to you & not for me.

You're On Your Own (YOYO)!
Re: Automatic Startup - second instance [message #331226 is a reply to message #330899] Wed, 02 July 2008 12:31 Go to previous message
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
Previous Topic: locked_object (merged)
Next Topic: SYSDBA
Goto Forum:
  


Current Time: Sat Dec 14 13:17:00 CST 2024