Oracle Fail Safe fails to bring DB online

[akhadar]

Dear friends
Here is my situation.Recently we migrated our domain from NT to 2000.We are having Oracle 8.1.6 On Win2000 Advanced server Cluster Machine with Oracle Fail Safe on it. Now my problem When ever we tried to Move the Group and Resources on the other Node the OFS not able to bring database online Node2.When i Checked the Documentation on OFS and changed the Oracle Fail Safe Security setup that when there is change in Domain,user,password need to change the security set up. Even after changing this Iam not able to bring the Database online on Node2.I checked the Trouble shooting also still iam not coming up with any errors.
can any one of give me some idea to deal with this stiruation.I dont have any problem with Node1.
Regards
akhadar

[jmodic]

What does running "Verify cluster" report? Any error messages?

[akhadar]

No ,Verify cluster and verify group doesnt report any errors messages.
regards
akhadar

[jmodic]

When you move the database group to Node2, does NT service for that database instance start successfully?

If not, what does the NT Even Log say?
If yes, what do last few entries in database's alert.log say?

[akhadar]

Here is the result from Event viewer and Alert .lob file
1.Oracle Oraclehome 81 TNS Listener service failed to start
by OFS.If i try to start it manually it will.
2.Here is the output from Alert.log
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 300
shared_pool_size = 184096768
large_pool_size = 614400
java_pool_size = 20971520
control_files = N:\Oracle\oradata\RICR\control01.ctl, O:\Oracle\oradata\RICR\control02.ctl, P:\Oracle\oradata\RICR\control03.ctl
db_block_buffers = 67418
db_block_size = 8192
compatible = 8.1.6
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 0
db_files = 1024
db_file_multiblock_read_count= 14
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
db_domain = sceco.com
global_names = TRUE
distributed_transactions = 61
instance_name = RICR
service_names = RICR
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
local_listener = (ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.111)(PORT=1521))
open_links = 4
sort_area_size = 917504
sort_area_retained_size = 917504
db_name = RICR
open_cursors = 100
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 60
parallel_max_servers = 5
background_dump_dest = C:\Oracle\admin\RICR\bdump
user_dump_dest = C:\Oracle\admin\RICR\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Mon Feb 04 15:47:52 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Feb 04 15:47:54 2002
/* OracleOEM */ ALTER DATABASE MOUNT
Mon Feb 04 15:48:00 2002
Successful mount of redo thread 1, with mount id 56137008.
Mon Feb 04 15:48:00 2002
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Mon Feb 04 15:48:00 2002
/* OracleOEM */ ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Mon Feb 04 15:48:00 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15789 Reading mem 0
Mem# 0 errs 0: O:\ORACLE\ORADATA\RICR\REDO02.LOG
Mon Feb 04 15:48:00 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 63 data blocks read, 63 data blocks written, 203 redo blocks read
Crash recovery completed successfully
Mon Feb 04 15:48:00 2002
Thread 1 advanced to log sequence 15790
Thread 1 opened at log sequence 15790
Current log# 3 seq# 15790 mem# 0: P:\ORACLE\ORADATA\RICR\REDO03.LOG
Successful open of redo thread 1.
Mon Feb 04 15:48:00 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Feb 04 15:48:07 2002
Completed: /* OracleOEM */ ALTER DATABASE OPEN


Its end of Office Hours i will be back tomarrow please
regards
akhadar


[Edited by akhadar on 02-05-2002 at 06:58 AM]

[akhadar]

Hello jurij
did u noticed the output from log files and have any sujjestions please.
regards
akhadar

[jmodic]

Your instance is running on Node1. Open Services on Node1 and check which Oracle services are running (OracleSrviceSID and at least one of the TNS Listener services). Also check on Node2 that both of those services with same names are present there, but are not started.

Now move your DB group to Node2. Are now those two services started there?

[akhadar]

Hello jurij
Both the Oracle Sevice SID and TNS Listener services are with the same names .But when I move the Database group to Node 2 these services are not started automatically as it should,since these services are started by OFS is it?. What I observed is OFS Service is able start?.Then what your next sujjestion please?.
regards
akhadar

[jmodic]

1. Check in OFS Manager tat Node2 is listed among "Available nodes" for that database group.

2. Check on Node2 that database and listener services have startup type set to "Manual", not to "Disabled"

I can't understand how "Verify cluster" and "Verify group" can finish successfully as you said - if I remember correctly both of those checking actually move database group to all available nodes, so they should report some errors if database can't be started on any available node.