R3trans -d -- 'OCIServerAttach' failed: rc = 12154 -Oracle 10.2.0.2 AIX

[Former Member]

Hello,

i have Problem under AIX 5.3 with Oracle 10.2.0.2.

I have Upgraded from Oracle 9.2.0.7 to 10.2.0.2 + Interim Patches

Now i have the Problem that i cant run R3trans -d / R3trans -x successfuly.

ENV from

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000 Mon Jun 30 16:58:10 2008 56 0.000056

4 ETW000 db_con_init called 10 0.000066

4 ETW000 create_con (con_name=R/3) 32 0.000098

4 ETW000 Loading DB library '/usr/sap/ST1/SYS/exe/run/dboraslib.o' ...

4 ETW000 35 0.000133

4 ETW000 load shared library (/usr/sap/ST1/SYS/exe/run/dboraslib.o), hdl 0

4 ETW000 7031 0.007164

4 ETW000 Library '/usr/sap/ST1/SYS/exe/run/dboraslib.o' loaded

4 ETW000 16 0.007180

4 ETW000 function DbSlExpFuns loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.o

4 ETW000 27 0.007207

4 ETW000 Version of '/usr/sap/ST1/SYS/exe/run/dboraslib.o' is "640.00", patchlevel (0.199)

4 ETW000 235 0.007442

4 ETW000 function dsql_db_init loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.o

4 ETW000 16 0.007458

4 ETW000 function dbdd_exp_funs loaded from library /usr/sap/ST1/SYS/exe/run/dboraslib.o

4 ETW000 35 0.007493

4 ETW000 New connection 0 created 17 0.007510

4 ETW000 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255,

con_opt = 255, occ = NO

4 ETW000 20 0.007530

4 ETW000 db_con_connect (con_name=R/3) 33 0.007563

4 ETW000 find_con_by_name found the following connection for reuse:

4 ETW000 25 0.007588

4 ETW000 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 17 0.007605

4 ETW000 Got ORACLE_HOME=/oracle/ST1/1020_64 from environment

4 ETW000 312 0.007917

4 ETW000 -->oci_initialize (con_hdl=0) 61 0.007978

4 ETW000 got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment

4 ETW000 25 0.008003

4 ETW000 Client NLS settings: AMERICAN_AMERICA.UTF8 1736 0.009739

4 ETW000 Logon as OPS$-user to get SAPR3's password 29 0.009768

4 ETW000 Connecting as /@ST1 on connection 0 (nls_hdl 0) ... (dbsl 640 250407)

4 ETW000 35 0.009803

4 ETW000 Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 35 0.009838

4 ETW000 0 UTF8 1 110ced000 110d05478 110d04d28

4 ETW000 26 0.009864

4 ETW000 Allocating service context handle for con_hdl=0 11 0.009875

4 ETW000 Allocating server context handle 12 0.009887

"trans.log" 79 lines, 7691 characters

4 ETW000 Connecting as SAPR3/@ST1 on connection 0 (nls_hdl 0) ... (dbsl 640 250407)

4 ETW000 18 0.042437

4 ETW000 Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 17 0.042454

4 ETW000 0 UTF8 1 110ced000 110d05478 110d04d28

4 ETW000 17 0.042471

4 ETW000 server_detach(con_hdl=0,stale=0,svrhp=110d07798)

4 ETW000 25 0.042496

4 ETW000 Detaching from DB Server (con_hdl=0,svchp=110cf59d8,srvhp=110d07798)

4 ETW000 16 0.042512

4 ETW000 Deallocating server context handle 110d07798 21 0.042533

4 ETW000 Allocating server context handle 15 0.042548

4 ETW000 Attaching to DB Server ST1 (con_hdl=0,svchp=110cf59d8,srvhp=110d07798)

4 ETW000 22 0.042570

4 ETW000 *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154

4 ETW000 13931 0.056501

4 ETW000 *** ERROR => CONNECT failed with sql error '12154'

4 ETW000 17 0.056518

4 ETW000 set_ocica() -> OCI or SQL return code 12154 9 0.056527

4 ETW000 ***LOG BY2=>sql error 12154 performing CON

4 ETW000 26 0.056553

4 ETW000 ***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified

4 ETW000 16 0.056569

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

~

ENV from ora sqlplus

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jun 30 17:01:02 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter user-name: SAPR3

Enter password:

/oracle/ST1/.kshrc[27]: uname: not found.

/oracle/ST1/.kshrc[44]: tty: not found.

/oracle/ST1/.kshrc[44]: uname: not found.

/oracle/ST1/.kshrc[73]: tset: not found.

/oracle/ST1/.kshrc[74]: stty: not found.

/oracle/ST1/.kshrc[80]: tty: not found.

/oracle/ST1/.kshrc[104]: tty: not found.

/oracle/ST1/.kshrc[105]: cut: not found.

/oracle/ST1/.kshrc[105]: hostname: not found.

/oracle/ST1/.kshrc[106]: whoami: not found.

/oracle/ST1/.kshrc[125]: hostname: not found.

/oracle/ST1/.kshrc[132]: hostname: not found.

/oracle/ST1/.kshrc[133]: hostname: not found.

