Adding the Oracle Database Resource to the Fail Safe Group

[Former Member]

Hi,

I am installtin MSCS cluster for my EP system. After Adding the Oracle Database Resource to the Fail Safe Group my CI jcontrol.exe has been stopped. I tried to connect my SAPSR3DB user by sqlplus but it is giving follwoing error.

SQL> conn SAPEPPDB

Enter password:

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE.

but DB startup is running properly and DB is coming in open state properly. After that I have perform R3trans -d. following error

C:\>R3trans -d

This is R3trans version 6.14 (release 700 - 12.06.09 - 15:20:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'EPP'"

R3trans finished (0012).

I added Oracle database resource to fail safe group as per installation guide.

Please help me out.

Regards,

Dinesh Bhatt

[former_member198270]

Hello Dinesh,1. Could you please check if your listener is up ?

2. dbms_sid Environment varible is set or not ?

hope it helps .

Regards, Amber S | ITL

[Former Member]

C:\>lsnrctl status

LSNRCTL for 64-bit Windows: Version 10.2.0.2.0 - Production on 11-APR-2010 20:39

:38

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

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=192.1.20.7)(PORT

=1527))

STATUS of the LISTENER

-

---

Alias LISTENER

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

ction

Start Date 11-APR-2010 20:39:23

Uptime 0 days 0 hr. 0 min. 14 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File F:\oracle\EPP\102\network\admin\listener.ora

Listener Log File F:\oracle\EPP\102\network\log\listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.1.20.7)(PORT=1527)))

The listener supports no services

The command completed successfully

listener start but without any instance.

listerer.ora file

#

1. This file is written by Oracle Services For MSCS

2. on Sun Apr 11 10:53:11 2010

#

LISTENER =

(ADDRESS_LIST=

(ADDRESS=

(COMMUNITY=SAP.WORLD)

(PROTOCOL=TCP)

(HOST=192.1.20.7)

(PORT=1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

ADMIN_RESTRICTIONS_LISTENER = on

Fsloracleepp =

(ADDRESS_LIST=

(ADDRESS=

(PROTOCOL=IPC)

(KEY=EPP)

)

(ADDRESS=

(PROTOCOL=IPC)

(KEY=EPP.WORLD)

)

(ADDRESS=

(COMMUNITY=SAP.WORLD)

(PROTOCOL=TCP)

(Host=192.1.20.43)

(Port=1527)

)

)

SID_LIST_Fsloracleepp =

(SID_LIST=

(SID_DESC=

(SID_NAME=EPP)

(ORACLE_HOME=F:\oracle\EPP\102)

)

)

STARTUP_WAIT_TIME_Fsloracleepp = 0

ADMIN_RESTRICTIONS_Fsloracleepp = on

TRACE_LEVEL_Fsloracleepp = OFF

CONNECT_TIMEOUT_Fsloracleepp = 10

dbms_sid added

please help.

Dinesh Bhatt

[Former Member]

have u tried the same by logging-in with <sid>adm in os level

[Former Member]

I am using sidadm user.

Actually problem came after adding the Oracle database resource to the fail safe group.

Give me suggestions pls.

Dinesh Bhatt

[Former Member]

any other help.

[Former Member]

I have changed hostname in java configtool.

Problem resolved.

Thanks to all.