SAP System re-build

[Former Member]

Hello,

We installed SAP system with Oracle and windows combination. Triggered brbackup and FS backup.

Unfortunately server is crashed due to harddisk failure. We want to rebuild the system with FS and backup which we took using brbackup.

Please suggest here how to proceed and if any document that will guide.

Best Regards,

Sri

[Reagan]

ORA-12560: TNS:protocol adapter error

Try to follow this SAP note

441518 - ORA-12560 composite SAP Note

Regards

RB

[Former Member]

Hello Everyone,

Seems an issue with listener and tnsnames.ora files, could you please answer the below question to resolve the issue at my end

1) How to install listener service ? by using netca only or any other way ?

2) how to determine exact port number (ex: 1521 or 1527)

3) deleted the folder D:\usr\sap\XXX\SYS\profile\oracle , will it impact ?

4) Deleted files under D:\oracle\XXX\102\NETWORK\admin also

C:\Documents and Settings\XXXadm>lsnrctl start

LSNRCTL for 64-bit Windows: Version 10.2.0.1.0 - Production on 25-JAN-2014 11:19

:57

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 10.2.0.1.0 - Production

System parameter file is D:\oracle\XXX\102\network\admin\listener.ora

Log messages written to D:\oracle\XXX\102\network\log\listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\XXX.WORLDip

c)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\XXXipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testwin346.wdf.sap.corp)(

PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=XXX.WORLD))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 10.2.0.1.0 - Produ

ction

Start Date                25-JAN-2014 11:20:03

Uptime                    0 days 0 hr. 0 min. 5 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   D:\oracle\XXX\102\network\admin\listener.ora

Listener Log File         D:\oracle\XXX\102\network\log\listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\XXX.WORLDipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\XXXipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testwin346.wdf.sap.corp)(PORT=1521)))

Services Summary...

Service "XXX" has 1 instance(s).

  Instance "XXX", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

But still getting the issue...TNS protocol adapter error

Regards,

Sri

[Reagan]

1) How to install listener service ? by using netca only or any other way ?

Check these links for assistance

Help - IBM Rational Software

linuxtechres.blogspot.com/2011/10/how-to-create-oracle-database-service.html

2) how to determine exact port number (ex: 1521 or 1527)

Check the listener.ora file present at D:\oracle\XXX\102\NETWORK\admin

3) deleted the folder D:\usr\sap\XXX\SYS\profile\oracle , will it impact ?
4) Deleted files under D:\oracle\XXX\102\NETWORK\admin also

You shouldn't have deleted these files.

Without these files there is no way you will start SAP.

Regards

RB

[Former Member]

If you have following

1. Database Backup

2. FS backup of  \usr\sap\xxx\sys\exe

3. FS backup of   \usr\sap\xxx\DVEBMGS00

4. DDIC password for client 000

then i would suggest  go with clean system copy target system installation database specific method. will be easy  .

1. install os  & databse softwate only

2. start  target system installation with sapinst follow instruction of sapinst.

3. Once you reach database restore option leave sapinst as it is and restore database and copy above file system binaries in respected folders then carry on with sapinst.

Regards

[Former Member]

 Instance "XXX", status UNKNOWN

Issue seems to be with your TNSNAMES.ora and Listener.ora files.

Service name that exists in TNSNAMES.ora should match with SID of Listener.ora.

Google/Search SDN with above error, it shows number of threads on how to fix.

Regards,

Nick Loy

[Former Member]

Dear Sridhar.

Loggin to SAP System with user Sidadm, stop DB, SAP and shutdown and start the Listener, DB, SAP Services then start DB and SAP.

Also make sure there is sufficient amount of hardware resources in terms of RAM.

Thanks & Regards

Mohd Basis

[Former Member]

Hello Everyone,

Thanks for your quick response.

I have DB backup which was took by brtools and FS backup for /usr/sap/<SID> only.

My question is

1) FS restore is done and registered the SAP<SID> services

2) DB software installtion is done from there i am not sure how to proceed

Suggest me the steps to restore the backup took by BRtools .

