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: 

SAP ECC 6.0 file system Restore

Former Member

on ‎03-19-2011 10:03 AM

0 Kudos

Dear Friends,

Happy Holi.

I have restore file system backup of our development server to another host having oracle 10g and ECC 6.0.

After restore database has been up successfully.

But listner is not running when I trid to run listner it is giving the error as below.

jkeccbc:oradvr 2> lsnrctl start

LSNRCTL for HPUX: Version 10.2.0.2.0 - Production on 19-MAR-2011 15:18:33

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

Starting /oracle/DVR/102_64/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 10.2.0.2.0 - Production

System parameter file is /oracle/DVR/102_64/network/admin/listener.ora

Log messages written to /oracle/DVR/102_64/network/log/listener.log

Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=DVR.WORLD))

TNS-12557: TNS:protocol adapter not loadable

TNS-12560: TNS:protocol adapter error

TNS-00527: Protocol Adapter not loadable

Listener failed to start. See the error message(s) above...

Regards

Ganesh Datt Tiwari

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
‎04-13-2011 12:23 PM
0 Kudos

Very helpfull

Show replies
Show replies
markus_doehr2
Active Contributor
‎03-24-2011 10:23 AM
0 Kudos

> I have restore file system backup of our development server to another host having oracle 10g and ECC 6.0.

You're aware that this is not really a supported way of doing system copies? Your oraIventory is no more reflecting the actual state if you restored this from another SID so patches can't be applied properly.

> But listner is not running when I trid to run listner it is giving the error as below.

Also check LD_LIBRARY_PATH.

Markus

Show replies
Show replies
Former Member
‎03-24-2011 1:02 PM
0 Kudos

Just to add to Markus comments.Can you do a tnsping dbname and paste us the listener log.

Former Member
‎03-23-2011 2:43 PM
0 Kudos

Hi,

Please check ORACLE folder under the system profile folder. Please edit the file and change the host name and required details.

/usr/sap/<SID>/SYS/profile/oracle/...

Check the files ...sqlnet.ora, tnsnames etc...

Thanks and Regards,

Jibin.

Show replies
Show replies
Former Member
‎03-24-2011 4:50 AM
0 Kudos

Hi Jibin,

Thanks for your reply.

I have already changed hostname in all required files.

But problem is same.

Regards

Ganesh Datt Tiwari

Former Member
‎03-23-2011 2:38 PM
0 Kudos

Hi,

Is there only one database on the server ?

Mark

Show replies
Show replies
Former Member
‎03-23-2011 2:48 PM
0 Kudos

Hi,

Can you confirm your environments looks OK

ORACLE_HOME

PATH

Is looking at the right system

Mark

Former Member
‎03-24-2011 4:48 AM
0 Kudos

Hi Marks,

I have restored the file system of our server which is having ECC development and ECC quality.

I have just restored the file system backup of ECC development only.

Regards

Ganesh Datt Tiwari

Former Member
‎03-24-2011 7:41 AM
0 Kudos

Hi Mark,

The parameters ORACLE_HOME and PATH are not set. I have checked it with #echo $ and from SQL command show parameter its not displaying any value.

Same I have checkd on our running development server there is also no value for these parameters but system is running.

Regards

Ganesh Datt Tiwari

Former Member
‎03-24-2011 9:35 AM
0 Kudos

Hi,

Are logged as <sid>adm ??

you have got to have all the environments set.....

Like :

ORACLE_HOME

dbs_ora_tnsname

SHLIB_PATH

Mark

Former Member
‎03-24-2011 10:11 AM
0 Kudos

Hi Mark

Ihave checked all with login <sid>adm and values are as below.

jkeccbc:dvradm 21> echo $ORACLE_HOME

/oracle/DVR/102_64

jkeccbc:dvradm 22> echo $PATH

/oracle/DVR/102_64/bin:.:/home/dvradm:/usr/sap/DVR/SYS/exe/run:/usr/bin:/usr/ccs

/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/ipf/bin:/opt/hparra

y/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/sas/bin:/opt/wbem/bin:/opt/wbem/sbin:

/usr/bin/X11:/opt/resmon/bin:/usr/contrib/kwdb/bin:/opt/graphics/common/bin:/opt

/sfm/bin:/opt/hpsmh/bin:/opt/upgrade/bin:/opt/gvsd/bin:/opt/sec_mgmt/bastille/bi

n:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/opt/gnome/bin:/opt/moz

illa:/opt/perl_32/bin:/opt/perl_64/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/s

wa/bin:/opt/thunderbird:/opt/gwlm/bin:/usr/contrib/bin/X11:/opt/perf/bin:/opt/om

ni/bin

jkeccbc:dvradm 23> echo $SHLIB_PATH

/usr/sap/DVR/SYS/exe/run:/oracle/client/10x_64/instantclient

jkeccbc:dvradm 24>

Regards

Ganesh Datt Tiwari

Former Member
‎03-24-2011 10:43 AM
0 Kudos

Hi,

so have you actually switched user to ora<sid> and started the listener ??

I would also take note to Markus's remarks about patching, etc..when ou eventually get this going..

Mark

former_member709110
Active Participant
‎03-19-2011 1:44 PM
0 Kudos

Two checks that i would do is if my listener doesn't startup after a system copy.

1. Check the environment variables

2. Check the listener.ora , make sure new hostname , port has been correctly configured

Also as you mentioned you have two systems on the same server , i hope you have followed the procedure and configured the listener accordingly.

Regards,

Neel

Show replies
Show replies
Former Member
‎03-23-2011 12:17 PM
0 Kudos

Hi Neel,

Thanks for your reply.

I have changed the host name in file lisner.ora and tnsname.ora.

But still problem is same.

jkeccbc:oradvr 32> lsnrctl star

LSNRCTL for HPUX: Version 10.2.0.2.0 - Production on 23-MAR-2011 17:56:25

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

Starting /oracle/DVR/102_64/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 10.2.0.2.0 - Production

System parameter file is /oracle/DVR/102_64/network/admin/listener.ora

Log messages written to /oracle/DVR/102_64/network/log/listener.log

Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=DVR.WORLD))

TNS-12557: TNS:protocol adapter not loadable

TNS-12560: TNS:protocol adapter error

TNS-00527: Protocol Adapter not loadable

Listener failed to start. See the error message(s) above...

Regards

Ganesh Datt Tiwari

Former Member
‎03-23-2011 12:32 PM
0 Kudos

Hi,

Have you the TNS_ADMIN variable set ?

Mark

Former Member
‎03-23-2011 1:21 PM
0 Kudos

Hi Mark,

Thanks for your reply.

I have checked this parameter TNS_ADMIN not set.

Please tell me what value should be set.

Regards

Ganesh Datt Tiwari

Former Member
‎03-23-2011 1:43 PM
0 Kudos

Hi,

can you post your listener.ora and tnsnames.ora

Mark

Former Member
‎03-23-2011 2:12 PM
0 Kudos

Hi Mark,

Please find below

  1. cat listener.ora

################

  1. Filename......: listener.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DVR.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DVR)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST =jkeccbc)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = DVR)

(ORACLE_HOME = /oracle/DVR/102_64)

)

)

#

===========================================

  1. cat tnsnames.ora

################

  1. Filename......: tnsnames.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

DVR.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = jkeccbc)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = DVR)

(GLOBAL_NAME = DVR.WORLD)

)

)

#

Regards

Ganesh Datt Tiwari

Ask a Question