cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

startdb termininated with error code 12

Former Member

on ‎12-22-2010 10:42 AM

0 Kudos

Hi ,

I have done 10g upgrade after that am not able to startdb

When i startdb it is terminating with error code 12

But i can manually start db by startup

Please check the startdb.log

-

Wed Dec 22 16:07:02 IST 2010

LOGFILE FOR STARTING ORACLE

Trying to start PCP database ...

-

Wed Dec 22 16:07:02 IST 2010

checking required environment variables

ORACLE_HOME is >/oracle/PCP/102_64<

ORACLE_SID is >PCP<

-

Wed Dec 22 16:07:02 IST 2010

check initora

-

Wed Dec 22 16:07:02 IST 2010

check initora

-

Wed Dec 22 16:07:02 IST 2010

checking V2 connect

02

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

Used parameter files:

/oracle/PCP/102_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

VICE_NAME = PCP)))

OK (0 msec)

tnsping: V2 connect to PCP

-

Wed Dec 22 16:07:02 IST 2010

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

Wed Dec 22 16:07:02 IST 2010

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

Wed Dec 22 16:07:03 IST 2010

starting database

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 22 16:07:03 2010

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 3204448256 bytes

Fixed Size 2056600 bytes

Variable Size 1645645416 bytes

Database Buffers 1542029312 bytes

Redo Buffers 14716928 bytes

Database mounted.

Database opened.

bit Production

With the Partitioning, Data Mining and Real Application Testing options

-

Wed Dec 22 16:07:08 IST 2010

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

      • ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/PCP/SYS/exe/run/startdb: Terminating with error code 12

So please suggest what to do

Thanks ,

Amar

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
‎12-22-2010 1:44 PM
0 Kudos

Hi

If you see the below log 

Wed Dec 22 16:07:03 IST 2010
starting database
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 22 16:07:03 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 3204448256 bytes
Fixed Size 2056600 bytes
Variable Size 1645645416 bytes
Database Buffers 1542029312 bytes
Redo Buffers 14716928 bytes
Database mounted.
Database opened.
bit Production
With the Partitioning, Data Mining and Real Application Testing options
Wed Dec 22 16:07:08 IST 2010
Connect to the database to verify, that the database is now open
R3trans check finished with return code: 12
      • ERROR: Startup of database failed
Notify Database Administrator.
/usr/sap/PCP/SYS/exe/run/startdb: Terminating with error code 12

When you execute startdb, it will try to execute R3trans and check the db connectivity, in your case R3trans is not working so it thinks DB is down and tries to start and it does start successfully. Once the db is started to verify it it again execute R3trans and it fails so the system says that it terminated with error code 12.

But in reality the db has infact started. The problem is with your environment variable, fix it or you can ignore the error message from startdb

Regards,

SBK

Show replies
Show replies
Former Member
‎12-22-2010 2:40 PM
0 Kudos

SBK, If you ignore the messages from the logs then how to rectify the errors.

Former Member
‎12-23-2010 5:42 AM
0 Kudos

first i started the listener please check the log posted below

PCBL_TES:orapcp 2> lsnrctl start

LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 23-DEC-2010 11:16:30

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

Starting /oracle/PCP/102_64/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 10.2.0.4.0 - Production

System parameter file is /oracle/PCP/102_64/network/admin/listener.ora

Log messages written to /oracle/PCP/102_64/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PCP.WORLD)))

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

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PCBL_TES)(PORT=1527)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PCP.WORLD))

STATUS of the LISTENER

-

Alias LISTENER

Version TNSLSNR for HPUX: Version 10.2.0.4.0 - Production

Start Date 23-DEC-2010 11:16:30

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/PCP/102_64/network/admin/listener.ora

Listener Log File /oracle/PCP/102_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PCP.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PCP)))

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

Services Summary...

Service "PCP" has 1 instance(s).

Instance "PCP", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

Former Member
‎12-23-2010 5:44 AM
0 Kudos

Then i have given startdb as below

PCBL_TES:orapcp 3> startdb

Trying to start PCP database ...

Log file: /oracle/PCP/startdb.log

/usr/sap/PCP/SYS/exe/run/startdb: Terminating with error code 12

startdb.log shows like this

PCBL_TES:orapcp 5> more startdb.log

-

Thu Dec 23 11:18:03 IST 2010

LOGFILE FOR STARTING ORACLE

Trying to start PCP database ...

-

Thu Dec 23 11:18:03 IST 2010

checking required environment variables

ORACLE_HOME is >/oracle/PCP/102_64<

ORACLE_SID is >PCP<

-

Thu Dec 23 11:18:03 IST 2010

check initora

-

Thu Dec 23 11:18:03 IST 2010

check initora

-

Thu Dec 23 11:18:03 IST 2010

checking V2 connect

03

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

Used parameter files:

/oracle/PCP/102_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

VICE_NAME = PCP)))

OK (0 msec)

tnsping: V2 connect to PCP

-

Thu Dec 23 11:18:03 IST 2010

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

Thu Dec 23 11:18:03 IST 2010

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

Thu Dec 23 11:18:10 IST 2010

starting database

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Dec 23 11:18:10 2010

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 3204448256 bytes

Fixed Size 2056600 bytes

Variable Size 1645645416 bytes

Database Buffers 1542029312 bytes

Redo Buffers 14716928 bytes

Database mounted.

Database opened.

bit Production

With the Partitioning, Data Mining and Real Application Testing options

