Solved: 2EETW169 no connect possible: "DBMS = ORACLE ---d...

Dear All,

I am in the process of upgrading from SAP 4.7 + Oracle 9 to ECC 6 + Oracle 10g.

Database is successfully upgarded to 10g and client from 8.1 to 9.2.0.7 but after db upgrade my "Oracle" does not start via startsap command.

If is start listener & then startsap .....Msg is successfull but no logon possible as DATABSE is not yet started. I hav to explicitly start Oracle from SQL plus ....

pls suggest me hwo to resolve thsi ...Kernel is 640.

***********STARTSAP is as below**********

bssldev1:devadm 40% startsap

Checking DEV Database

ABAP Database is not available via R3trans

Checking DEV Database

Starting SAP-Collector Daemon

11:55:17 20.08.2007 LOG: Effective User Id is root

This is Saposcol Version COLL 20.94 640 - V3.73 64Bit
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
The OS Collector (PID 1267) is already running .....

saposcol already running

Starting SAP Instance DVEBMGS00

Startup-Log is written to /home/devadm/startsap_DVEBMGS00.log

Instance on host bssldev1 started

IGS on host bssldev1 started

*****************************************************

But R3trans returns following:

bssldev1:devadm 38% R3trans -x

This is R3trans version 6.13 (release 640 - 26.02.07 - 15:37:00).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DEV'"

R3trans finished (0012).

PLEASE HELP.........................

Regards & Thanks,

Ankita.

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hi Ankita,

What does the trans.log file (generated at the directory where you ran R3trans -x) look like?

Regards,

Alfonso

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Alfanso,

the trans.log is as below----

bssldev1:devadm 7% more trans.log

4 ETW000 R3trans version 6.13 (release 640 - 26.02.07 - 15:37:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 20.08.2007 - 14:35:48

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d -v

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Aug 20 14:35:48 2007 228 0.000228

4 ETW000 [dev trc ,00000] db_con_init called 57 0.000285

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 100 0.000385

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/DEV/SYS/exe/run/dboraslib.so' ...

4 ETW000 193 0.000578

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/DEV/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 76713 0.077291

4 ETW000 [dev trc ,00000] Library '/usr/sap/DEV/SYS/exe/run/dboraslib.so' loaded

4 ETW000 260 0.077551

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/DEV/SYS/exe/run/dboraslib.so

4 ETW000 134 0.077685

4 ETW000 [dev trc ,00000] Version of '/usr/sap/DEV/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.175)

4 ETW000 615 0.078300

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/DEV/SYS/exe/run/dboraslib.so

4 ETW000 108 0.078408

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/DEV/SYS/exe/run/dboraslib.so

4 ETW000 124 0.078532

4 ETW000 [dev trc ,00000] New connection 0 created 88 0.078620

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 25

5, con_opt = 255, occ = NO

4 ETW000 120 0.078740

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 62 0.078802

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 98 0.078900

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255

, con_opt = 255, occ = NO

4 ETW000 106 0.079006

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/DEV/102_64 from environment

4 ETW000 483 0.079489

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 151 0.079640

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 104 0.079744

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 8926 0.088670

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPPRD's password 75 0.088745

4 ETW000 [dev trc ,00000] Connecting as /@DEV on connection 0 (nls_hdl 0) ... (dbsl 640 010307)

4 ETW000 103 0.088848

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 106 0.088954

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 101269370 101272600 101271f98

4 ETW000 123 0.089077

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 61 0.089138

4 ETW000 [dev trc ,00000] Allocating server context handle 72 0.089210

4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=101271ec8,srvhp=101274368)

4 ETW000 176 0.089386

4 ETW000 [dev trc ,00000] Assigning server context 101274368 to service context 101271ec8

4 ETW000 129978 0.219364

4 ETW000 [dev trc ,00000] Allocating user session handle 83 0.219447

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=101271ec8,srvhp=101274368,usrhp=10127ddc0)

4 ETW000 122 0.219569

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034

4 ETW000 10544 0.230113

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=101274368)

4 ETW000 94 0.230207

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=101271ec8,srvhp=101274368)

