on 03-20-2007 12:36 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
could you please paste the ora_br_copy.sh content here.
Chees,
-Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
#
Oracle Backup/Restore startup on UNIX
#
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
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
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" "$@"
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>
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.