-

Thu Dec 23 11:18:16 IST 2010

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

      • ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/PCP/SYS/exe/run/startdb: Terminating with error code 12

Former Member
‎12-23-2010 5:47 AM
0 Kudos

Please check the below trans.log

PCBL_TES:pcpadm 23> more trans.log

a59y0C4 ETW000 R3trans version 6.13 (release 640 - 17.02.10 - 13:07:00).

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

4 ETW000

4 ETW000 date&time : 23.12.2010 - 10:18:32

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

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

4 ETW000 [dev trc ,00000] Thu Dec 23 10:18:32 2010

245 0.000245

4 ETW000 [dev trc ,00000] db_con_init called

40 0.000285

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

228 0.000513

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PCP/SYS/exe/run/dbo

raslib.so' ...

4 ETW000

28 0.000541

4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/PCP/SYS/ex

e/run/dboraslib.so"), hdl 0

4 ETW000

36553 0.037094

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

loaded

4 ETW000

23 0.037117

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sa

p/PCP/SYS/exe/run/dboraslib.so

4 ETW000

43 0.037160

4 ETW000 [dev trc ,00000] Version of '/usr/sap/PCP/SYS/exe/run/dboraslib.s

o' is "640.00", patchlevel (0.335)

4 ETW000

193 0.037353

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/s

ap/PCP/SYS/exe/run/dboraslib.so

4 ETW000

23 0.037376

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/

sap/PCP/SYS/exe/run/dboraslib.so

4 ETW000

65 0.037441

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

28 0.037469

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DI

SCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_

max = 255, con_opt = 255, occ = NO

4 ETW000

29 0.037498

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

75 0.037573

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

for reuse:

4 ETW000

16 0.037589

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DIS

CONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_

max = 255, con_opt = 255, occ = NO

a59y0CdBtrans.log (29%)d@

a59y0CdBtrans.log (30%)d@a59y0Ca59y0C

26 0.037615

