cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

DR Server problem

Go to solution
Former Member

on ‎08-28-2008 9:26 AM

0 Kudos

Dear All,

We have SAP on Oracle 9i. There is also a DRServer on our remote site. I that i have restore whole database offline backup from my production server. Now i want to know that ..

1. where i can find the latest log of restore.

2. In that DR server, there is a error in starting teh SAP. It is not starting the databbase from startsap all cmd. But it is starting by sqlplus. In startsap all , it is giving error,

Trying to start PRD database ...

Log file: /home/prdadm/startdb.log

/usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 16

hat i have to do.

If there is any ther process to restore db, then tell me if i am wrong.

Regards,

Ankit

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎08-28-2008 11:51 PM
0 Kudos

Ankit,

On your 2nd questions:

2. In that DR server, there is a error in starting teh SAP. It is not starting the databbase from startsap all cmd. But it is starting by sqlplus. In startsap all , it is giving error,

The database at DR is in recovery mode(mounted), it is not open for use. starting SAP will give you errors in DR. You can start SAP only when the failover is done and database is open for use.

Cheers,

Nisch

Show replies
Show replies
Former Member
‎08-29-2008 3:56 AM
0 Kudos

Hi Markus,

Yes, It is started from sqlplus, the log is.....

-

prdadm 29> sqlplus " / as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Aug 20 18:14:03 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 839600392 bytes

Fixed Size 727304 bytes

Variable Size 452984832 bytes

Database Buffers 384565248 bytes

Redo Buffers 1323008 bytes

Database mounted.

Database opened.

SQL>

-

Hi Nisch,

But my landscape is small so there is not online archiving of data from live server to drs server. So, i want to check that it is ok or not. so i want to check it from gui connectivty. Is there any procedure to check this?

Regards,

Ankit Gupta

Former Member
‎08-29-2008 5:51 AM
0 Kudos

Anikit,

To check the current status of the database, check alert log file and that will tell you if the database has any errors.

You need to understand the concepts of DR and do more reading on dataguard in SAP enviroment, you will find lots of resources if you google for it.

It is a good practice to maintain a document on the setup or refer to one when on a new enviroment to understand how it has been setup.

Hope this helps.

Cheers,

Nisch

markus_doehr2
Active Contributor
‎08-29-2008 8:41 AM
0 Kudos

The database opened - good! But:

Now you need to re-copy your source system again. Once the database has been "opened" you can´t recover any more the archive logs from your production.

Markus

markus_doehr2
Active Contributor
‎08-29-2008 8:42 AM
0 Kudos

> SQL*Plus: Release 9.2.0.4.0 - Production on Wed Aug 20 18:14:03 2008

ِAnd before I forget: Oracle 9.2.(0.4) is out of maintenance (check the top level article on ) - I highly suggest you upgrade to 10.2.

Markus

Former Member
‎08-29-2008 9:03 AM
0 Kudos

Hi markus,

i am highly thankfull to you to get my attention this side. could you tel me the general procedure to upgrade oracle rdbms.

Thanks in advance.

Regards,

Ankit

markus_doehr2
Active Contributor
‎08-29-2008 9:11 AM
0 Kudos

Check

http://service.sap.com/instguides

--> Other documentation

--> Database Upgrades

--> Oracle

Download the guide and follow it attentively.

Markus

Answers (2)

Answers (2)

markus_doehr2
Active Contributor
‎08-28-2008 10:04 AM
0 Kudos

check the output of "startdb.log"

Markus

Show replies
Show replies
Former Member
‎08-28-2008 10:25 AM
0 Kudos

trans.log is ..........

prdadm 28> cat trans.log

4 ETW000 R3trans version 6.13 (release 640 - 07.01.08 - 14:25:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 20.08.2008 - 18:11:09

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Wed Aug 20 18:11:09 2008 298 0.000298

4 ETW000 [dev trc ,00000] db_con_init called 34 0.000332

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 103 0.000435

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' ...

4 ETW000 131 0.000566

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/PRD/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 32456 0.033022

4 ETW000 [dev trc ,00000] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' loaded

4 ETW000 53 0.033075

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 113 0.033188

4 ETW000 [dev trc ,00000] Version of '/usr/sap/PRD/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.220)

4 ETW000 286 0.033474

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 62 0.033536

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so

4 ETW000 122 0.033658

4 ETW000 [dev trc ,00000] New connection 0 created 66 0.033724

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 91 0.033815

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 67 0.033882

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 52 0.033934

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 57 0.033991

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/PRD/920_64 from environment

4 ETW000 575 0.034566

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 123 0.034689

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 56 0.034745

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 2615 0.037360

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPPRD's password 77 0.037437

4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 070208)