/oracle/ST1/.kshrc[134]: uname: not found.

ERROR:

ORA-00600: internal error code, arguments: , , , , , ,

,

or User: system is the same problem

sqlplus /nolog

connect / as sysdba is possible

/oracle/ST1/1020_64/network/admin/listener.ora

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

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

2. Name..........:

3. Date..........:

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

LISTENER =

(ADDRESS_LIST =

(ADDRESS=

(PROTOCOL=IPC)

(KEY= ST1)

)

(ADDRESS =

(COMMUNITY = sap.world)

(PROTOCOL = TCP)

(Host = saphost1)

(Port = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 4096)

(SID_NAME = ST1)

(ORACLE_HOME = /oracle/ST1/1020_64)

(PRESPAWN_MAX = 10)

)

)

/oracle/ST1/1020_64/network/admin/tnsnames.ora

ST1.world =

(DESCRIPTION =

(SDU = 4096)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = sap.world)

(PROTOCOL = TCP)

(Host = saphost1)

(Port = 1527)

)

)

(CONNECT_DATA =

(SID = ST1)

(GLOBAL_NAME = ST1.world)

)

)

/usr/sap/trans/tnsnames.ora

ST1.world =

(DESCRIPTION =

(SDU = 4096)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = sap.world)

(PROTOCOL = TCP)

(Host = saphost1)

(Port = 1527)

)

)

(CONNECT_DATA =

(SID = ST1)

(GLOBAL_NAME = ST1.world)

)

)

/usr/sap/trans/sqlnet.ora

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

1. Filename......: template sqlnet.ora

2. Name..........:

3. Date..........:

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

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

SQLNET.EXPIRE_TIME = 0

NAMES.DEFAULT_DOMAIN = world

NAME.DEFAULT_ZONE = world

#SQLNET.AUTHENTICATION_SERVICES = (ALL)

What did i wrong ?

thanks for help

[Former Member]

Hello Dennis,

just stumbled across this environmemt variable of yours:

TNS_ADMIN=/usr/sap/ST1/SYS/profile

So User ST1adm will use /usr/sap/ST1/SYS/profile/tnsnames.ora

Have a look there! So far you only showed tnsnames.ora from /oracle/ST1/1020_64/network/admin and /usr/sap/trans

hope this helps

[Former Member]

Hi Joe_Bo,

thanks, but the same problem:

here the trans.log

st1adm> R3trans -d -v

This is R3trans version 6.13 (release 640 - 14.05.08 - 14:16:00).

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

R3trans finished (0012).

st1adm> vi trans.log

"trans.log" 81 lines, 7859 characters

4 ETW000 R3trans version 6.13 (release 640 - 14.05.08 - 14:16:00).

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

4 ETW000

4 ETW000 date&time : 01.07.2008 - 17:31:37

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] Tue Jul 1 17:31:37 2008 54 0.000054

4 ETW000 [dev trc ,00000] db_con_init called 10 0.000064

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

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

4 ETW000 34 0.000130

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

4 ETW000 7013 0.007143

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

4 ETW000 16 0.007159

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

4 ETW000 27 0.007186

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

4 ETW000 234 0.007420

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

4 ETW000 17 0.007437

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

4 ETW000 34 0.007471

4 ETW000 [dev trc ,00000] New connection 0 created 17 0.007488

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

con_opt = 255, occ = NO

4 ETW000 20 0.007508

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

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

4 ETW000 24 0.007564

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 18 0.007582

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

4 ETW000 314 0.007896

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

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

4 ETW000 24 0.007966

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 1721 0.009687

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 30 0.009717

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

4 ETW000 32 0.009749

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

4 ETW000 34 0.009783

4 ETW000 [dev trc ,00000] 0 UTF8 1 110ced000 110d05478 110d04d28

4 ETW000 27 0.009810

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

4 ETW000 [dev trc ,00000] Allocating server context handle 21 0.009842

4 ETW000 [dev trc ,00000] Attaching to DB Server ST1 (con_hdl=0,svchp=110cf59d8,srvhp=110d07798)

4 ETW000 55 0.009897

4 ETW000 [dev trc ,00000] Tue Jul 1 17:31:38 2008 930341 0.940238

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

4 ETW000 20 0.940258

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

4 ETW000 18 0.940276

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12537 25 0.940301

4 ETW000 [dev trc ,00000] Try to connect with default password 20 0.940321

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

4 ETW000 19 0.940340

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

4 ETW000 18 0.940358

4 ETW000 [dev trc ,00000] 0 UTF8 1 110ced000 110d05478 110d04d28

4 ETW000 17 0.940375

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

4 ETW000 24 0.940399

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=110cf59d8,srvhp=110d07798)

4 ETW000 16 0.940415

4 ETW000 [dev trc ,00000] Deallocating server context handle 110d07798 21 0.940436

4 ETW000 [dev trc ,00000] Allocating server context handle 15 0.940451

4 ETW000 [dev trc ,00000] Attaching to DB Server ST1 (con_hdl=0,svchp=110cf59d8,srvhp=110d07798)

4 ETW000 24 0.940475