4 ETW000 95 0.230302

4 ETW000 [dev trc ,00000] Deallocating server context handle 101274368 724 0.231026

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 152 0.231178

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 60 0.231238

4 ETW000 [dev trc ,00000] Try to connect with default password 113 0.231351

4 ETW000 [dev trc ,00000] Connecting as SAPPRD/<pwd>@DEV on connection 0 (nls_hdl 0) ... (dbsl 640 010307)

4 ETW000 110 0.231461

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 104 0.231565

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 101269370 101272600 101271f98

4 ETW000 103 0.231668

4 ETW000 [dev trc ,00000] Allocating server context handle 64 0.231732

4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=101271ec8,srvhp=101274368)

4 ETW000 163 0.231895

4 ETW000 [dev trc ,00000] Assigning server context 101274368 to service context 101271ec8

4 ETW000 120401 0.352296

4 ETW000 [dev trc ,00000] Assigning username to user session 10127ddc0 66 0.352362

4 ETW000 [dev trc ,00000] Assigning password to user session 10127ddc0 73 0.352435

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=101271ec8,srvhp=101274368,usrhp=10127ddc0)

4 ETW000 106 0.352541

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034

4 ETW000 8908 0.361449

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=101274368)

4 ETW000 94 0.361543

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=101271ec8,srvhp=101274368)

4 ETW000 357 0.361900

4 ETW000 [dev trc ,00000] Deallocating server context handle 101274368 423 0.362323

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'