4 ETW000 64 0.037501

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 124 0.037625

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x6000000001286990 0x600000000129a578 0x6000000001299f88

4 ETW000 57 0.037682

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 73 0.037755

4 ETW000 [dev trc ,00000] Allocating server context handle 39 0.037794

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x6000000001299eb8,srvhp=0x600000000129c288)

4 ETW000 117 0.037911

4 ETW000 [dev trc ,00000] Wed Aug 20 18:11:10 2008 83410 0.121321

4 ETW000 [dev trc ,00000] Assigning server context 0x600000000129c288 to service context 0x6000000001299eb8

4 ETW000 64 0.121385

4 ETW000 [dev trc ,00000] Allocating user session handle 77 0.121462

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x6000000001299eb8,srvhp=0x600000000129c288,usrhp=0x60000000012a5c68)

4 ETW000 70 0.121532

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034

4 ETW000 2626 0.124158

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x600000000129c288)

4 ETW000 53 0.124211

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x6000000001299eb8,srvhp=0x600000000129c288)

4 ETW000 55 0.124266

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x600000000129c288

4 ETW000 560 0.124826

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 127 0.124953

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 35 0.124988

4 ETW000 [dev trc ,00000] Try to connect with default password 143 0.125131

4 ETW000 [dev trc ,00000] Connecting as SAPPRD/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 070208)

4 ETW000 68 0.125199

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 64 0.125263

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x6000000001286990 0x600000000129a578 0x6000000001299f88

4 ETW000 58 0.125321

4 ETW000 [dev trc ,00000] Allocating server context handle 35 0.125356

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x6000000001299eb8,srvhp=0x600000000129c288)

4 ETW000 70 0.125426

4 ETW000 [dev trc ,00000] Assigning server context 0x600000000129c288 to service context 0x6000000001299eb8

4 ETW000 82002 0.207428

4 ETW000 [dev trc ,00000] Assigning username to user session 0x60000000012a5c68

4 ETW000 61 0.207489

4 ETW000 [dev trc ,00000] Assigning password to user session 0x60000000012a5c68

4 ETW000 72 0.207561

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x6000000001299eb8,srvhp=0x600000000129c288,usrhp=0x60000000012a5c68)

4 ETW000 119 0.207680

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034

4 ETW000 1910 0.209590

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x600000000129c288)

4 ETW000 52 0.209642

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x6000000001299eb8,srvhp=0x600000000129c288)

4 ETW000 55 0.209697

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x600000000129c288

4 ETW000 306 0.210003

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 65 0.210068

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 34 0.210102

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 1034 performing CON [dblink#3 @ 428]

4 ETW000 373 0.210475

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-01034: ORACLE not available 44 0.210519

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 HPUX-ia64 Error: 2: No such file or directory [dblink#3 @ 428]

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'"

& startdb.log.......

prdadm 23> cat startdb.log

-

Wed Aug 20 18:09:39 IST 2008

LOGFILE FOR STARTING ORACLE

Trying to start PRD database ...

-

Wed Aug 20 18:09:39 IST 2008

checking required environment variables

ORACLE_HOME is >/oracle/PRD/920_64<

ORACLE_SID is >PRD<

-

Wed Aug 20 18:09:39 IST 2008

check initora

/usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 16

Plz suggest.

Regards,

Ankit

markus_doehr2
Active Contributor
‎08-28-2008 5:20 PM
0 Kudos

The database your TNS is pointing to, is not started.

Are you sure that the database could be correctly started using sqlplus?

Please try:

sqlplus / as sysdba
shutdown abort
startup

What is the output?

Markus

JPReyes
Active Contributor
‎08-28-2008 10:00 AM
0 Kudos

Is the DB mounting and openning properly via sqlplus?

Whats the full error on startdb log? also can you do and R3trans -d and post the error on the trans.log?

Regards

Juan

Show replies
Show replies
Ask a Question