Problem with obtaining the last sequence from standby database on pup2stdby

[sailesh]

Hi all,

I have install Dbvisit Standby on Oracle Standard Edition 11gR2 on Solaris 10.

After successful installation, i tried to start Dbvisit Standby by the following command on my primary server:

cd /dbvisit, where i have installed Dbvisit Standby,

oracle:/dbvisit:DB24#ls -l

total 138449
-rwxr-x--- 1 oracle dba 3901705 Mar 17 14:42 Dbvisit_UserGuide5.3.pdf
-rwxr-x--- 1 oracle dba 52170 Mar 17 05:47 README.txt
-rwxr-x--- 1 oracle dba 54516 Nov 24 11:25 dbv_ORACLE_SID.env
-rwxr-x--- 1 oracle dba 5780298 Mar 17 05:47 dbv_functions
-rwxr-x--- 1 oracle dba 5869981 Mar 17 05:47 dbv_oraStartStop
-rwxr-x--- 1 oracle dba 54209 Apr 6 15:32 dbv_pup2.env
-rwxr-x--- 1 oracle dba 5835338 Mar 17 05:47 dbvisit
-rwxr-x--- 1 oracle dba 23728640 Mar 17 14:47 dbvisit5.3.10.tar
-rwxr-x--- 1 oracle dba 18992675 Apr 6 14:30 dbvisit5.3.10_solaris.zip
-rwxr-x--- 1 oracle dba 6131084 Mar 17 05:47 dbvisit_setup
drwxr-xr-x 3 oracle dba 3 Apr 6 15:54 pup2
drwxr-xr-x 2 oracle dba 15 Apr 6 16:51 tmp
oracle:/dbvisit:DB24# dbvisit pup2

oracle:/dbvisit:DB24#dbvisit pup2
================================================== ===========
Dbvisit Standby Database Technology (5.3.10.5840) (pid 7403)
dbvisit started on DB24: Wed Apr 6 17:32:55 2011
================================================== ===========

Performing Oracle Checkpoint.
Waiting 3 seconds for checkpoint completion...
First time Dbvisit Standby runs, Dbvisit Standby installation will be copied to pup2stdby...
Transferring dbv_functions to host pup2stdby:dbv_functions
Transferring dbvisit to host pup2stdby:dbvisit
Transferring dbvisit_setup to host pup2stdby:dbvisit_setup
Transferring dbv_oraStartStop to host pup2stdby:dbv_oraStartStop
Transferring dbv_pup2.env to host pup2stdby:dbv_pup2.env
Transferring dbv_ORACLE_SID.env to host pup2stdby:dbv_ORACLE_SID.env
Contacting Standby Database pup2 on pup2stdby...
201104061554 - Problem with obtaining the last sequence from standby database on
pup2stdby.
201104061542 - ORA-01033: ORACLE initialization or shutdown in progressEnter
user-name: SP2-0306: Invalid option.Enter user-name: SP2-0306: Invalid
option.SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting
SQL*Plus Dbvisit terminated.Return code = 433(Tracefile required if contacting
Dbvisit support: /dbvisit/tmp/4407_dbv_functions_pup2_201104061542.trc
(server:DB24))
Please check Standby Database is up and runnning on pup2stdby, else please
contact Dbvisit support.
Dbvisit Standby terminated.
Return code = 177

(Tracefile required if contacting Dbvisit support:
/dbvisit/tmp/6248_dbvisit_pup2_201104061554.trc (server:DB24))


This is the complete error.


Please help

Thanks,

Sailesh

[Mike Donovan]

Hello Sailesh,

A couple of things to check, in the first instance:
Are you able to confirm that the standby database is up and running?
Can you log into this with Sqlplus?
What mode is it in?

What I would recommend is that you log a support ticket for this through the service desk, and upload the following trace file through that facility for analysis by the support team:

/dbvisit/tmp/6248_dbvisit_pup2_201104061554.trc (server:DB24))

The service desk is located here:
http://www.dbvisit.com/support.php