4 ETW000 [dev trc ,00000] Tue Jul 1 17:31:39 2008 915601 1.856076

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

4 ETW000 19 1.856095

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

4 ETW000 18 1.856113

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12537 10 1.856123

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

4 ETW000 31 1.856154

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-12537: TNS:connection closed [dblink#3 @ 428]

4 ETW000 15 1.856169

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

the env from <SID>adm

_=/usr/bin/env

ESCDELAY=5000

LANG=en_US

THREAD=NOPS

LOGIN=ST1adm

PATH=/oracle/ST1/1020_64/bin:.:/home/ST1adm:/usr/sap/ST1/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin

NLS_LANG=AMERICAN_AMERICA.UTF8

ORACLE_BASE=/oracle

LC__FASTMSG=true

TLS=/hntsp1/tls

EDITOR=vi

HISTFILE=/home/ST1adm/.sh_history

LOGNAME=ST1adm

RFCEXEC_SEC_FILE_PATH=/sapmnt/ST1/exe

MAIL=/usr/spool/mail/ST1adm

dbs_ora_tnsname=ST1

ORACLE_SID=ST1

LOCPATH=/usr/lib/nls/loc

ST1adm>

DB_SID=ST1

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

USER=ST1adm

DSM_LOG=/usr/tivoli/tsm/client/ba/log

SHR=/hntmnt/share

AUTHSTATE=files

LANGUAGE=American_America.US7ASCII

TNS_ADMIN=/usr/sap/trans

dbs_ora_schema=SAPR3

SHELL=/bin/ksh

ODMDIR=/etc/objrepos

HISTSIZE=200

MALLOCTYPE=3.1

HOME=/home/ST1adm

NSORDER=local,bind

ADSM=/usr/tivoli/tsm/client/ba

FCEDIT=vi

TERM=xterm

MAILMSG=[YOU HAVE NEW MAIL]

DSM_DIR=/usr/tivoli/tsm/client/ba/bin

ORACLE_HOME=/oracle/1020_64

PWD=/usr/sap/trans/bin

TZ=NFT-1DFT,M3.5.0,M10.5.0

dbms_type=ORA

ENV=/home/ST1adm/.kshrc

SAPSYSTEMNAME=ST1

MAILCHECK=60

A__z=! LOGNAME="*MAILCHECK

LIBPATH=/usr/lib:/lib:/usr/sap/ST1/SYS/exe/run:/oracle/client/92x_64/lib

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

st1adm> ls -la /oracle/client/92x_64/lib

total 116376

drwxr-sr-x 2 root system 256 Apr 03 01:12 .

drwxr-sr-x 5 root system 256 Apr 03 01:13 ..

-rwxr-xr-x 1 root system 15519560 Apr 03 01:12 libclntsh.a

-rwxr-xr-x 1 root system 14527760 Apr 03 01:13 libocijdbc9.so

-rwxr-xr-x 1 root system 15041642 Apr 03 01:13 libocijdbc9_g.so

-rwxr-xr-x 1 root system 172752 Apr 03 01:12 libocijdbcst9.a

-rwxr-xr-x 1 root system 6453 Apr 03 01:12 libwtc9.a

-rwxr-xr-x 1 root system 14304793 Apr 03 01:12 libwtc9.so

Edited by: Dennis Schneck on Jul 1, 2008 4:39 PM

[Former Member]

Hello Dennis. In your case you need to set

ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data variable to your "SIDadm" environment,and

ORA_NLS10=$ORACLE_HOME/nls/data to your "oraSID". Check this. Regards.

[Former Member]

Hello Sergo,

thanks! i have set this

but i can not see my mistake!

here are my new set ENV

User: <SID>adm

nt1adm> env

_=/usr/bin/env

ESCDELAY=5000

LANG=en_US

THREAD=NOPS

LOGIN=nt1adm

PATH=/oracle/NT1/817_64/bin:.:/home/nt1adm:/usr/sap/NT1/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin

NLS_LANG=AMERICAN_AMERICA.UTF8

ORACLE_BASE=/oracle

LC__FASTMSG=true

TLS=/hntsp1/tls

EDITOR=vi

HISTFILE=/home/nt1adm/.sh_history

LOGNAME=nt1adm

RFCEXEC_SEC_FILE_PATH=/sapmnt/NT1/exe

MAIL=/usr/spool/mail/nt1adm

dbs_ora_tnsname=NT1

ORACLE_SID=NT1

LOCPATH=/usr/lib/nls/loc

nt1adm>

DB_SID=NT1

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

USER=nt1adm

DSM_LOG=/usr/tivoli/tsm/client/ba/log

SHR=/hntmnt/share

AUTHSTATE=files

LANGUAGE=American_America.US7ASCII

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

TNS_ADMIN=/usr/sap/trans

DISPLAY=hntvsde01.heller.biz:0.0

dbs_ora_schema=SAPR3

SHELL=/bin/ksh

ODMDIR=/etc/objrepos

HISTSIZE=200

MALLOCTYPE=3.1

HOME=/home/nt1adm

NSORDER=local,bind

ADSM=/usr/tivoli/tsm/client/ba

FCEDIT=vi

TERM=xterm

MAILMSG=[YOU HAVE NEW MAIL]

DSM_DIR=/usr/tivoli/tsm/client/ba/bin

ORACLE_HOME=/oracle/NT1/817_64

PWD=/home/nt1adm

TZ=NFT-1DFT,M3.5.0,M10.5.0

dbms_type=ORA

ENV=/home/nt1adm/.kshrc

SAPSYSTEMNAME=NT1

MAILCHECK=60

A__z=! LOGNAME="*MAILCHECK

LIBPATH=/usr/lib:/lib:/usr/sap/NT1/SYS/exe/run:/oracle/client/92x_64/lib

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

User: ora<SID>

oraST1> env

_=/bin/env

ESCDELAY=5000

LANG=en_US

THREAD=NOPS

LOGIN=oraST1

STAGING_AREA=/oracle/stage/1020_64

ORACLE_PSRV=ST1

PATH=/oracle/ST1/1020_64/bin:/usr/sap/ST1/SYS/exe/run:/bin:/usr/bin:/usr/sbin:/usr/bin/X11:/usr/ucb:/usr/ccs/bin:/usr/local/bin:/etc:.

SAPBACKUP=/oracle/ST1/sapbackup

NLS_LANG=AMERICAN_AMERICA.US7ASCII

ORACLE_BASE=/oracle

LC__FASTMSG=true

TLS=/hntsp1/tls

EDITOR=vi

HISTFILE=/oracle/ST1/.sh_history

LOGNAME=oraST1

SAPTRACE=/oracle/ST1/saptrace

MAIL=/usr/spool/mail/oraST1

ORACLE_SID=ST1

LOCPATH=/usr/lib/nls/loc

oraST1>

USER=oraST1

DSM_LOG=/usr/lpp/adsm/log

SHR=/hntmnt/share

AUTHSTATE=files

LANGUAGE=American_America.US7ASCII

TNS_ADMIN=/usr/sap/trans

ORA_NLS10=/oracle/ST1/1020_64/nls/data

SHELL=/bin/ksh

ODMDIR=/etc/objrepos

HISTSIZE=200

SAPDATA_HOME=/oracle/ST1

HOME=/oracle/ST1

SAPARCH=/oracle/ST1/saparch

NSORDER=local,bind

ADSM=/usr/tivoli/tsm/client/ba

FCEDIT=vi

TERM=xterm

MAILMSG=[YOU HAVE NEW MAIL]

DSM_DIR=/usr/tivoli/tsm/client/ba/bin

ORACLE_HOME=/oracle/ST1/1020_64

PWD=/oracle/ST1

TZ=NFT-1DFT,M3.5.0,M10.5.0

ENV=/oracle/ST1/.kshrc

SAPREORG=/oracle/ST1/sapreorg

AIXTHREAD_SCOPE=S

SAPSYSTEMNAME=ST1

LIBRARY_PATH=/oracle/ST1/1020_64

MAILCHECK=60

A__z=! LOGNAME="*MAILCHECK

LIBPATH=/oracle/ST1/1020_64/lib:/oracle/ST1/1020_64/lib32:

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

ST1adm> R3trans -d -v

This is R3trans version 6.13 (release 640 - 14.05.08 - 14:16:00).

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

R3trans finished (0012).

ST1adm> vi trans.log

"trans.log" 47 lines, 4388 characters

4 ETW000 R3trans version 6.13 (release 640 - 14.05.08 - 14:16:00).

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

4 ETW000

4 ETW000 date&time : 02.07.2008 - 08:12:49

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] Wed Jul 2 08:12:49 2008 55 0.000055

