BRTOOLS Error

[Former Member]

Hi Experts,

Our Application and database are running on two servers.

I have set the environment varaible and configured the BRTOOLS parameters init<DBSID>.ora aninit<DBSID>.sap

But when i run the tool i get a error

BR1001I BRSPACE 6.40 (15)

BR1002I Start of BRSPACE processing: sduxkuex.dbw 2007-03-28 13.38.23

BR0280I BRSPACE time stamp: 2007-03-28 13.38.24

BR0301E SQL error -12560 at location BrDbaConnect-2

ORA-12560: TNS:protocol adapter error

BR0310E Connect to database instance PRD failed

Please let me know if i am missing any configuration in the parameters and variables.

Thanks in advance

[Former Member]

Hi

Check the user you are using to Login to your OS. Use the Oracle administrator user (<sapsid>adm or ora<dbsid> whichever) which is created by SAP for OS login, it has the required authorization for Oracle administration.

Also check the status of the listener.

The Oracle listener can be started and stopped with the following commands:

<b>lsnrctl start LISTENER

lsnrctl stop LISTENER</b>

NOTE: 'LISTENER' is actually the name of the listener in the above example. It may be different on your system. Edit your listener.ora file to get the names of the defined listeners.

Regards

Sumit Jain

[david_malinconici2]

Check if Oracle listener is running.

[Former Member]

When i run SQLPLUS i am getting the following error.

C:\>sqlplus

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Mar 28 14:10:58 2007

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

Enter user-name: / as sysdba

ERROR:

ORA-12560: TNS:protocol adapter error

[Former Member]

Hi,

Start start OracleService<SID> service

and try set ORACLE_SID=<SID> from cmd prompt.

Vinod

[Former Member]

Hi,

Oracleservideprd is already started and i just started the Oracleprd920tnslistner services. Now i am getting the error

<b>C:\>sqlplus

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Mar 28 14:36:19 2007

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

Enter user-name: / as sysdba

ERROR:

ORA-12154: TNS:could not resolve service name</b>

Please let me know how to resolve this issue.

[Former Member]

Hi

Paste ur tns and listener file.Can u able to do tnsping <sid> from client machine.

Vinod

[Former Member]

Here are the files

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

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

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

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

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

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

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = PRD.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = PRD)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = OPPS024)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = PRD)

(ORACLE_HOME = G:\oracle\PRD\920)

)

)

1. TNSNAMES.ORA Network Configuration File: G:\oracle\PRD\920\network\admin\tnsnames.ora

2. Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA.OMANPP.COM =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

PRD.WORLD =

(DESCRIPTION =

(SDU = 32768)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = OPPS024)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = PRD)

(GLOBAL_NAME = PRD.WORLD)

)

)

[Former Member]

Anil,

Looks ok

Try this

1:NAMES.DIRECTORY_PATH=(TNSNAMES, HOSTNAME) exists in the SQLNET.ORA file.

2:Just try by setting variable like "set ORACLE_SID"

3:try tnsping PRD.WORLD from command prompt

4:Change PRD.WORLD as PRD in tnsnames.ora and tnsping PRD.

5.Have u set TNS_ADMIN variable

Regards

Vinod

[Former Member]

SQLNET.ORA does not have this parameter but SQLNET1.ORA has it.

ORACLE_SID is already set in environment variables.

TNSPING is successfull for both PRD>WORLD and PRD

No i have not set the TNS_ADMIN variable, could you please let me know where i have to set this.

[Former Member]

Anil,

IF tnsping is working fine from client machine your listener and tnsnames are correct.

Now you can connect to db in server and in client through sqlplus.

If my inputs are helpfull award points and close thread once yur problem is solved.

Regs

Vinod

[Former Member]

Anil,

Meanwhile your sqlnet.ora file looks like

#SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

If not enter entries like this.

Vinod

[Former Member]

Vinod,

SQLPLUS is connecting thru DB server but in client APP server its giving me error message

ORA-12560: TNS:protocol adapter error

Is there anything else i need to do

[Former Member]

Anil,

Hope you have sqlnet.ora file with entries mention.

If tnsping is working fine and through sqlplus you are not able to connect then there must be some firewall restrictiong flow.disable if there is some thing like thatOr if possible reboot server and client.and bring DB first and Apps second.

in Apps server you have ORACLE_SID and tnsnames and sqlnet file with righentries.

Then 100% it shd work

Vinod

[Former Member]

Here are the entries i have in sqlnet.ora

<b># SQLNET.ORA Network Configuration File: G:\oracle\PRD\920\network\admin\sqlnet.ora

1. Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = OMANPP.COM

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)</b>

I have also rebooted the DB and the application server.

But still i am getting the same error. I am unable to start the listner in Application server but it is running in DB server.

Here are snmp_ro.ora entries available in APP server.

<b>snmp.visibleservices = (listener, PRD.WORLD)

ifile = G:\oracle\PRD\920\network\admin\snmp_rw.ora

ifile = G:\oracle\PRD\920\network\admin\sqlnet.ora</b>

But in the DB server there are more entries in snmp_ro.ora.

<b>snmp.visibleservices = (listener, PRD.WORLD)

snmp.shortname.listener = LISTENER

snmp.longname.listener = listener_OPPS024.OMANPP.COM

snmp.configfile.listener = G:\oracle\PRD\920\network\admin\listener.ora

snmp.oraclehome.listener = G:\oracle\PRD\920

snmp.servicename.listener_OPPS024.OMANPP.COM = OraclePRD920TNSListener

snmp.SID.PRD.WORLD = PRD

snmp.oraclehome.PRD.WORLD = g:\oracle\prd\920

snmp.address.PRD.WORLD = (ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEPRD)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))

snmp.remoteaddress.PRD.WORLD = (DESCRIPTION =(SDU = 32768)(ADDRESS_LIST =(ADDRESS =(COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = OPPS024)(PORT = 1527)))(CONNECT_DATA =(SID = PRD)(GLOBAL_NAME = PRD.WORLD)))

ifile = G:\oracle\PRD\920\network\admin\snmp_rw.ora

ifile = G:\oracle\PRD\920\network\admin\sqlnet.ora</b>

Do you think this might be causing a problem.

[Former Member]

Anil

Listener always run in DB server.There will not be any listener in Apps server.

As i said if ur able to do tnsping then network connection is ok.Check for any firewall settings .

Vinod

[Former Member]

Anil,

Mean while have a look on note 441518.

Vinod

[Former Member]

Now i have executed the command C:\>set LOCAL=ORA920

in App server now i am getting the following error

<b>ORA-12154: TNS:could not resolve service name</b>

But i am able to tnsping both prd.world and prd.

[Former Member]

Ohh No!!!!

After having all req according to note note 441518.if still you are facing error Then its your bad luck...

Any way as I said if u r able to do tnsping and all services are up and running and u have rgt privilages also Then there must be some thing which is not allowing you to enter Server Like Firewall

To trouble shoot you need to trace listener and tnsnames.ora which is very difficult to unstnd and analyze.

So before that let me know have you met all reqs acc to note 441518.

Or you can contact customer support.

Regards

Vinod