Regards,

Sri

[former_member188883]

Hi Sridhar,

Copy the backupSID.log file as well as backup file with .aft or .afn extension to sapbackup folder

Login with sidadm

execute

brrestore -m full -b <path of backup file with.aft /,afn extension>

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Installed Oracle Server software using sapserver.cmd, then copied backupSID.log and .afd files to sapbackup as mentioned above.

Restore was asking the additional folders sapdata2, sapdata3, sapdata4 to create, but in source there was only sapdata1 folder.

Now the sqlplus connection is failing with below error

SQL> connect sys as sysdba

Enter password:

ERROR:

ORA-12560: TNS:protocol adapter error

Please suggest me how to proceed to resolve the TNS protocol adapter error.

LISTENER is configured using netca but still getting the issue.

Regards,

Sri

[former_member188883]

Hi Sridhar,

Restore was asking the additional folders sapdata2, sapdata3, sapdata4 to create, but in source there was only sapdata1 folder.

If source system has sapdata1, backup log also should have only sapdata1. Please check in backup log how many sapdata folders are backed up.

If possible create these folders and proceed with restore.

sqlplus will not work at the moment as listener may not be running. you need to start listener service.

from services.msc

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Restore was completed with warnings , now the problem i am facing is TNS protocol adapter error.

LISTENER is running fine, not sure what was the wrong here.

Suggest me .

Best Regards,

Sri

[Reagan]

Sorry I don't understand your issue.

If you have restored the database and then start the database.

If the database is already started then check the status of the database.

You need to provide more details with the error message and relevant trace files for others to help you.

Regards

RB

[Former Member]

Hello RB,

When i am trying to logging into database using the below command getting the TNS protocol adapter error:

C:\Documents and Settings\***adm>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 24 15:16:32 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect sys as sysdba

Enter password:

ERROR:

ORA-12560: TNS:protocol adapter error

suggest here.

Regards,

Sri

[Reagan]

What happens when you run this:

sqlplus "/as sysdba"

Regards

RB

[Former Member]

When i run sqlplus "/as sysdba" getting the below error:

C:\Documents and Settings\***adm>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 24 15:53:38 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name: SAPSR3

Enter password:

ERROR:

ORA-12560: TNS:protocol adapter error

[daniel_macias]

Hi SRIDHAR M,

Check environment variables of the user that connects to the database.

ORACLE_SID is correct?

Regards,

Dani

[Former Member]

Hi Dani,

Below are the environment variables set it for sidadm

DBMS_TYPE

ora

dbs_ora_schema    SAPSR3

dbs_ora_tnsname    XXX

ORACLE_HOME	D:\oracle\XXX\102
ORACLE_SID	XXX

SAPDATA_HOME    D:\oracle\XXX

TNS_ADMIN

D:\usr\sap\XXX\SYS\profile\oracle

Regards,

Sri

[daniel_macias]

Hi SRIDHAR M,

Check database services, PATH environment variable and try to execute tnsping XXX.  Also you can check '/oracle/XXX/10204/network/admin' files (listener.ora, tnsnames.ora), if has correct parameters.

Regards,

Dani

[Former Member]

In addition to above:

Triggered brbackup and FS backup

If it restores your OS and everything, then you can recover everything.

Else, you should follow above recommendations to bring your system up.

Bringing OS is the major task I can see, if it is up then you can directly restore your database and then do SAP installation.

Regards,

Nick Loy

[Reagan]

Hello

First try restoring the data backed up from the disks and try staring the SAP system.

If that works then you are done else install a new system and restore the database backup.

Regards

RB

[former_member188883]

Hi Sridhar,

Do you have a OS image backup with registry entries ?

If no, then you may need to follow below steps

1) Rebuild the server with fresh OS and directory settings.

2) Install SAP and Database

3) Restore backup taken using brbackup. This will bring you back to the state before server crash.

If you have OS image backup,

1) Then restore the OS image backup first

2) Restore the FS backup. You may need to recover the database to bring the system to the state before crash.

Hope this helps.

Regards,

Deepak Kori