4 ETW000 121 0.362444

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 59 0.362503

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 1034 performing CON [dblink#3 @ 428]

4 ETW000 145 0.362648

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-01034: ORACLE not available 89 0.362737

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 SVR4 Error: 2: No such file or directory [dblink#3 @ 428]

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DEV'"

Regards,

Ankita.

Are you on Solaris 10?

Markus

Hi Ankita,

It is not clear what is going on there, but the lines below

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 59 0.362503

4 ETW000 [dblink ,00428] ***LOG BY2=>sql error 1034 performing CON [dblink#3 @ 428]

4 ETW000 145 0.362648

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-01034: ORACLE not available 89 0.362737

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 SVR4 Error: 2: No such file or directory [dblink#3 @ 428]

May suggest the Oracle executable permissions and ownership are wrong.

Can you please check it with

ls -l $ORACLE_HOME/bin/oracle

owner: ora<sid>

Group: dba

Permissions 6755

Good luck.

Alfonso

Hi Ankita,

Sorry, permissions should be 6751.

You can check SAP note 583861 as reference.

Regards,

Alfonso

Yes Markus I am on Sun Solaris 10 ............

I wondered because I saw the "SVR4 shared memory realm" error message.

Is member of the project you set up? And are they in /etc/user_attr?

Solaris 10 doesn´t use /etc/system any more for shared memory configuration...

Markus

Dear Alfanso,

The permissiosn are set correctly bin directory and oracle file as per given note.

So wat shd i do now?

Regards,

Ankita

Hi Markus,

I am not able to understand so please explain em wat change shd id o realted to Sun Solaris 10 ....What do u mean by project over here too ? Pls advsie i hav worked on Sun 9 but not 10 so pls help...

********************File contents are *************

bssldev1:oradev 23% more user_attr

/etc/user_attr

user attributes. see user_attr(4)

#pragma ident "@(#)user_attr 1.1 03/07/09 SMI"

adm::::profiles=Log Management

lp::::profiles=Printer Management

root::::auths=solaris.*,solaris.grant;profiles=Web Console Management,All;lock_after_retries=no

***********************

Regards,

Ankita

Hi Ankita,

Now I think of client software.

If you are still on kernel 6.40 you need the Oracle Client 9.

Is there a client software installation under

/oracle/client/92x_64 ?

Is the ORA_NLS33 variable correctly set?

Best regards

Alfonso

Shared memory parameters have been classically defined using /etc/system (you will find a bunch of entries there). Solaris 10 uses a different approach, it uses "project" with resource controls.

Check

Note 724713 - parameter settings for Solaris 10

It´s explained there with an example.

If that configuration is not yet done, Oracle may or may not work, depending on your configuration.

Markus

Hi Markus,

As per note 724713, I have added a project and modified /etc/user_attr file : Still Oracle Database is not starting via "startsap" cmd.

Pls tell em -

Do i need to set resource settings for user root als as given in point 3 of note. ??? If yes tehn wil it be the same.

The contents now are ---

bssldev1:devadm 5% more project

system:0::::

user.root:1::::

noproject:2::::

default:3::::

group.staff:10::::

DEV:999:DEV:::

***********

bssldev1:devadm 6% more user*

/etc/user_attr

user attributes. see user_attr(4)

#pragma ident "@(#)user_attr 1.1 03/07/09 SMI"

adm::::profiles=Log Management

lp::::profiles=Printer Management

root::::auths=solaris.*,solaris.grant;profiles=Web Console Management,All;lock_a

fter_retries=no

devadm::::project=DEV

oradev::::project=DEV

**********************************************

Pls help...

Regards,

Ankita

Hi Anika,

I suggest the following:

- shut down SAP

- shut down Oracle

- close the actual shell

- open a new shell

- try to start both DB + SAP with "startsap"

if that does not work, please check your Oracle alert.log for error messages.

Root does only need to be in the project for the installation,later it´s deleted.

Markus

Hey Markus ....

everything doen in saee way stil same problem. what shd i do?? I am badly stuck up.

ALERT_DEV.LOG ***********************

Starting up ORACLE RDBMS Version: 10.2.0.2.0.

System parameters with non-default values:

processes = 80

sessions = 96

timed_statistics = TRUE

shared_pool_size = 3103784960

large_pool_size = 117440512

java_pool_size = 117440512

streams_pool_size = 50331648

shared_pool_reserved_size= 309067776

control_files = /oracle/DEV/origlogA/cntrl/cntrlDEV.dbf, /oracle/DEV/saparch/cntrl/cntrlDEV.dbf, /oracle/DEV/sapdata1/cntrl/cntrlDEV.dbf

control_file_record_keep_time= 30

db_block_buffers = 377280

db_block_size = 8192

compatible = 10.2.0

log_archive_dest = /oracle/DEV/oraarch/DEVarch

log_buffer = 14289920

log_checkpoint_interval = 300000

log_checkpoint_timeout = 0

db_files = 254

db_file_multiblock_read_count= 32

log_checkpoints_to_alert = TRUE

dml_locks = 2500

transactions_per_rollback_segment= 20

undo_management = AUTO

undo_tablespace = PSAPUNDO

undo_retention = 43200

recyclebin = off

remote_os_authent = TRUE

local_listener = LISTENER_DEV

background_dump_dest = /oracle/DEV/saptrace/background

user_dump_dest = /oracle/DEV/saptrace/usertrace

core_dump_dest = /oracle/DEV/saptrace/background

session_max_open_files = 20

optimizer_features_enable= 9.2.0

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = DEV

open_cursors = 800

optimizer_mode = CHOOSE

optimizer_index_cost_adj = 10

pga_aggregate_target = 25165824

PMON started with pid=2, OS id=4102

PSP0 started with pid=3, OS id=4104

MMAN started with pid=4, OS id=4106

DBW0 started with pid=5, OS id=4108

DBW1 started with pid=6, OS id=4110

DBW2 started with pid=7, OS id=4112

DBW3 started with pid=8, OS id=4114

LGWR started with pid=9, OS id=4116

CKPT started with pid=10, OS id=4118

SMON started with pid=11, OS id=4120

RECO started with pid=12, OS id=4122

MMON started with pid=13, OS id=4124

MMNL started with pid=14, OS id=4126

Mon Aug 20 16:19:26 2007

ALTER DATABASE MOUNT

Mon Aug 20 16:19:30 2007

Setting recovery target incarnation to 2

Mon Aug 20 16:19:30 2007

Successful mount of redo thread 1, with mount id 3709485966

Mon Aug 20 16:19:30 2007

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Mon Aug 20 16:19:30 2007

ALTER DATABASE OPEN

Mon Aug 20 16:19:31 2007

LGWR: STARTING ARCH PROCESSES

ARC0 started with pid=16, OS id=4130

Mon Aug 20 16:19:31 2007

ARC0: Archival started

ARC1: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

ARC1 started with pid=17, OS id=4132

Mon Aug 20 16:19:31 2007

Thread 1 opened at log sequence 100

Current log# 3 seq# 100 mem# 0: /oracle/DEV/origlogA/log_g13m1.dbf

Current log# 3 seq# 100 mem# 1: /oracle/DEV/mirrlogA/log_g13m2.dbf

Successful open of redo thread 1

Mon Aug 20 16:19:31 2007

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Mon Aug 20 16:19:31 2007

ARC0: STARTING ARCH PROCESSES

Mon Aug 20 16:19:31 2007

ARC1: Becoming the 'no FAL' ARCH

ARC1: Becoming the 'no SRL' ARCH

Mon Aug 20 16:19:31 2007

SMON: enabling cache recovery

Mon Aug 20 16:19:31 2007

ARC2: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

ARC0: Becoming the heartbeat ARCH

ARC2 started with pid=18, OS id=4134

Mon Aug 20 16:19:32 2007

Successfully onlined Undo Tablespace 6.

Mon Aug 20 16:19:32 2007

SMON: enabling tx recovery

Mon Aug 20 16:19:32 2007

Database Characterset is WE8DEC

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=19, OS id=4136

Mon Aug 20 16:19:35 2007

Completed: ALTER DATABASE OPEN

Mon Aug 20 16:20:31 2007

Shutting down archive processes

Mon Aug 20 16:20:36 2007

ARCH shutting down

ARC2: Archival stopped

Mon Aug 20 16:21:13 2007

Shutting down instance: further logons disabled

Mon Aug 20 16:21:13 2007

Stopping background process QMNC

Mon Aug 20 16:21:15 2007

Stopping background process MMNL

Mon Aug 20 16:21:16 2007

Stopping background process MMON

Mon Aug 20 16:21:17 2007

Shutting down instance (immediate)

License high water mark = 1

Mon Aug 20 16:21:17 2007

ALTER DATABASE CLOSE NORMAL

Mon Aug 20 16:21:19 2007

SMON: disabling tx recovery

SMON: disabling cache recovery

Mon Aug 20 16:21:20 2007

Shutting down archive processes

Archiving is disabled

Mon Aug 20 16:21:25 2007

ARCH shutting down

ARC1: Archival stopped

Mon Aug 20 16:21:30 2007

ARCH shutting down

ARC0: Archival stopped

Mon Aug 20 16:21:31 2007

Thread 1 closed at log sequence 100

Successful close of redo thread 1

Mon Aug 20 16:21:32 2007

Completed: ALTER DATABASE CLOSE NORMAL

Mon Aug 20 16:21:32 2007

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

This is really strange...

and it works if you start the database manually? What do you see in sapstart.log?

Markus

Dear Alfonso,

Yes mine is kernel 640 and client is upgraded from 8.1 to 9.2.0.7 and envt si also set correctly ...still error is same

***************DEVADM****************

bssldev1:devadm 30% env

HOME=/home/devadm

PATH=/oracle/DEV/102_64/bin:/home/devadm:/usr/sap/DEV/SYS/exe/runU:/usr/sap/DEV/SYS/exe/run:/usr/bin:.:/usr/ccs/bin:/usr/ucb

LOGNAME=devadm

HZ=

TERM=dtterm

SHELL=/bin/csh

MAIL=/var/mail/devadm

LANG=en_US.ISO8859-15

LC_CTYPE=en_US.ISO8859-15

LC_NUMERIC=en_US.ISO8859-15

LC_TIME=en_US.ISO8859-15

LC_COLLATE=en_US.ISO8859-15

LC_MONETARY=en_US.ISO8859-15

LC_MESSAGES=C

TZ=Asia/Calcutta

PWD=/oracle/DEV/saptrace/background

USER=devadm

SAPSYSTEMNAME=DEV

DIR_LIBRARY=/usr/sap/DEV/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SYS/exe/runU:/oracle/client/9207/lib

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=DEV

dbs_ora_schema=SAPPRD

ORACLE_PSRV=DEV

ORACLE_SID=DEV

DB_SID=DEV

ORACLE_HOME=/oracle/DEV/102_64

ORACLE_BASE=/oracle

ORA_NLS33=/oracle/client/9207/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/DEV

TNS_ADMIN==/oracle/DEV/102_64/network/admin

***********************

Regards,

Ankita

Yes Markus it does .....

If i start in the sequence - --- oracle listener -

Oracle DB startup from SQL prompt -

then Startsap. Then logon is successfull but only startsap ....is not starting ORA

The log is ************************************************

bssldev1:devadm 8% startsap

Checking DEV Database

ABAP Database is not available via R3trans

Checking DEV Database

Starting SAP-Collector Daemon

16:40:20 20.08.2007 LOG: Effective User Id is root

***********************************************************************

This is Saposcol Version COLL 20.94 640 - V3.73 64Bit
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
The OS Collector (PID 1268) is already running .....

************************************************************************

saposcol already running

Starting SAP Instance DVEBMGS00

Startup-Log is written to /home/devadm/startsap_DVEBMGS00.log

Instance on host bssldev1 started

IGS on host bssldev1 started

bssldev1:devadm 9% more startsap_DVEBMGS00.log

Trace of system startup/check of SAP System DEV on Mon Aug 20 16:40:20 IST 2007

Called command: /usr/sap/DEV/SYS/exe/run/startsap

Starting SAP Instance DVEBMGS00

SAP-R/3-Startup Program Rel 640 V1.8 (2003/04/24)

Starting at 2007/08/20 16:40:20

Startup Profile: "/usr/sap/DEV/SYS/profile/START_DVEBMGS00_bssldev1"

Execute Pre-Startup Commands

(5489) Local: /usr/sap/DEV/SYS/exe/run/sapmscsa -n pf=/usr/sap/DEV/SYS/profile/DEV_DVEBMGS00_bssldev1

/usr/sap/DEV/SYS/exe/run/sapmscsa: SCSA is attached and useable.

/usr/sap/DEV/SYS/exe/run/sapmscsa: finished.

(5491) Local: rm -f ms.sapDEV_DVEBMGS00

(5493) Local: ln -s -f /usr/sap/DEV/SYS/exe/run/msg_server ms.sapDEV_DVEBMGS00

(5495) Local: rm -f dw.sapDEV_DVEBMGS00

(5497) Local: ln -s -f /usr/sap/DEV/SYS/exe/run/disp+work dw.sapDEV_DVEBMGS00

(5499) Local: rm -f co.sapDEV_DVEBMGS00

(5501) Local: ln -s -f /usr/sap/DEV/SYS/exe/run/rslgcoll co.sapDEV_DVEBMGS00

(5503) Local: rm -f se.sapDEV_DVEBMGS00

(5505) Local: ln -s -f /usr/sap/DEV/SYS/exe/run/rslgsend se.sapDEV_DVEBMGS00

Starting Programs

20.08.2007 16:40:20

ShmDetach

FAIL: NIECONN_REFUSED (Connection refused), NiRawConnect failed in plugin_fopen()

(5509) Starting: local ms.sapDEV_DVEBMGS00 pf=/usr/sap/DEV/SYS/profile/DEV_DVEBMGS00_bssldev1

(5510) Starting: local dw.sapDEV_DVEBMGS00 pf=/usr/sap/DEV/SYS/profile/DEV_DVEBMGS00_bssldev1

(5511) Starting: local co.sapDEV_DVEBMGS00 -F pf=/usr/sap/DEV/SYS/profile/DEV_DVEBMGS00_bssldev1

(5512) Starting: local se.sapDEV_DVEBMGS00 -F pf=/usr/sap/DEV/SYS/profile/DEV_DVEBMGS00_bssldev1

(5488) Waiting for Child Processes to terminate.

(5488) **** 2007/08/20 16:40:20 Child 5511 terminated with Status 1 . ****

(5488) **** 2007/08/20 16:40:40 Child 5510 terminated with Status 0 . ****

Instance on host bssldev1 started

Checking Installation

...............

Starting IGS

...

[1] 5570

IGS on host bssldev1 started

******************************88

I have only one idea left.. which kernel version are you using?

It may be a timing error or something like that, I think of that because apparently the database gots correctly started but startsap does not detect that for some reason.

Markus

Markus....

Kernel level is 640 and patch level is 175

I don't understand wat do u mean by timing error .........n wat shd i do now?? I acnnot proceed with SAP upgrade without resolving this error.

Regards,

Ankita

I mean with timing error, that startsap tries to start the database and doesn't wait long enough until the database is open.

Short solution: Start the system manually and repeat you actual phase if you're in the middle of the upgrade.

Longer solution: Open an OSS call under BC-UPG and ask SAP for assistance. If this is a production upgrade, I suggest using prio "very high".

Markus

Okies ....no i cannot start my SAP Upgrade cos its asking path of STARTSAP & STOPSAP in Initialization Phase and then the phase tries to stop & Start SAP and phase is cancelled with errors. Thsi si essentila to proceed ....else how il it go to shadow insatnce.

Its DEV system so i can open High msg and SAP is not responsding since Last week.....

Anyways thanks for ur help.........i'll try to do something and wil update you too...

Regards,

Ankita

What do you get when you enter

% which startsap

Markus

I have found something:

Note 809477 - startsap and stopsap <= SAP WebAs 640

This correction is pretty new and it has a fix for Solaris.

I suggest trying those two scripts also, I think, the support will suggest them to update neverless

Markus

Hello Markus,

This also didn't work for me ....n after so many changes since yesterday i am geting new error if SAP starts up in 3 steps ie. listener, oracle and SAP.

I am geting dump on initial logon only now -

Runtime Error START_CALL_SICK

SICK shows: DB release ORACLE is not supported with this kernel (640)

Severe problems were detected during initial system check.

Please, do not use that system before fixing these problems.

God knows ..................wats going on .......i don't knw how to resolve it noiw.

I am stuck up badly.

bye ....wil update u if resolved

ankita

if you are using Oracle10 you have to upgrade the kernel to the newest patchlevel (dw*.car and lib_dbsl.car).

peter

Hello Peter,

I am not able to find dw*.CAR for 640 Kernel on marketplace. Can u pls tell me the reqd path ...

Thanks,

Ankita

check here:

http://service.sap.com/patches

--> Entry by Application Group

--> SAP NetWeaver

--> SAP NETWEAVER

--> SAP NETWEAVER 04

--> Entry by Component

--> Application Server ABAP

--> SAP KERNEL 6.40 64-BIT (UNICODE)

--> Solaris on SPARC 64bit

Here download the FULL kernel (not only dw*.sar):

SAPEXE.SAR (OS independent)

SAPEXEDB.SAR (Oracle)

Markus

hey Markus ......thanks 4 ur support ...error got resiolved by removing

dbms/type = ora from DEFAULT.PFL from RZ10 transactiona fter starting SAP in 3 steps only ..

Now SAP strated with STARTSAP cmd.....but stuck up in next error in PREPARE after upgarde to client 10 & kernel 700. pls see my other msg n suggest if possible.

Thanks ...

Ankita

Answers (2)

Hello,

If it works manually (with ora<sid>) but does not work fine with startsap (<sid>adm), the problem is probably in the environment variable settings. I would especially check that ORA_NLS33 is set to

/oracle/client/92x_64/ocommon/nls/admin/data

Regards,

Alfonso

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

what do you see in trans.log? What´s the exact error message you get?

Markus

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count

2EETW169 no connect possible: "DBMS = ORACLE ---dbs_ora_tnsname = 'DEV'

Accepted Solutions (1)

Accepted Solutions (1)

Answers (2)

Answers (2)

Re: HTTP Receiver adapter with Dynamic value in UR...

How to create a rolling forecast in SAC? I have an...

In SAP Hana Cloud, do packages exist as database o...

Re: Mass Update a Zfield in Std Table with Split &...

Re: Change BW Query Initial Variable Input at runt...