a59y0CdBtrans.log (31%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Got ORACLE_

HOME=/oracle/PCP/102_64 from environma59y0CdBtrans.log (31%)d@a59y0Ca59y0Cent

a59y0CdBtrans.log (32%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (32%)d@a59y0Ca59y0C 2

49 0.037864

a59y0CdBtrans.log (32%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] -->oci_init

ialize (con_hdl=0) a59y0CdBtrans.log (33%)d@a59y0Ca59y0C

43 0.037907

a59y0CdBtrans.log (33%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] got NLS_LAN

G='AMERICAN_AMERICA.WE8DEC' from envia59y0CdBtrans.log (34%)d@a59y0Ca59y0Cronmen

t

a59y0CdBtrans.log (34%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (35%)d@a59y0Ca59y0C

18 0.037925

a59y0CdBtrans.log (35%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Client NLS

settings: AMERICAN_AMERICA.US7ASCII a59y0CdBtrans.log (36%)d@a59y0Ca59y0C 24

99 0.040424

a59y0CdBtrans.log (36%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Logon as OP

S$-user to get SAPPCP's password a59y0CdBtrans.log (37%)d@a59y0Ca59y0C

41 0.040465

a59y0CdBtrans.log (37%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Connecting

as /@PCP on connection 0 (nls_hdl 0) a59y0CdBtrans.log (38%)d@a59y0Ca59y0C... (d

bsl 640 210610)

a59y0CdBtrans.log (38%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (39%)d@a59y0Ca59y0C

24 0.040489

a59y0CdBtrans.log (39%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Nls Charact

erSet NationalCharSeta59y0CdBtrans.log (40%)d@a59y0Ca59y0C

C EnvHp ErrHp ErrHpBatch

a59y0CdBtrans.log (40%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (41%)d@a59y0Ca59y0C

26 0.040515

a59y0CdBtrans.log (42%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] 0 US7ASCI

I a59y0CdBtrans.log (42%)d@a59y0Ca59y0C

1 6000000000cb2960 6000000000cba1b0 6000000000cb9b48

a59y0CdBtrans.log (43%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (43%)d@a59y0Ca59y0C

19 0.040534

a59y0CdBtrans.log (44%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Allocating

service context handle for con_hdl=0 a59y0CdBtrans.log (44%)d@a59y0Ca59y0C

55 0.040589

a59y0CdBtrans.log (45%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Allocating

server context handle a59y0CdBtrans.log (45%)d@a59y0Ca59y0C

20 0.040609

a59y0CdBtrans.log (46%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Attaching t

o DB Server PCP (con_hdl=0,svchp=6000a59y0CdBtrans.log (46%)d@a59y0Ca59y0C000000

cb9a78,srvhp=6000000000cba888)

a59y0CdBtrans.log (47%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (47%)d@a59y0Ca59y0C

23 0.040632

a59y0CdBtrans.log (48%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Assigning s

erver context 6000000000cba888 to sera59y0CdBtrans.log (48%)d@a59y0Ca59y0Cvice c

ontext 6000000000cb9a78

a59y0CdBtrans.log (49%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (50%)d@a59y0Ca59y0C 519

26 0.092558

a59y0CdBtrans.log (50%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Allocating

user session handle a59y0CdBtrans.log (51%)d@

84 0.092642

a59y0CdBtrans.log (51%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Starting us

er session (con_hdl=0,svchp=600000000a59y0CdBtrans.log (52%)d@a59y0Ca59y0C0cb9a7

8,srvhp=6000000000cba888,usrhp=6000000000cc4ae8)

a59y0CdBtrans.log (52%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (53%)d@a59y0Ca59y0C

25 0.092667

a59y0CdBtrans.log (54%)d@a59y0Ca59y0C4 ETW000 [dboci.c ,00000] *** ERROR =

> OCI-call 'OCISessionBegin' failed: a59y0CdBtrans.log (54%)d@a59y0Ca59y0Crc = 1

2705

a59y0CdBtrans.log (55%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (55%)d@a59y0Ca59y0C 26

29 0.095296

a59y0CdBtrans.log (56%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] server_deta

ch(con_hdl=0,stale=1,svrhp=6000000000a59y0CdBtrans.log (56%)d@a59y0Ca59y0Ccba888

)

a59y0CdBtrans.log (57%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (57%)d@a59y0Ca59y0C

18 0.095314

a59y0CdBtrans.log (58%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Detaching f

rom DB Server (con_hdl=0,svchp=600000a59y0CdBtrans.log (58%)d@a59y0Ca59y0C0000cb

9a78,srvhp=6000000000cba888)

a59y0CdBtrans.log (58%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (59%)d@a59y0Ca59y0C

19 0.095333

a59y0CdBtrans.log (60%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Deallocatin

g server context handle 6000000000cbaa59y0CdBtrans.log (60%)d@a59y0Ca59y0C888

a59y0CdBtrans.log (61%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (61%)d@a59y0Ca59y0C 3

87 0.095720

a59y0CdBtrans.log (61%)d@a59y0Ca59y0C4 ETW000 [dbsloci. ,00000] *** ERROR =

> CONNECT failed with sql error 12705a59y0CdBtrans.log (62%)d@a59y0Ca59y0C.

a59y0CdBtrans.log (62%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (62%)d@a59y0Ca59y0C

76 0.095796

a59y0CdBtrans.log (63%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] set_ocic

a() -> OCI or SQL return code 12705 a59y0CdBtrans.log (63%)d@a59y0Ca59y0C

12 0.095808

a59y0CdBtrans.log (64%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Try to conn

ect with default password a59y0CdBtrans.log (64%)d@a59y0Ca59y0C

14 0.095822

a59y0CdBtrans.log (65%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Connecting

as SAPPCP/<pwd>@PCP on connection 0 (a59y0CdBtrans.log (65%)d@a59y0Ca59y0Cnls_hd

l 0) ... (dbsl 640 210610)

a59y0CdBtrans.log (66%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (67%)d@a59y0Ca59y0C

28 0.095850

a59y0CdBtrans.log (67%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Nls Charact

erSet NationalCharSeta59y0CdBtrans.log (68%)d@a59y0Ca59y0C

C EnvHp ErrHp ErrHpBatch

a59y0CdBtrans.log (68%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (69%)d@a59y0Ca59y0C

19 0.095869

a59y0CdBtrans.log (70%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] 0 US7ASCI

I a59y0CdBtrans.log (70%)d@a59y0Ca59y0C

1 6000000000cb2960 6000000000cba1b0 6000000000cb9b48

a59y0CdBtrans.log (71%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (71%)d@a59y0Ca59y0C

20 0.095889

a59y0CdBtrans.log (72%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Allocating

server context handle a59y0CdBtrans.log (72%)d@a59y0Ca59y0C

12 0.095901

a59y0CdBtrans.log (73%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Attaching t

o DB Server PCP (con_hdl=0,svchp=6000a59y0CdBtrans.log (73%)d@a59y0Ca59y0C000000

cb9a78,srvhp=6000000000cba888)

a59y0CdBtrans.log (74%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (75%)d@a59y0Ca59y0C

27 0.095928

a59y0CdBtrans.log (75%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Assigning s

erver context 6000000000cba888 to sera59y0CdBtrans.log (76%)d@a59y0Ca59y0Cvice c

ontext 6000000000cb9a78

a59y0CdBtrans.log (76%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (77%)d@a59y0Ca59y0C 443

49 0.140277

a59y0CdBtrans.log (77%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Assigning u

sername to user session 6000000000cc4a59y0CdBtrans.log (78%)d@a59y0Ca59y0Cae8

a59y0CdBtrans.log (78%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (78%)d@a59y0Ca59y0C

17 0.140294

a59y0CdBtrans.log (79%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Assigning p

assword to user session 6000000000cc4a59y0CdBtrans.log (79%)d@a59y0Ca59y0Cae8

a59y0CdBtrans.log (80%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (80%)d@a59y0Ca59y0C

66 0.140360

a59y0CdBtrans.log (81%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Starting us

er session (con_hdl=0,svchp=600000000a59y0CdBtrans.log (81%)d@a59y0Ca59y0C0cb9a7

8,srvhp=6000000000cba888,usrhp=6000000000cc4ae8)

a59y0CdBtrans.log (82%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (83%)d@a59y0Ca59y0C

53 0.140413

a59y0CdBtrans.log (83%)d@a59y0Ca59y0C4 ETW000 [dboci.c ,00000] *** ERROR =

> OCI-call 'OCISessionBegin' failed: a59y0CdBtrans.log (84%)d@a59y0Ca59y0Crc = 1

2705

a59y0CdBtrans.log (84%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (85%)d@a59y0Ca59y0C 34

36 0.143849

a59y0CdBtrans.log (85%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] server_deta

ch(con_hdl=0,stale=1,svrhp=6000000000a59y0CdBtrans.log (86%)d@a59y0Ca59y0Ccba888

)

a59y0CdBtrans.log (86%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (86%)d@a59y0Ca59y0C

17 0.143866

a59y0CdBtrans.log (87%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Detaching f

rom DB Server (con_hdl=0,svchp=600000a59y0CdBtrans.log (87%)d@a59y0Ca59y0C0000cb

9a78,srvhp=6000000000cba888)

a59y0CdBtrans.log (88%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (89%)d@a59y0Ca59y0C

18 0.143884

a59y0CdBtrans.log (89%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Deallocatin

g server context handle 6000000000cbaa59y0CdBtrans.log (90%)d@a59y0Ca59y0C888

a59y0CdBtrans.log (90%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (90%)d@a59y0Ca59y0C 1

24 0.144008

a59y0CdBtrans.log (91%)d@a59y0Ca59y0C4 ETW000 [dbsloci. ,00000] *** ERROR =

> CONNECT failed with sql error 12705a59y0CdBtrans.log (91%)d@a59y0Ca59y0C.

a59y0CdBtrans.log (92%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (92%)d@a59y0Ca59y0C

19 0.144027

a59y0CdBtrans.log (93%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] set_ocic

a() -> OCI or SQL return code 12705 a59y0CdBtrans.log (93%)d@a59y0Ca59y0C

12 0.144039

a59y0CdBtrans.log (94%)d@a59y0Ca59y0C4 ETW000 [dblink ,00430] ***LOG BY2=

>sql error 12705 performing CON [dbla59y0CdBtrans.log (94%)d@a59y0Ca59y0Cink#6

@ 430]

a59y0CdBtrans.log (95%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (95%)d@a59y0Ca59y0C 2

73 0.144312

a59y0CdBtrans.log (96%)d@a59y0Ca59y0C4 ETW000 [dblink ,00430] ***LOG BY0=

>ORA-12705: Cannot access NLS data fia59y0CdBtrans.log (96%)d@a59y0Ca59y0Cles or

invalid environment specified [dblink#6 @ 430]

a59y0CdBtrans.log (97%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (98%)d@a59y0Ca59y0C

19 0.144331

a59y0CdBtrans.log (98%)d@a59y0Ca59y0C2EETW169 no connect possible: "DBMS = ORACL

E --- dbs_oa59y0CdBtrans.log (98%)d@a59y0Ca59y0Cra_tns

name = 'PCP'"

a59y0CdBtrans.log: ENDd@a59y0Ca59y0Cd@PCBL_TES:pcpadm 24>

Please suggest

Former Member
‎12-23-2010 5:48 AM
0 Kudos

env of sidadm

PCBL_TES:pcpadm 24> env

HOME=/home/pcpadm

PATH=/oracle/PCP/102_64/bin:.:/home/pcpadm:/usr/sap/PCP/SYS/exe/run:/usr/bin:/us

r/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/hparray/bin:/o

pt/nettladm/bin:/opt/fcms/bin:/usr/contrib/kwdb/bin:/usr/bin/X11:/opt/graphics/c

ommon/bin:/opt/upgrade/bin:/opt/ipf/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/resmon

/bin:/opt/hpsmh/bin:/opt/gwlm/bin:/opt/gvsd/bin:/opt/sas/bin:/opt/sec_mgmt/basti

lle/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/opt/gnome/bin:/opt/ignite/bin

:/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/b

in:/opt/swa/bin:/opt/thunderbird:/opt/drd/bin:/opt/sfm/bin:/usr/contrib/bin/X11:

/opt/perf/bin

LOGNAME=pcpadm

SHELL=/bin/csh

TERM=hp

COLUMNS=80

LINES=60

MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/u

sr/local/man/%L:/usr/local/man:/opt/graphics/common/man:/opt/ignite/share/man/%L

:/opt/ignite/share/man:/opt/ldapux/share/man:/opt/ldapux/ypldapd/man:/opt/ipf/ma

n:/opt/cifsclient/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/wbem/sh

are/man:/opt/amgr/man:/opt/amgr/man/%L:/usr/dt/share/man:/opt/samba/man:/opt/sam

ba/WTEC_Support_Tools/man:/opt/resmon/share/man/%L:/opt/resmon/share/man:/opt/gw

lm/man/%L:/opt/gwlm/man:/opt/sec_mgmt/share/man:/opt/dsau/man:/opt/gnome/man:/op

t/VRTS/man:/opt/perl_32/man:/opt/perl_64/man:/opt/swa/share/man/%L:/opt/swa/shar

e/man:/opt/ssh/share/man:/opt/drd/share/man/%L:/opt/drd/share/man:/opt/sfmdb/pgs

ql/man:/opt/sfm/share/man:/opt/perf/man/%L:/opt/perf/man

TZ=IST-5:30

SAPSYSTEMNAME=PCP

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

SHLIB_PATH=/oracle/PCP/102_64:/oracle/PCP/102_64:/usr/sap/PCP/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=PCP

dbs_ora_schema=SAPPCP

ORACLE_PSRV=PCP

ORACLE_SID=PCP

DB_SID=PCP

ORACLE_HOME=/oracle/PCP/102_64

ORACLE_BASE=/oracle

ORA_NLS10=/oracle/PCP/102_64/nls/data

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/PCP

PCBL_TES:pcpadm 25>

Former Member
‎12-23-2010 5:49 AM
0 Kudos

env of orasid

HOME=/oracle/PCP

PATH=/oracle/PCP/102_64/bin:.:/oracle/PCP:/usr/sap/PCP/SYS/exe/run:/usr/bin:/usr

/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/hparray/bin:/op

t/nettladm/bin:/opt/fcms/bin:/usr/contrib/kwdb/bin:/usr/bin/X11:/opt/graphics/co

mmon/bin:/opt/upgrade/bin:/opt/ipf/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/resmon/

bin:/opt/hpsmh/bin:/opt/gwlm/bin:/opt/gvsd/bin:/opt/sas/bin:/opt/sec_mgmt/bastil

le/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/opt/gnome/bin:/opt/ignite/bin:

/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bi

n:/opt/swa/bin:/opt/thunderbird:/opt/drd/bin:/opt/sfm/bin:/usr/contrib/bin/X11:/

opt/perf/bin

LOGNAME=orapcp

SHELL=/bin/csh

TERM=ansi

COLUMNS=80

LINES=60

MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/u

sr/local/man/%L:/usr/local/man:/opt/graphics/common/man:/opt/ignite/share/man/%L

:/opt/ignite/share/man:/opt/ldapux/share/man:/opt/ldapux/ypldapd/man:/opt/ipf/ma

n:/opt/cifsclient/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/wbem/sh

are/man:/opt/amgr/man:/opt/amgr/man/%L:/usr/dt/share/man:/opt/samba/man:/opt/sam

ba/WTEC_Support_Tools/man:/opt/resmon/share/man/%L:/opt/resmon/share/man:/opt/gw

lm/man/%L:/opt/gwlm/man:/opt/sec_mgmt/share/man:/opt/dsau/man:/opt/gnome/man:/op

t/VRTS/man:/opt/perl_32/man:/opt/perl_64/man:/opt/swa/share/man/%L:/opt/swa/shar

e/man:/opt/ssh/share/man:/opt/drd/share/man/%L:/opt/drd/share/man:/opt/sfmdb/pgs

ql/man:/opt/sfm/share/man:/opt/perf/man/%L:/opt/perf/man

TZ=IST-5:30

SAPSYSTEMNAME=PCP

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

SHLIB_PATH=/oracle/PCP/102_64:/oracle/PCP/102_64:/usr/sap/PCP/SYS/exe/run

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=PCP

dbs_ora_schema=SAPPCP

ORACLE_PSRV=PCP

ORACLE_SID=PCP

DB_SID=PCP

ORACLE_HOME=/oracle/PCP/102_64

ORACLE_BASE=/oracle

ORA_NLS10=/oracle/PCP/102_64/nls/data

NLS_LANG=AMERICAN_AMERICA.WE8DEC

SAPDATA_HOME=/oracle/PCP

PCBL_TES:orapcp 3>

all env's looks correct but why its happen

Former Member
‎12-23-2010 5:52 AM
0 Kudos

but when i am trying to start through sqlplus

db is starting

SQL> startup

ORACLE instance started.

Total System Global Area 3204448256 bytes

Fixed Size 2056600 bytes

Variable Size 1645645416 bytes

Database Buffers 1542029312 bytes

Redo Buffers 14716928 bytes

Database mounted.

Database opened.

Please suggest

regards,

Amar

Former Member
‎12-23-2010 6:00 AM
0 Kudos

Hi,

Execute R3trans -d and then post the contents of trans.log

Regards,

SBK

Former Member
‎12-23-2010 6:12 AM
0 Kudos

a59y0C4 ETW000 R3trans version 6.13 (release 640 - 17.02.10 - 13:07:00).

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

4 ETW000

4 ETW000 date&time : 23.12.2010 - 11:44:59

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] Thu Dec 23 11:44:59 2010

235 0.000235

4 ETW000 [dev trc ,00000] db_con_init called

39 0.000274

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

209 0.000483

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PCP/SYS/exe/run/db

raslib.so' ...

4 ETW000

28 0.000511

4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/PCP/SYS/e

e/run/dboraslib.so"), hdl 0

4 ETW000

25963 0.026474

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

loaded

4 ETW000

19 0.026493

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/s

p/PCP/SYS/exe/run/dboraslib.so

4 ETW000

39 0.026532

4 ETW000 [dev trc ,00000] Version of '/usr/sap/PCP/SYS/exe/run/dboraslib.

o' is "640.00", patchlevel (0.335)

4 ETW000

184 0.026716

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/

ap/PCP/SYS/exe/run/dboraslib.so

4 ETW000

22 0.026738

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr

sap/PCP/SYS/exe/run/dboraslib.so

4 ETW000

63 0.026801

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

27 0.026828

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = D

SCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con

max = 255, con_opt = 255, occ = NO

4 ETW000

29 0.026857

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

63 0.026920

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

for reuse:

4 ETW000

16 0.026936

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DI

CONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con

max = 255, con_opt = 255, occ = NO

a59y0CdBtrans.log (29%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (30%)d@a59y0Ca59y0C

27 0.026963

a59y0CdBtrans.log (31%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Got ORACLE_

HOME=/oracle/PCP/102_64 from environma59y0CdBtrans.log (31%)d@a59y0Ca59y0Cent

a59y0CdBtrans.log (32%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (32%)d@a59y0Ca59y0C 2

24 0.027187

a59y0CdBtrans.log (32%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] -->oci_init

ialize (con_hdl=0) a59y0CdBtrans.log (33%)d@a59y0Ca59y0C

46 0.027233

a59y0CdBtrans.log (33%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] got NLS_LAN

G='AMERICAN_AMERICA.WE8DEC' from envia59y0CdBtrans.log (34%)d@a59y0Ca59y0Cronmen

t

a59y0CdBtrans.log (34%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (35%)d@a59y0Ca59y0C

17 0.027250

a59y0CdBtrans.log (35%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Client NLS

settings: AMERICAN_AMERICA.US7ASCII a59y0CdBtrans.log (36%)d@a59y0Ca59y0C 24

77 0.029727

a59y0CdBtrans.log (36%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Logon as OP

S$-user to get SAPPCP's password a59y0CdBtrans.log (37%)d@a59y0Ca59y0C

44 0.029771

a59y0CdBtrans.log (37%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Connecting

as /@PCP on connection 0 (nls_hdl 0) a59y0CdBtrans.log (38%)d@a59y0Ca59y0C... (d

bsl 640 210610)

a59y0CdBtrans.log (38%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (39%)d@a59y0Ca59y0C

25 0.029796

a59y0CdBtrans.log (39%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Nls Charact

erSet NationalCharSeta59y0CdBtrans.log (40%)d@a59y0Ca59y0C

C EnvHp ErrHp ErrHpBatch

a59y0CdBtrans.log (40%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (41%)d@a59y0Ca59y0C

27 0.029823

a59y0CdBtrans.log (42%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] 0 US7ASCI

I a59y0CdBtrans.log (42%)d@a59y0Ca59y0C

1 6000000000cb2960 6000000000cba1b0 6000000000cb9b48

a59y0CdBtrans.log (43%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (43%)d@a59y0Ca59y0C

20 0.029843

a59y0CdBtrans.log (44%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Allocating

service context handle for con_hdl=0 a59y0CdBtrans.log (44%)d@a59y0Ca59y0C

55 0.029898

a59y0CdBtrans.log (45%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Allocating

server context handle a59y0CdBtrans.log (45%)d@a59y0Ca59y0C

20 0.029918

a59y0CdBtrans.log (46%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Attaching t

o DB Server PCP (con_hdl=0,svchp=6000a59y0CdBtrans.log (46%)d@a59y0Ca59y0C000000

cb9a78,srvhp=6000000000cba888)

a59y0CdBtrans.log (47%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (47%)d@a59y0Ca59y0C

22 0.029940

a59y0CdBtrans.log (48%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Assigning s

erver context 6000000000cba888 to sera59y0CdBtrans.log (48%)d@a59y0Ca59y0Cvice c

ontext 6000000000cb9a78

a59y0CdBtrans.log (49%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (50%)d@a59y0Ca59y0C 505

54 0.080494

a59y0CdBtrans.log (50%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Allocating

user session handle a59y0CdBtrans.log (51%)d@a59y0Ca59y0C

73 0.080567

a59y0CdBtrans.log (51%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Starting us

er session (con_hdl=0,svchp=600000000a59y0CdBtrans.log (52%)d@a59y0Ca59y0C0cb9a7

8,srvhp=6000000000cba888,usrhp=6000000000cc4ae8)

a59y0CdBtrans.log (52%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (53%)d@a59y0Ca59y0C

21 0.080588

a59y0CdBtrans.log (54%)d@a59y0Ca59y0C4 ETW000 [dboci.c ,00000] *** ERROR =

> OCI-call 'OCISessionBegin' failed: a59y0CdBtrans.log (54%)d@a59y0Ca59y0Crc = 1

2705

a59y0CdBtrans.log (55%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (55%)d@a59y0Ca59y0C 24

61 0.083049

a59y0CdBtrans.log (56%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] server_deta

ch(con_hdl=0,stale=1,svrhp=6000000000a59y0CdBtrans.log (56%)d@a59y0Ca59y0Ccba888

)

a59y0CdBtrans.log (57%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (57%)d@a59y0Ca59y0C

18 0.083067

a59y0CdBtrans.log (58%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Detaching f

rom DB Server (con_hdl=0,svchp=600000a59y0CdBtrans.log (58%)d@a59y0Ca59y0C0000cb

9a78,srvhp=6000000000cba888)

a59y0CdBtrans.log (58%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (59%)d@a59y0Ca59y0C

18 0.083085

a59y0CdBtrans.log (60%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Deallocatin

g server context handle 6000000000cbaa59y0CdBtrans.log (60%)d@a59y0Ca59y0C888

a59y0CdBtrans.log (61%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (61%)d@a59y0Ca59y0C 3

30 0.083415

a59y0CdBtrans.log (61%)d@a59y0Ca59y0C4 ETW000 [dbsloci. ,00000] *** ERROR =

> CONNECT failed with sql error 12705a59y0CdBtrans.log (62%)d@a59y0Ca59y0C.

a59y0CdBtrans.log (62%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (62%)d@a59y0Ca59y0C

70 0.083485

a59y0CdBtrans.log (63%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] set_ocic

a() -> OCI or SQL return code 12705 a59y0CdBtrans.log (63%)d@a59y0Ca59y0C

12 0.083497

a59y0CdBtrans.log (64%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Try to conn

ect with default password a59y0CdBtrans.log (64%)d@a59y0Ca59y0C

13 0.083510

a59y0CdBtrans.log (65%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Connecting

as SAPPCP/<pwd>@PCP on connection 0 (a59y0CdBtrans.log (65%)d@a59y0Ca59y0Cnls_hd

l 0) ... (dbsl 640 210610)

a59y0CdBtrans.log (66%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (67%)d@a59y0Ca59y0C

27 0.083537

a59y0CdBtrans.log (67%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Nls Charact

erSet NationalCharSeta59y0CdBtrans.log (68%)d@a59y0Ca59y0C

C EnvHp ErrHp ErrHpBatch

a59y0CdBtrans.log (68%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (69%)d@a59y0Ca59y0C

19 0.083556

a59y0CdBtrans.log (70%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] 0 US7ASCI

I a59y0CdBtrans.log (70%)d@a59y0Ca59y0C

1 6000000000cb2960 6000000000cba1b0 6000000000cb9b48

a59y0CdBtrans.log (71%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (71%)d@a59y0Ca59y0C

19 0.083575

a59y0CdBtrans.log (72%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Allocating

server context handle a59y0CdBtrans.log (72%)d@a59y0Ca59y0C

12 0.083587

a59y0CdBtrans.log (73%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Attaching t

o DB Server PCP (con_hdl=0,svchp=6000a59y0CdBtrans.log (73%)d@a59y0Ca59y0C000000

cb9a78,srvhp=6000000000cba888)

a59y0CdBtrans.log (74%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (75%)d@a59y0Ca59y0C

21 0.083608

a59y0CdBtrans.log (75%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Assigning s

erver context 6000000000cba888 to sera59y0CdBtrans.log (76%)d@a59y0Ca59y0Cvice c

ontext 6000000000cb9a78

a59y0CdBtrans.log (76%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (77%)d@a59y0Ca59y0C 442

41 0.127849

a59y0CdBtrans.log (77%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Assigning u

sername to user session 6000000000cc4a59y0CdBtrans.log (78%)d@a59y0Ca59y0Cae8

a59y0CdBtrans.log (78%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (78%)d@a59y0Ca59y0C

17 0.127866

a59y0CdBtrans.log (79%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Assigning p

assword to user session 6000000000cc4a59y0CdBtrans.log (79%)d@a59y0Ca59y0Cae8

a59y0CdBtrans.log (80%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (80%)d@a59y0Ca59y0C

67 0.127933

a59y0CdBtrans.log (81%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Starting us

er session (con_hdl=0,svchp=600000000a59y0CdBtrans.log (81%)d@a59y0Ca59y0C0cb9a7

8,srvhp=6000000000cba888,usrhp=6000000000cc4ae8)

a59y0CdBtrans.log (82%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (83%)d@a59y0Ca59y0C

59 0.127992

a59y0CdBtrans.log (83%)d@a59y0Ca59y0C4 ETW000 [dboci.c ,00000] *** ERROR =

> OCI-call 'OCISessionBegin' failed: a59y0CdBtrans.log (84%)d@a59y0Ca59y0Crc = 1

2705

a59y0CdBtrans.log (84%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (85%)d@a59y0Ca59y0C 37

60 0.131752

a59y0CdBtrans.log (85%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] server_deta

ch(con_hdl=0,stale=1,svrhp=6000000000a59y0CdBtrans.log (86%)d@a59y0Ca59y0Ccba888

)

a59y0CdBtrans.log (86%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (86%)d@a59y0Ca59y0C

18 0.131770

a59y0CdBtrans.log (87%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Detaching f

rom DB Server (con_hdl=0,svchp=600000a59y0CdBtrans.log (87%)d@a59y0Ca59y0C0000cb

9a78,srvhp=6000000000cba888)

a59y0CdBtrans.log (88%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (89%)d@a59y0Ca59y0C

17 0.131787

a59y0CdBtrans.log (89%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] Deallocatin

g server context handle 6000000000cbaa59y0CdBtrans.log (90%)d@a59y0Ca59y0C888

a59y0CdBtrans.log (90%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (90%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (90%)d@a59y0Ca59y0C

92 0.131879

a59y0CdBtrans.log (91%)d@a59y0Ca59y0C4 ETW000 [dbsloci. ,00000] *** ERROR =

> CONNECT failed with sql error 12705a59y0CdBtrans.log (91%)d@a59y0Ca59y0C.

a59y0CdBtrans.log (92%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (92%)d@a59y0Ca59y0C

20 0.131899

a59y0CdBtrans.log (93%)d@a59y0Ca59y0C4 ETW000 [dev trc ,00000] set_ocic

a() -> OCI or SQL return code 12705 a59y0CdBtrans.log (93%)d@a59y0Ca59y0C

12 0.131911

a59y0CdBtrans.log (94%)d@a59y0Ca59y0C4 ETW000 [dblink ,00430] ***LOG BY2=

>sql error 12705 performing CON [dbla59y0CdBtrans.log (94%)d@a59y0Ca59y0Cink#6

@ 430]

a59y0CdBtrans.log (95%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (95%)d@a59y0Ca59y0C 2

59 0.132170

a59y0CdBtrans.log (96%)d@a59y0Ca59y0C4 ETW000 [dblink ,00430] ***LOG BY0=

>ORA-12705: Cannot access NLS data fia59y0CdBtrans.log (96%)d@a59y0Ca59y0Cles or

invalid environment specified [dblink#6 @ 430]

a59y0CdBtrans.log (97%)d@a59y0Ca59y0C4 ETW000

a59y0CdBtrans.log (98%)d@a59y0Ca59y0C

19 0.132189

a59y0CdBtrans.log (98%)d@a59y0Ca59y0C2EETW169 no connect possible: "DBMS = ORACL

E --- dbs_oa59y0CdBtrans.log (98%)d@a59y0Ca59y0Cra_tns

name = 'PCP'"

a59y0CdBtrans.log: ENDd@a59y0Ca59y0Cd@PCBL_TES:pcpadm 27>

Regards,

Amar

Former Member
‎12-23-2010 6:32 AM
0 Kudos

Hi,

LOG BY0= >ORA-12705: Cannot access NLS data fia59y0CdBtrans.log (96%)d@a59y0Ca59y0Cles or invalid environment specified [dblink#6 @ 430] a59y0CdBtrans.log (97%)d@a59y0Ca59y0C4 ETW000 a59y0CdBtrans.log

I understand that you have upgraded the database. Did you set ORA_NLS33 environment variable? if not set then set it

ORA_NLS33=/oracle/client/<oracle_version>/ocommon/nls/admin/data.

Regards,

SBK

Former Member
‎12-23-2010 6:39 AM
0 Kudos

But for 10g its strongly specified that should not use ORA_NLS33

we should use

ORA_NLS10=/oracle/PCP/102_64/nls/data

**1.**

**Make sure the following environment variables are not set:;ã|uóa TWO_TASK;ã|uóa ORA_NLS;ã|uóa ORA_NLS32;ã|uóa ORA_NLS33**

2.

Set the following environment variables:

Environment Variable

ValueDISPLAY

The setting of the DISPLAY environment variable is described in SAP Note 432861.

To make sure that the OUI screen can be displayed correctly on your system, you might have to start an X terminal (xterm) session and run the command:$ xhost +

3.

Set the corresponding environment variable for the library path:

Operating System

Environment Variable

Value

AIXLIBPATH$ORACLE_HOME/lib:$LIBPATH

Solaris, HP Tru64 UNIX, LinuxLD_LIBRARY_PATH$ORACLE_HOME/lib:$LD_LIBRARY_PATH

HP-UXSHLIB_PATH$ORACLE_HOME/lib:$SHLIB_PATH

This makes sure that dynamic libraries are loaded first from $ORACLE_HOME/lib.

4.

Include $ORACLE_HOME/bin in your PATH or path variable, where $ORACLE_HOME is the variable that you set in step 2 above.

NOTE

Make sure there is only one $ORACLE_HOME/bin in your PATH or path variable. Make sure that the path variable does not contain the old $ORACLE_HOME/bin.

5.

Check if the temporary directory (usually /tmp) has at least 400 MB of free space. If not, set up the TEMP or TMPDIR environment variables to specify a temporary directory on the filesystem.

RECOMMENDATION

You can check the correctness of the new environment with the UNIX env command. Or you can run the UNIX umask command and check that the returned value is 22.4.1.2Backing Up

Regards,

Amar

Former Member
‎12-23-2010 6:50 AM
0 Kudos

ORA_NSL33 is only for 9i but not for 10g .

so we should not set that na?

regards,

Amar

Former Member
‎12-23-2010 7:15 AM
0 Kudos

Forget about NSL33 - it is indeed not required for Oracle 10g.

Did you also update your kernel version and especially the DB dependent parts?

Did you update your listener?

Kind regards,

Former Member
‎12-23-2010 8:17 AM
0 Kudos

Hi,

Thanks for the reply

Yes i update the kernel to 640_ext2

with 700 brtools and i have done listener upgarde also .Please check above lsnrctl start

Regards,

Amar

Former Member
‎12-23-2010 10:15 AM
0 Kudos

Thank you all .

the problem is solved

ORA_NLS10 is not required to set manually.from oracle home its self it take

So i removed that env to both SIDADM and ORASID

then i updated /usr/sap/PCP/SYS/exe/run/dboraslib.so

then DB and SAP is up n running fineRegards,

Amar

Former Member
‎12-23-2010 10:17 AM
0 Kudos

Check out this Note 592657 - ORA-12701/ORA-12705/ORA-12709

Regards,

SBK

Former Member
‎12-22-2010 10:48 AM
0 Kudos

You sure that you have also completed the post DB upgrade activity?

Perform R3trans -d and check the trans.log file (same location where you execute R3trans)

Is you listener up?

Show replies
Show replies
Former Member
‎12-22-2010 10:53 AM
0 Kudos

thanks for the reply

listner is up and running

please check the R3trans error

PCBL_TES:pcpadm 1> R3trans -x

This is R3trans version 6.13 (release 640 - 17.02.10 - 13:07:00).

2EETW169 no connect possible: "environment variable dbms_type is not set."

R3trans finished (0012).

PCBL_TES:pcpadm 2>

But i can see this file in .env files

Former Member
‎12-22-2010 11:03 AM
0 Kudos

You are missing some of the environment variables for your user. Please consult the upgrade guide and correct the environment settings as described there.

Kind regards,

Former Member
‎12-22-2010 12:02 PM
0 Kudos

i have check the guide now all env are fine

but when i start R3trans -x

it shows the below error

ERROR => OCI-call 'OCISessionBegin' failed:trans.log (54%)rc =1 what to do now

is that a problem with dboraslib.so error?

Former Member
‎12-22-2010 12:09 PM
0 Kudos

Please paste the whole log.

Ask a Question