4 ETW000 [dev trc ,00000] db_con_init called 10 0.000065

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

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

4 ETW000 34 0.000132

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

4 ETW000 4872 0.005004

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

4 ETW000 15 0.005019

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

4 ETW000 28 0.005047

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

4 ETW000 225 0.005272

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

4 ETW000 17 0.005289

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

4 ETW000 33 0.005322

4 ETW000 [dev trc ,00000] New connection 0 created 18 0.005340

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

con_opt = 255, occ = NO

4 ETW000 19 0.005359

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

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

4 ETW000 25 0.005416

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 17 0.005433

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

4 ETW000 316 0.005749

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

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

4 ETW000 24 0.005818

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate(mode=0)' failed: rc = -1

4 ETW000 14301 0.020119

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code -1 19 0.020138

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

4 ETW000 27 0.020165

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

4 ETW000 27 0.020192

4 ETW000 [dblink ,00428] ***LOG BY0=>Cannot get Oracle error text. [dblink#3 @ 428]

4 ETW000 25 0.020217

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

my Problem is i cat find the Problem why the

PATH=/oracle/NT1/817_64/bin

ORACLE_HOME=/oracle/NT1/817_64

is set to 817_64

here are my ENV-Scripts:

.sapenv_<HOSTNAME>.csh

1. SAP R/3 Environment

setenv SAPSYSTEMNAME ST1

setenv DIR_LIBRARY /usr/sap/ST1/SYS/exe/run

foreach d ( /usr/sap/ST1/SYS/exe/run $HOME . )

set i=0

foreach p ( $path )

if ( "$p" == "$d" ) then

set i=1

break

endif

end

if ( $i == 0 ) then

set path = ( $d $path )

endif

end

switch (`uname`)

case Sun*:

case SIN*:

case Reliant*:

foreach d ( /usr/ccs/bin /usr/ucb )

set i=0

foreach p ( $path )

if ( "$p" == "$d" ) then

set i=1

break

endif

end

if ( $i == 0 ) then

set path = ( $path $d )

endif

end

breaksw

case OSF*:

foreach d ( /usr/sbin )

set i=0

foreach p ( $path )

if ( "$p" == "$d" ) then

set i=1

break

endif

end

if ( $i == 0 ) then

set path = ( $path $d )

endif

end

".sapenv_ST1TST.csh" 293 lines, 7890 characters

if ( $rc1 == 0 ) then

alias cdD 'cd /usr/sap/$SAPSYSTEMNAME/DVEBM*[0-9][0-9]'

else if ( $rc2 == 0 ) then

alias cdDi 'cd /usr/sap/$SAPSYSTEMNAME/D[0-9][0-9]'

else if ( $rc3 == 0) then

alias cdG 'cd /usr/sap/$SAPSYSTEMNAME/G[0-9][0-9]'

endif

end

endif

setenv dbms_type ORA

setenv dbs_ora_tnsname ST1

setenv dbs_ora_schema SAPR3

setenv ORACLE_SID ST1

setenv ORACLE_BASE /oracle

setenv TNS_ADMIN /usr/sap/trans

setenv LIBPATH /usr/lib:/lib:/usr/sap/ST1/SYS/exe/run:/oracle/client/92x_64/lib

setenv NLS_LANG AMERICAN_AMERICA.UTF8

setenv ORACLE_HOME /oracle/ST1/1020_64

setenv ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

1. end SAP R/3 Environment

.sapenv_<HOSTNAME>.sh

1. SAP R/3 Environment

SAPSYSTEMNAME=ST1; export SAPSYSTEMNAME

DIR_LIBRARY=/usr/sap/ST1/SYS/exe/run; export DIR_LIBRARY

for d in /usr/sap/ST1/SYS/exe/run $HOME .; do

i=0

for p in `echo $PATH | sed 's/:/ /g'`; do

if [ "$p" = "$d" ]; then

i=1

break

fi

done

if [ $i -eq 0 ]; then

PATH=$:$; export PATH fi done case `uname` in Sun* | SIN* | Reliant*) for d in /usr/ccs/bin /usr/ucb; do i=0 for p in `echo $PATH | sed 's/:/ /g'`; do if [ "$p" = "$d" ]; then i=1 break fi done if [ $i -eq 0 ]; then PATH=$:$; export PATH

