cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with ora_br_copy.sh

Former Member
0 Kudos

My source ABAP+Java based DBCI is in a UNIX cluster environment. When I run ora_br_copy.sh to create CONTROL.SQL file, it gives me the following error,

<i>Required system resources are missing or not available:

Oracle listener is not started on port 6808;

Cannot establish connection to Oracle database as SYSTEM user:

Io exception: The Network Adapter could not establish the connection.</i>

My listner is running and so is the database. As orasid if I issue sqlplus system/password, it connects fine at port 6808 but ora_br_copy.sh is failing and I believe because it uses local hostname which is different then the cluster hostname.

Is there a way to provide cluster hostname to the ora_br_copy.sh similar to SAPINST where you can set environment variable SAPINST_USE_HOSTNAME?

Accepted Solutions (0)

Answers (3)

Answers (3)

yuri_shikunov
Explorer
0 Kudos

Hi Raj,

The latest version of ORABRCOPY tool has the option to set the host name:

-localhost <local host, default is '127.0.0.1'>

You can download the actual version from Service Marketplace.

Note 784118 - System Copy Java Tools

The latest version is also included in SAPINST CD from NW04 Patch Collection, NW2004s SR2 and the next releases.

Best Regards,

Yuri

Former Member
0 Kudos

Hello, there !!

When running NW 7.0, EHP1 sytem copy procedure, I ran into the same issue. Here's how I got around the problem:

Initially, the command I used was:

./ora_br_copy.sh -generateFiles -targetSid SRT -password ****** -listenerPort 1564

This gave me the error:

Required system resources are missing or not available:

Oracle listener is not started on port 1564;

Cannot establish connection to Oracle database as SYSTEM user:localhost 127.0.0.1

(or some reference to localhost - don't remember exactly)

Io exception: The Network Adapter could not establish the connection.

Specify the hostname as in the listener.ora in the -localhost option:

./ora_br_copy.sh -generateFiles -targetSid SRT -password ****** -listenerPort 1564 -localhost xxxxxxx

This will resolve the issue.

You can list all the available options for this script by typinng: ora_br_copy.sh -help.

Hope this helps !!

Regards,

madhavi

Former Member
0 Kudos

could you please paste the ora_br_copy.sh content here.

Chees,

-Sunil

Former Member
0 Kudos

First, thanks for reply...

And here are the details you have asked for...

The ora_br_copy.sh creates OraBRCopy.console.log and the contents of the log is as follows,

Oracle listener is not started on port 6808;

Cannot establish connection to Oracle database as SYSTEM user:

Io exception: The Network Adapter could not establish the connection.

This happens both as ora<sid> and <sid>adm..

The contents of the ora_br_copy.sh is as below,

#!/bin/sh

#

  1. Oracle Backup/Restore startup on UNIX

#

  1. Make sure prerequisite ORACLE_HOME environment variable is set

if [ -z "$ORACLE_HOME" ]; then

echo "The ORACLE_HOME environment variable is not defined."

echo "This environment variable is needed to run this program."

exit 1

fi

  1. Make sure prerequisite ORACLE_SID environment variable is set

if [ -z "$ORACLE_SID" ]; then

echo "The ORACLE_SID environment variable is not defined."

echo "This environment variable is needed to run this program."

exit 1

fi

  1. Make sure prerequisite JAVA_HOME environment variable is set

if [ -z "$JAVA_HOME" ]; then

echo "The JAVA_HOME environment variable is not defined."

echo "This environment variable is needed to run this program."

exit 1

fi

set -x

"$JAVA_HOME"/bin/java -showversion -cp ".:orabrcopy.jar:$ORACLE_HOME/jdbc/lib/classes12.jar" com.sap.inst.orabrcopy.OraBRCopy -oracleHome "$ORACLE_HOME" -sour

ceSid "$ORACLE_SID" "$@"

Former Member
0 Kudos

can you please add the host name variable to the DB host name which you have given for the installation in the ora_br_copy.sh file and try.

Cheers,

-Sunil

Former Member
0 Kudos

I am not sure what you mean by adding hostname variable.The ora_br_copy.sh allows only the following options,

where options include:

-oracleHome <Oracle home directory>

-sourceSid <source database SID>

-targetSid <target database SID>

-password <password of SYSTEM database user>

-generateFiles

-forceLogSwitches

where driver options include:

-listenerPort <listener port number>

or

-tnsAlias <Oracle TNS alias>

Former Member
0 Kudos

Hi Raj,

Can you please try executing thiss command using <sid>adm.

Also please paste logs of ora.brcopy.log

regards.

Ruchit.

Message was edited by:

Ruchit Khushu