oracle 10.2.0.4 on OEL 5.4
My lab is Two machines running under VMworkstation on my laptop
Primary database 'houston' is on server vmlnx01
physical standby 'smyrna' is on server vmlnx02.
Everything seems to be working - albiet a bit slow - but when I tested the switchover . . . this log is from the primary - houston on vmlnx01
DGMGRL> connect sys/halftrack
Connected.
DGMGRL> switchover to smyrna;
Performing switchover NOW, please wait...
Operation requires shutdown of instance "houston" on database "houston"
Shutting down instance "houston"...
ORA-01109: database not open
Odd ... why would it report database not open .. it most certainly is, and I was watching the alert log (tail -f alert*) in another putty session
Database dismounted.
ORACLE instance shut down.
Operation requires shutdown of instance "smyrna" on database "smyrna"
Shutting down instance "smyrna"...
ORA-01109: database not open
that one makes sense, that is the standby that was in MOUNT, not OPEN
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "houston" on database "houston"
Starting instance "houston"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
huh??? I'm not depending on dynamic registration. A quick check of the listener status on this box shows
Service "houston" has 2 instance(s).
Instance "houston", status UNKNOWN, has 1 handler(s) for this service...
Instance "houston", status READY, has 1 handler(s) for this service...
and continuing with the console log (not the alert log)
Failed.
You are no longer connected to ORACLE
Please connect again.
Unable to start instance "houston"
You must start instance "houston" manually
Operation requires startup of instance "smyrna" on database "smyrna"
You must start instance "smyrna" manually
Switchover succeeded, new primary is "smyrna"
DGMGRL> exit
[oracle@vmlnx01 ~]$ sqlpulus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 5 11:16:19 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1267068 bytes
Variable Size 100665988 bytes
Database Buffers 180355072 bytes
Redo Buffers 2924544 bytes
Database mounted.
SQL> exit