fi

done

;;

OSF*)

for d in /usr/sbin; do

i=0

for p in `echo $PATH | sed 's/:/ /g'`; do

if [ "$p" = "$d" ]; then

i=1

break

fi

done

if [ $i -eq 0 ]; then

PATH=$:$; export PATH

fi

done

;;

".sapenv_ST1TST.sh" 269 lines, 7311 characters

rc3=$?

if [ $rc1 -eq 0 ]; then

alias cdD='cd /usr/sap/$SAPSYSTEMNAME/DVEBM*[0-9][0-9]'

elif [ $rc2 -eq 0 ]; then

alias cdDi='cd /usr/sap/$SAPSYSTEMNAME/D[0-9][0-9]'

elif [ $rc3 -eq 0 ]; then

alias cdG='cd /usr/sap/$SAPSYSTEMNAME/G[0-9][0-9]'

fi

done

export dbms_type=ORA

export dbs_ora_tnsname=ST1

export dbs_ora_schema=SAPR3

export ORACLE_SID=ST1

export DB_SID=ST1

export ORACLE_BASE=/oracle

export TNS_ADMIN=/usr/sap/trans

export LIBPATH=/usr/lib:/lib:/usr/sap/ST1/SYS/exe/run:/oracle/client/92x_64/lib

export NLS_LANG=AMERICAN_AMERICA.UTF8

export ORACLE_HOME=/oracle/ST1/1020_64

export ORACLE_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

1. end SAP R/3 Environment

.kshrc

1. RDBMS environment

#if [ -f $HOME/.dbenv_`hostname`.sh ]; then

1. . $HOME/.dbenv_`hostname`.sh

#elif [ -f $HOME/.dbenv.sh ]; then

1. . $HOME/.dbenv.sh

#fi

1. User specific environment

#if [ -f $HOME/.customer.sh ]; then

#. $HOME/.customer.sh

#fi

1. set TERM environment variable, terminal mode and terminal options

if ( tty -s ) then

case `uname` in

AIX|BOS) TERM=$

tset -I -Q

stty erase '^{h' kill '}u' intr '^{c' susp '}z';;

HP*) TERM=$

tset -I -Q

stty erase '^{h' kill '}u' intr '^{c' susp '}z';;

OSF*) TERM=$

tset -I -Q

case $TERM in

vt*) stty erase '^{?' kill '}u' intr '^{c' susp '}z';;

*) stty erase '^{h' kill '}u' intr '^{c' susp '}z';;

esac;;

SIN*) TERM=$

tset -I -Q

".kshrc" 144 lines, 5593 characters

AIX* | BOS*) alias L='ls -Flab'

1. modified 09.04.96 hed

#alias ll='ls -lb'

alias ll='ls -Alb'

alias Ps='ps -ef | grep';;

Sun*) alias L='ls -Flab'

alias ll='ls -lb'

alias Ps='ps -ef | grep';;

HP*) alias er='eval `/usr/bin/X11/resize`'

alias L='ls -Flab'

alias Ps='ps -ef | grep';;

SIN*) alias L='ls -Fla'

alias ll='ls -l'

alias Ps='ps -ef | grep';;

dgux*) alias L='ls -Fla'

alias ll='ls -l'

alias Ps='ps -ef | grep';;

OSF*) alias L='ls -Flag'

alias ll='ls -lg'

alias Ps='ps axgu | grep';;

*) alias L='ls -Flag'

alias ll='ls -lg'

alias Ps='ps -axgu | grep

[Former Member]

Hello. Change PATH for "SIDadm" directly. Regards.

[Former Member]

export PATH=/oracle/ST1/1020_64/bin:.:/home/st1adm:/usr/sap/ST1/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin

export ORACLE_HOME=/oracle/1020_64

st1adm> R3trans -d -v

This is R3trans version 6.13 (release 640 - 14.05.08 - 14:16:00).

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

R3trans finished (0012).

trans.log

4 ETW000 R3trans version 6.13 (release 640 - 14.05.08 - 14:16:00).

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

4 ETW000

4 ETW000 date&time : 02.07.2008 - 08:58:12

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] Wed Jul 2 08:58:12 2008 54 0.000054

4 ETW000 [dev trc ,00000] db_con_init called 11 0.000065

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

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

4 ETW000 35 0.000132

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

4 ETW000 4865 0.004997

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

4 ETW000 15 0.005012

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

4 ETW000 27 0.005039

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

4 ETW000 230 0.005269

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

4 ETW000 16 0.005285

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

4 ETW000 35 0.005320

4 ETW000 [dev trc ,00000] New connection 0 created 17 0.005337

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

con_opt = 255, occ = NO

4 ETW000 20 0.005357

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

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

4 ETW000 25 0.005413

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 18 0.005431

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

4 ETW000 304 0.005735

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

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

4 ETW000 25 0.005805

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate(mode=0)' failed: rc = -1

4 ETW000 6163 0.011968

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code -1 19 0.011987

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

4 ETW000 27 0.012014

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

4 ETW000 25 0.012039

4 ETW000 [dblink ,00428] ***LOG BY0=>Cannot get Oracle error text. [dblink#3 @ 428]

4 ETW000 25 0.012064

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

Edited by: Dennis Schneck on Jul 2, 2008 8:04 AM

[Former Member]

The ORACLE_HOME=/oracle/1020_64 is true directory? Usualy the directory are ORACLE_HOME=/oracle/SID/102_64 ....

Are you can check the "oracore" in this directory? Regards.

[Former Member]

sorry my fault!

i have set it to the right value, but the problem is not fixed

ST1adm> vi trans.log

"trans.log" 81 lines, 7859 characters

4 ETW000 R3trans version 6.13 (release 640 - 14.05.08 - 14:16:00).

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

4 ETW000

4 ETW000 date&time : 02.07.2008 - 09:14:47

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] Wed Jul 2 09:14:47 2008 55 0.000055

4 ETW000 [dev trc ,00000] db_con_init called 10 0.000065

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

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

4 ETW000 33 0.000130

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

4 ETW000 4868 0.004998

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

4 ETW000 15 0.005013

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

4 ETW000 27 0.005040

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

4 ETW000 227 0.005267

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

4 ETW000 17 0.005284

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

4 ETW000 34 0.005318

4 ETW000 [dev trc ,00000] New connection 0 created 17 0.005335

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

con_opt = 255, occ = NO

4 ETW000 20 0.005355

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

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

4 ETW000 25 0.005411

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 17 0.005428

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

4 ETW000 306 0.005734

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

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

4 ETW000 26 0.005805

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 1218 0.007023

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 26 0.007049

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

4 ETW000 33 0.007082

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

4 ETW000 33 0.007115

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 110cbb440 110cc2f20 110cc27d8

4 ETW000 25 0.007140

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

4 ETW000 [dev trc ,00000] Allocating server context handle 26 0.007178

"trans.log" 81 lines, 7859 characters

4 ETW000 19 0.947044

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

4 ETW000 18 0.947062

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 110cbb440 110cc2f20 110cc27d8

4 ETW000 17 0.947079

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

4 ETW000 25 0.947104

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=110cc4558,srvhp=110cc4778)

4 ETW000 16 0.947120

4 ETW000 [dev trc ,00000] Deallocating server context handle 110cc4778 20 0.947140

4 ETW000 [dev trc ,00000] Allocating server context handle 14 0.947154

4 ETW000 [dev trc ,00000] Attaching to DB Server ST1 (con_hdl=0,svchp=110cc4558,srvhp=110cc4778)

4 ETW000 26 0.947180

4 ETW000 [dev trc ,00000] Wed Jul 2 09:14:49 2008 942862 1.890042

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

4 ETW000 20 1.890062

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

4 ETW000 18 1.890080

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12537 10 1.890090

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

4 ETW000 38 1.890128

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-12537: TNS:connection closed [dblink#3 @ 428]

4 ETW000 16 1.890144

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

~

[Former Member]

Login under orasid stop listener, start again. After try to start sap. Regards.

[Former Member]

oraST1> lsnrctl stop

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on 02-JUL-2008 09:23:48

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

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ST1))

The command completed successfully

oraST1> lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on 02-JUL-2008 09:24:00

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

Starting /oracle/ST1/1020_64/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production

System parameter file is /oracle/ST1/1020_64/network/admin/listener.ora

Log messages written to /oracle/ST1/1020_64/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ST1)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.x.xx)(PORT=1527)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ST1))

but it hang at this point

if i login with annother session an try tnsping

oraST1> tnsping ST1

TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on 02-JUL-2008 09:26:24

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

Used parameter files:

/usr/sap/trans/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (SDU = 4096) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = sap.world) (PROTOCOL = TCP) (Host = saphost1) (Port = 1527))) (CONNECT_DATA = (SID = ST1) (GLOBAL_NAME = ST1.world)))

but it hang at this point

vi /oracle/ST1/1020_64/network/log/listener.log

02-JUL-2008 09:30:20 * 12531

TNS-12531: TNS:cannot allocate memory

Edited by: Dennis Schneck on Jul 2, 2008 8:35 AM

Edited by: Dennis Schneck on Jul 2, 2008 8:35 AM

[Former Member]

TNS-12531 TNS:cannot allocate memory

Cause: Sufficient memory could not be allocated to perform the desired activity.

Action: Either free some resource for TNS, or add more memory to the machine. For further details, turn on tracing and re-execute the operation.

Is the describe the error. Try to reboot server, and start listener and sap after. Regards.

[Former Member]

system rebootet

now i have a bigger problem:

i cant start / stop the oracle instance

oraST1> sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Jul 2 09:53:27 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> connect /as sysdba

Connected.

SQL> startup mount

ORA-01031: insufficient privileges

oraST1> sqlplus

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Jul 2 09:54:12 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter user-name: SAPR3

Enter password:

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

IBM AIX RISC System/6000 Error: 2: No such file or directory

oraST1> env

_=/bin/env

ESCDELAY=5000

LANG=en_US

THREAD=NOPS

LOGIN=oraST1

STAGING_AREA=/oracle/stage/1020_64

ORACLE_PSRV=ST1

PATH=/oracle/ST1/1020_64/bin:/usr/sap/ST1/SYS/exe/run:/bin:/usr/bin:/usr/sbin:/u sr/bin/X11:/usr/ucb:/usr/ccs/bin:/usr/local/bin:/etc:.

SAPBACKUP=/oracle/ST1/sapbackup

NLS_LANG=AMERICAN_AMERICA.US7ASCII

ORACLE_BASE=/oracle

LC__FASTMSG=true

TLS=/hntsp1/tls

EDITOR=vi

HISTFILE=/oracle/ST1/.sh_history

LOGNAME=oraST1

SAPTRACE=/oracle/ST1/saptrace

MAIL=/usr/spool/mail/oraST1

ORACLE_SID=ST1

LOCPATH=/usr/lib/nls/loc

oraST1>

USER=oraST1

DSM_LOG=/usr/lpp/adsm/log

SHR=/hntmnt/share

AUTHSTATE=files

LANGUAGE=American_America.US7ASCII

TNS_ADMIN=/usr/sap/trans

ORA_NLS10=/oracle/ST1/1020_64/nls/data

SHELL=/bin/ksh

ODMDIR=/etc/objrepos

HISTSIZE=200

SAPDATA_HOME=/oracle/ST1

HOME=/oracle/ST1

SAPARCH=/oracle/ST1/saparch

NSORDER=local,bind

ADSM=/usr/tivoli/tsm/client/ba

FCEDIT=vi

TERM=xterm

MAILMSG=[YOU HAVE NEW MAIL]

DSM_DIR=/usr/tivoli/tsm/client/ba/bin

ORACLE_HOME=/oracle/ST1/1020_64

PWD=/oracle/ST1

TZ=NFT-1DFT,M3.5.0,M10.5.0

ENV=/oracle/ST1/.kshrc

SAPREORG=/oracle/ST1/sapreorg

AIXTHREAD_SCOPE=S

SAPSYSTEMNAME=ST1

LIBRARY_PATH=/oracle/ST1/1020_64

MAILCHECK=60

A__z=! LOGNAME="*MAILCHECK

LIBPATH=/oracle/ST1/1020_64/lib:/oracle/ST1/1020_64/lib32:

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

[Former Member]

You think is bigger problem? How you create Oracle Upgrade?? Are you have Upgrade manual for example ? ) Are you know anything about SAPCONN ROLE ?

Read 834917 and 1028220 Notes. Also good if you read the Rules on this forum, for example how you can add points for good answers (2,6,10 points). Regards.

[Former Member]

>How you create Oracle Upgrade?

with dbua (upgrade agent from oracle)

>Are you have Upgrade manual for example ?

no

>Are you know anything about SAPCONN ROLE ?

no, then i have to look for

>Read 834917 and 1028220 Notes. Also good if you read the Rules on this forum, for >example how you can add points for good answers (2,6,10 points). Regards.

thanks ALL for help!

[Former Member]

The notes will tell you where you can download an Oracle 9.2 client.

I wonder why SAP does allow you to install SAP Enterprise with Oracle 10g, but without Oracle client 9.2...

Maybe it is already there, but hidden a bit?

[markus_doehr2]

There are various possibilities depending on what release and kernel and database version you use.

Kernel 46D/6.20/6.40 uses Oracle Client 9.2.0.x against Oracle 10.2.0.2

Kernel 46D_EX2/640_EX2 uses Oracle Instantclient 10.2.0.2

Kernel 7.00 uses Oracle Instantclient 10.2.0.2

So a "newly installed system" based on 7.00 will use by default the 10.2.0.2 client.

If you want to use the 10.2.0.2 client you need to use an EX2 kernel.

Markus

[Former Member]

Hi Markus,

thanks for help

i have downloaded the file: OCL92064.SAR from SAP.

And extract it to /oracle/client

Set the ENV for User <SID>adm:

LIBPATH=/usr/lib:/lib:/usr/sap/ST1/SYS/exe/run:/oracle/client/92x_64/lib

st1adm> R3trans -d

This is R3trans version 6.13 (release 640 - 14.05.08 - 14:16:00).

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

R3trans finished (0012).

trans.log

4 ETW000 R3trans version 6.13 (release 640 - 14.05.08 - 14:16:00).

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

4 ETW000

4 ETW000 date&time : 01.07.2008 - 10:59:18

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000 [dev trc ,00000] Tue Jul 1 10:59:18 2008 52 0.000052

4 ETW000 [dev trc ,00000] db_con_init called 10 0.000062

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

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

4 ETW000 33 0.000126

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

4 ETW000 4834 0.004960

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

4 ETW000 16 0.004976

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

4 ETW000 27 0.005003

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

4 ETW000 249 0.005252

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

4 ETW000 17 0.005269

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

4 ETW000 37 0.005306

4 ETW000 [dev trc ,00000] New connection 0 created 17 0.005323

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

con_opt = 255, occ = NO

4 ETW000 19 0.005342

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

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

4 ETW000 24 0.005397

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 18 0.005415

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

4 ETW000 299 0.005714

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

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

4 ETW000 24 0.005798

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 1175 0.006973

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 23 0.006996

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

4 ETW000 32 0.007028

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

4 ETW000 33 0.007061

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 110cbb440 110cc2f20 110cc27d8

4 ETW000 25 0.007086

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

4 ETW000 [dev trc ,00000] Allocating server context handle 19 0.0071164 ETW000 [dev trc ,00000] Attaching to DB Server ST1 (con_hdl=0,svchp=110cc4558,srvhp=110cc4778)

4 ETW000 56 0.007172

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

4 ETW000 7810 0.014982

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

4 ETW000 18 0.015000

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12154 18 0.015018

4 ETW000 [dev trc ,00000] Try to connect with default password 29 0.015047

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

4 ETW000 17 0.015064

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

4 ETW000 17 0.015081

4 ETW000 [dev trc ,00000] 0 US7ASCII 1 110cbb440 110cc2f20 110cc27d8

4 ETW000 17 0.015098

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

4 ETW000 24 0.015122

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=110cc4558,srvhp=110cc4778)

4 ETW000 15 0.015137

4 ETW000 [dev trc ,00000] Deallocating server context handle 110cc4778 20 0.015157

4 ETW000 [dev trc ,00000] Allocating server context handle 13 0.015170

4 ETW000 [dev trc ,00000] Attaching to DB Server ST1 (con_hdl=0,svchp=110cc4558,srvhp=110cc4778)

4 ETW000 23 0.015193

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

4 ETW000 6537 0.021730

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

4 ETW000 16 0.021746

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12154 10 0.021756

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

4 ETW000 36 0.021792

4 ETW000 [dblink ,00428] ***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified [dblink#3 @ 428]

4 ETW000 15 0.021807

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

Edited by: Dennis Schneck on Jul 2, 2008 8:23 AM

[Former Member]

I am quite sure you will need Oracle client 9.2.0.8. Read the note I mentioned, and other notes mentioned therein.

hope this helps

[Former Member]

ok i try the client 9.2.0.8, but we have a system that is new installed

with oracle 10.2.0.2 and dont have a 9.2.0.x client

[Former Member]

What is your Oracle client version? And SAP version?

It seems you are using Oracle client 10.2 with SAP kernel 6.40.

Maybe you still need Oracle client 9.2.0.8, have a look at SAP note 180430.

[Former Member]

>What is your Oracle client version? And SAP version?

Oracle Client from Archiv: OCL10264_V2.SAR

SAP R/3 Enterprise

SAP_BASIS 620 Level 0064