After ECC5 SYSTEM COPY,prdadm can not start oracle DB but oraprd could...

[Former Member]

Hi experts,+

I've met with some strange problems after I've finished the system copy for our PRD system (ECC5 + Oracle 9.2.0.1 + RHEL4 ).

After the copy process, I can't finish the command "startsap", which displayed the following error messages:

"Checking PRD Database

-

---

Running /usr/sap/PRD/SYS/exe/run/startdb

Trying to start PRD database ...

Log file: /home/prdadm/startdb.log

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

DB startup failedu201C

However, I change my account to oraprd and then manually start oracle with the following command:

"sqlplus /nolog

conn / as sysdba;

startup"

And then change back to prdadm, and rerun the command startsap, this time SAP is successfully started and tested by logon.

Could you please provide me with some advice about the error could be happened to my system?

Thanks in advance.

Derek

[Former Member · Accepted solution]

Hi,

ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034

Have a look at the [SAPNote 491174 - Composite SAP note for ORA-01034|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=491174] which deals with the very issue.

Also consider upgrading ur oracle version as 9.2.0.1.0 is not under maintenance and u may not get valid support for this version. If u r not in a position to upgrade the oracle vesrion to 10g or so, please update the oracle patch set 9.2.0.8.0 atleast.

Regards,

Varadharajan M

[Former Member · Accepted solution]

Hi Mark,Nick and Varadhu,

Thanks for your advice, but we are doing the testing of upgrade of our system. Due to the current version of our produciton is Oracle 9.2.0.1, in order to find every possible problems we will meet in the process of upgrade, thus we want one system as much the same as our PRD system.

Whatever thanks for your kindness.

Derek

[Former Member · Accepted solution]

Hi,

brconnect -u system/<password> -c -f chpass -o <SCHEMA_OWNER> -p "pass"

The default password of the schema owner is "sap" and not "pass". Try to execute the command as follows,

brconnect -u system/<password> -c -f chpass -o <SCHEMA_OWNER> -p "sap"

Also have a look at the section General checks in the [SAP Note 400241|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=400241] and take the necessary steps to recreate the OPS$ mechanism.

Hope this solves ur issue.

Regards,

Varadharajan M

[Former Member · Accepted solution]

Hi,

Still you can give it a try...

Run again "root.sh" as ROOT user.

May be something went wrong after installation...

You can run this script ANYTIME to correct permission problem...

or you can set the permissions manually as below:

1. chmod 6751 $ORACLE_HOME/bin/oracle

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi Rajesh,

According to your opinion of authorization issues. I run the following command:

1,chown oraprd:dba -R /oracle

2, chmod 777 -R /oracle

Above means I give full authorization for /oracle and it subdirectory. Because it's a test system I don't thinks it's a big deal.

And after this I could use prdadm to run startsap,which solved my problem. However, there is still some problem left, after I started sap using prdadm account. I use oraprd to manually connect into oracle db. It still shows the message:Connect to idle instance.

This is also the problem of OPS$ Problem?

Do I need to recreate the OPS$ users?

Derek

[Former Member · Accepted solution]

Hi,

Ensure that u have executed the following command and gone through general check in the SAP note 400241.

brconnect -u system/<password> -c -f chpass -o <SCHEMA_OWNER> -p "sap"

-Varadhu...

[Former Member · Accepted solution]

Hi,

Have you the instantclient loaded ??

Ihave had similar problems in the past on AIX where the environment points to the ORACLE_HOME lib directory but when changed to the path of the instantclient it worked....

Try it what you got to lose...

Mark

[Former Member · Accepted solution]

Hi,

Do I need to recreate the OPS$ users?

Yes !

To work SAP properly, OPS$ users must be created properly with required DBA roles (SAPDBA role).

Refer the note mentioned in previous post...

And after this I could use prdadm to run startsap,which solved my problem. 

Just clear my doubt, are you able to log into SAP from SAPGUI ?

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi Varadhu,

Thanks for your kindness, which help me a lot~

Now I've finished the change password of SAPPRD part, but when I doing general checks in Note:400241, I met with the following errors:

[root@fruits1 prdadm]# chmod 777 ORADBUSR.SQL

[root@fruits1 prdadm]# chown oraprd:dba ORADBUSR.SQL

[root@fruits1 prdadm]# su oraprd

fruits1:oraprd 1> sqlplus /NOLOG @oradbusr.sql SAPPRD UNIX SAP_SID x

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 7 19:46:45 2010

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

SP2-0310: unable to open file "oradbusr.sql"

SQL>

I don't know what's wrong with it, I download the SQL from NOTE 50088 and give it full authorization.

Look forward your help.

Derek

[Former Member · Accepted solution]

Hi Mark,

Yes, you are exactly right.

When I'm installing Oracle software, some error happened and based on the error information, I installed oracle 10 instantclient and successfully go on the installtion. But I don't know whether this has effect on my problems. Could you give me some detail information to check?

Thanks a lot.

Derek

[Former Member · Accepted solution]

Hi,

Change the user using the command su -ora<SID> and not su ora<SID>. If u use su ora<SID> the env will not be loaded.

Hope this helps and clarifies.

-Varadhu...

[Former Member · Accepted solution]

Hi,

I am assuming you have now put that in your environment .

Try logging off prdadm and logging back in run R3trans -x and see what happens...

Paste again trans.log

Also from earlier make sure oradbuser.sql is in the directory you are logging in sqlplus.

Mark

[Former Member · Accepted solution]

Dear Varadhu,

I'am sorry to find your suggestion didn't work.

[root@fruits1 ~]# su -oraprd

su: invalid option -- o

Try `su --help' for more information.

Derek

[Former Member · Accepted solution]

Dear,

It is su - ora<SID>. There shud be a space in between - and ora<SID>.

-Varadhu...

[Former Member · Accepted solution]

Hi Varadhu,

I could change to oraprd with"su - oraprd" but still the same error. I'am sure this file is under the sqlplus run directory. Do I need to start db before run "sqlplus /NOLOG @oradbusr.sql SCHEMAOWNER UNIX SAP_SID x"?

Need your help. Thanks ~~

Derek

[Former Member · Accepted solution]

Hi,

Have u tried to start SAP with the user prdadm after the password of the schema owner is changed ?

Can u try now and post us the log if u still face any issues ?

-Varadhu...

[volker_borowski2 · Accepted solution]

>

> Hi Mark,
>         Yes, you are exactly right.
>         When I'm installing Oracle software, some error happened and based on the error information, I installed oracle 10 instantclient and successfully go on the installtion. But I don't know whether this has effect on my problems. Could you give me some detail information to check?
> 
>         Thanks a lot.
> 
> Derek

Really ????

What error should that have been indicating from a version 9.2.0.1 software installation

to install a version 10 client to solve a problem with this exact version 9 ?

Since your source environment is already quite messy, the systemcopy tools might

no be able to work correctly. You should consider a binary image copy as a first run,

to get a sandbox which you can use to find documented proceedings to get your PRD

system into supported environment first.

After you cleaned that up, you can do a new copy using the supported way to simulate

your SAP upgrade with after the cleanup.

Volker

[Former Member · Accepted solution]

Hi Volker,

I met with the following errors:errors while loading shared library libclntsh.so.10.1' and then I install instantclient 10g....

It's my first time to do system copy and I know I've got messed up and wish to learn from all these issues. After this I hope next time would be smooth.Deeply thanks for all your help.

Derek.

[Former Member · Accepted solution]

Dear Everyone,

According to the current situation, I've decided to run system copy again from the beginning. I've learnt a lot from all your advice. Thanks ~~~

Derek

[volker_borowski2 · Accepted solution]

>

> Hi Volker,
>         I met with the following errors:errors while loading shared library libclntsh.so.10.1' and then I install instantclient 10g....
>  
> Derek.

OK, but this was not a message with the Oracle SW installation.

It was a sapinst message(?)

It must have been later then, when the brtools had been called the first time.

Brtools 7 where not intended to be used oracle 9, that has been make backward compatible later.

If it was a message during the load, it would have been R3load trying to load the lib and that would have

been wrong anyway if the target is 9.2.

Before you start over, check the exact SW in PRD.

Oracle (ST04), SAP Kernel (SM51) and SAP BASIS Patchlevel (SPAM).

Depending on this choose the correct media to do the copy

If you are on Oracel 9 and want to keep it this way, I think you should not

use the patch collection master CD. This one was intended to install with Oracle 10.

You should use the original installation master cd then.

It should use brtools 6.40 so you will have no deal with instantclient during the copy.

Depending on your current BASIS SP it might be neccessaary to patch the Kernel

Archives on the Kernel CD before the installation because the original CD might be too low.

One of your clips shows a dboraslib 6.40 pl 25 which is extremly low.

Volker

[Former Member]

Is your ORACLE_HOME mapped to correct path?

And just logout from all the sessions and relogin and try. After that try to connect to Sqlplus and use below command and let us know.

sqlplus>select username from dba_users;

Regards,

Nick Loy

[Former Member]

Hi Nick,

I already restarted several time and reinstall the oracle client using the following ways:(note:539922)

1. Log on as user <sapsid>adm. Check that the ORACLE_HOME environment

variable refers to the Oracle Home directory of the Oracle 9.2.0

database, and make sure that you have authorization for the directory

/oracle/client.

2. Mount the first RDBMS CD that contains the Oracle 9.2.0 server

software (mount point: <CD-Dir>).

3. Execute the following command:

a) On 32-bit platforms (Linux):

/<CD-Dir>/UNIX/<OS>/CROCLLNK -v -b 32

On 64-bit platforms:

/<CD-Dir>/UNIX/<OS>/CROCLLNK -v -b 64

The results of running sql statment:

SQL> conn / as sysdba;

Connected.

SQL> select username from dba_users;

USERNAME

-

---

SYS

SYSTEM

OUTLN

DBSNMP

OPS$ORAPRD

OPS$PRDADM

SAPPRD

7 rows selected.

However, the problem of user oraprd still remains.

Derek

[Former Member]

First try to restart the DB manually with orasid user.

If it started succesfully, then come back and switch to sidadm user and start SAP.

Let us know.

Regards,

NIck Loy

[Former Member]

Hi Nick and Varadhu,

Now I could use prdadm use tht command "startsap" and then the database and sap could successfully started.

However, there is still one problem. After I started sap using prdadm and then I switch to oraprd and run the following command:

[root@fruits1 ~]# su - oraprd

fruits1:oraprd 1> sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 7 20:48:56 2010

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

SQL> conn / as sysdba;

Connected to an idle instance.

SQL> exit

Disconnected

fruits1:oraprd 2> sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 7 20:49:46 2010

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

SQL> conn / as sysdba;

Connected to an idle instance.

SQL> exit

Disconnected

fruits1:oraprd 3> brtools

BR0651I BRTOOLS 7.00 (16)

BR0280I BRTOOLS time stamp: 2010-10-07 20.50.16

BR0656I Choice menu 1 - please make a selection

-

---

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

1

BR0280I BRTOOLS time stamp: 2010-10-07 20.50.20

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2010-10-07 20.50.20

BR0656I Choice menu 3 - please make a selection

-

---

Database instance management

1 = Start up database

2 - Shut down database

3 - Alter database instance

4 - Alter database parameters

5 - Recreate database

6 - Show instance status

7 - Show database parameters

8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

6

BR0280I BRTOOLS time stamp: 2010-10-07 20.50.23

BR0663I Your choice: '6'

BR0280I BRTOOLS time stamp: 2010-10-07 20.50.23

BR0657I Input menu 75 - please check/enter input values

-

---

BRSPACE options for showing database information

1 - BRSPACE profile (profile) ........ [initPRD.sap]

2 - Database user/password (user) .... [/]

3 ~ Database instance (instance) ..... []

4 # Database parameter (parameter) ... []

5 # Database tablespace (tablespace) . []

6 # Database file (file) ............. []

7 # Database owner (owner) ........... []

8 # Database table (table) ........... []

9 # Database index (index) ........... []

10 - Create log file (log) ............ [no]

11 - Confirmation mode (confirm) ...... [yes]

12 # Extended output (output) ......... [no]

13 - Scrolling line count (scroll) .... [20]

14 - Message language (language) ...... [E]

15 - BRSPACE command line (command) ... [-p initPRD.sap -s 20 -l E -f dbshow -c dbstate]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2010-10-07 20.50.26

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initPRD.sap -s 20 -l E -f dbshow -c dbstate'

BR0280I BRTOOLS time stamp: 2010-10-07 20.50.26

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2010-10-07 20.50.27

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR1001I BRSPACE 7.00 (16)

BR1002I Start of BRSPACE processing: seehdxeh.dbw 2010-10-07 20.50.27

BR0280I BRSPACE time stamp: 2010-10-07 20.50.27

BR1009I Name of database instance: PRD

BR1010I BRSPACE action ID: seehdxeh

BR1011I BRSPACE function ID: dbw

BR1012I BRSPACE function: dbshow

BR1036I Class of information to be shown: dbstate

BR0280I BRSPACE time stamp: 2010-10-07 20.50.27

BR0692I Display menu 256 # no input possible

-

---

Information about the status of database instance PRD

1 - Instance number (number) ........... 0

2 - Instance thread (thread) ........... 1

3 - Instance status (status) ........... STOPPED

4 - Instance start time (start) ........

5 - Oracle version (version) ........... 9.2.0.1.0 (SQLPLUS)

6 - Database creation time (create) ....

7 - Last resetlogs time (resetlogs) ....

8 - Archivelog mode (archmode) .........

9 - Archiver status (archiver) .........

10 - Current redolog sequence (redoseq) .

11 - Current redolog SCN (redoscn) ......

12 - Number of SAP connections (sapcon) .

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

The above shows that using oraprd,which indicates that PRD DB is stopped.

Could you tell me what's wrong with it?

Derek

[Former Member]

we want one system as much the same as our PRD system

If you are looking for the same settings/configs/data of PRO, why you had changed the file permissions of /oracle to 777?

This is not at all a recommended one to use full permissions of /oracle in an SAP system.

I suggest you to do not apply all solutions whatever you are recieving on the forum, first you have to find the root cause in your system then only apply the exact solution.

1) Start DB manually with orasid

2) Try to start SAP with sidadm

3) If you face any issue with connectivity, check the trans.log or dev_w0 by executing R3trans -dx

4) Find the root cause

5) Paste here

6) Understand the repoly and apply the proper solution

Before going to start above work, change all /oracle contents permissions to 755 user as orasid and group as dba.

Regards,

NIck Loy

[Former Member]

Hi Nick,

Thanks for your reminding. You taught me a lot and I know I've been pissed up by this problem. And I will take your advice and then try to find the further problem.

Thanks.~

Derek

[Former Member]

Yes,

As mentioned by Mark...Oracle 9i is out of support.

Upgrade your DB to Oracle 10g with latest patch (I preffer 10.2.0.4), Once you thru.

Regards,

Nick Loy

[Former Member]

ERROR => CONNECT failed with sql error '1034'

Refer SAP Note 400241 (Problems with OPS$ mech)

And SAP Note 50088 (Wintel)

Regards,

Nick Loy

[Former Member]

Hi experts,

Some further information added:

After I started oracle database and then I use prdadm to run the command "

sqlplus /nolog

conn / as sysdba" . However , the reply tells me that I connect to an idle instance, why didn't I connect to my PRD database?

Some error with my environment setting?

I'll appreciate for any advice.~~

Derek

[Former Member]

Log file: /home/prdadm/startdb.log

What is in this file?

[Former Member]

Hi,

have you changed SID in System copy process ?

There should be something wrong with the OPS$ authentication mechanism.

What is the output of "R3trans -d" as <sid>adm.

Post "trans.log"

Refer the below notes:

[Note 361641 - Creating OPS$ users on UNIX|https://service.sap.com/sap/support/notes/361641]

[Note 400241 - Problems with ops$ or sapr3 connect to Oracle|https://service.sap.com/sap/support/notes/400241]

[Note 403004 - Database connect using R3trans fails|https://service.sap.com/sap/support/notes/403004]

Also post the output of "env" command as both <sid>adm and ora<sid>

Regards.

Rajesh Narkhede

[Former Member]

Hi Joe,

Thanks for your reply, here is my startdb.log:

fruits1:prdadm 16> more startdb.log

-

---

Thu Oct 7 16:49:47 CST 2010

LOGFILE FOR STARTING ORACLE

Trying to start PRD database ...

-

---

Thu Oct 7 16:49:47 CST 2010

checking required environment variables

ORACLE_HOME is >/oracle/PRD/920_32<

ORACLE_SID is >PRD<

-

---

Thu Oct 7 16:49:47 CST 2010

check initora

-

---

Thu Oct 7 16:49:47 CST 2010

check initora

-

---

Thu Oct 7 16:49:47 CST 2010

checking V2 connect

TNS Ping Utility for Linux: Version 9.2.0.1.0 - Production on 07-OCT-2010 16:49:47

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

/oracle/PRD/920_32/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = fruit

s1) (PORT = 1527))) (CONNECT_DATA = (SID = PRD) (GLOBAL_NAME = PRD.WORLD)))

OK (0 msec)

tnsping: V2 connect to PRD

-

---

Thu Oct 7 16:49:47 CST 2010

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Thu Oct 7 16:49:47 CST 2010

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Thu Oct 7 16:49:47 CST 2010

starting database

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 7 16:49:47 2010

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1612256996 bytes

Fixed Size 452324 bytes

Variable Size 989855744 bytes

Database Buffers 620756992 bytes

Redo Buffers 1191936 bytes

Database mounted.

Database opened.

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0 - Production

-

---

Thu Oct 7 16:49:54 CST 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/PRD/SYS/exe/run/startdb: Terminating with error code 12

I couldn't find any useful messages ,could you help me?

Derek,

[Former Member]

Hi,

R3trans check finished with return code: 12
ERROR: Startup of database failed
Notify Database Administrator.
/usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 12

Log clearly indicated, there is problem with R3trans check...

Execute "R3trans -d" as PRDADM and post "trans.log" from current directory...

Other way to by-pass OPS$ mechanism is set SCHEMA USER password to default. i.e. "pass"

Use the below command as ORA<SID> user.

brconnect -u system/<password> -c -f chpass -o <SCHEMA_OWNER> -p "pass"

Then try SAP will start...

Regards.

Rajesh Narkhede

[Former Member]

Hi Rajesh ,

I didn't change SID in system copy.

After the failure startsap command of prdadm, I tried "R3trans -d", and the following text is in trans.log:

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

fruits1:prdadm 18> R3trans -d

This is R3trans version 6.09 (release 640 - 02.08.04 - 16:35:00).

unicode enabled version

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

R3trans finished (0012).

fruits1:prdadm 19> more trans.log

4 ETW000 R3trans version 6.09 (release 640 - 02.08.04 - 16:35:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 07.10.2010 - 16:55:34

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 Oct 7 16:55:34 2010 126 0.000126

4 ETW000 [dev trc ,00000] db_con_init called 18 0.000144

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

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

4 ETW000 37 0.000228

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

4 ETW000 6806 0.007034

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

4 ETW000 24 0.007058

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

4 ETW000 26 0.007084

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

4 ETW000 74 0.007158

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

4 ETW000 24 0.007182

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

4 ETW000 38 0.007220

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

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 29 0.007281

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

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

4 ETW000 22 0.007322

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

ax = 255, con_opt = 255, occ = NO

4 ETW000 26 0.007348

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/PRD/920_32 from environment

4 ETW000 325 0.007673

4 ETW000 [dev trc ,00000] -->oci_initialize 21 0.007694

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 1446 0.009140

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

4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 ... 16 0.009180

4 ETW000 [dev trc ,00000] Allocating service context handle 23 0.009203

4 ETW000 [dev trc ,00000] Allocating server context handle 20 0.009223

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x907931c,svrhp=0x907b48c)

4 ETW000 54 0.009277

4 ETW000 [dev trc ,00000] Assigning server context 0x907b48c to service context 0x907931c

4 ETW000 14051 0.023328

4 ETW000 [dev trc ,00000] Allocating user session handle 54 0.023382

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x907931c,srvhp=0x907b48c,usrhp=0x9083fe4)

4 ETW000 36 0.023418

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

4 ETW000 2001 0.025419

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

4 ETW000 41 0.025460

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x907931c,srvhp=0x907b48c)

4 ETW000 24 0.025484

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x907b48c 187 0.025671

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

4 ETW000 46 0.025717

4 ETW000 [dev trc ,00000] Try to connect with default password 104 0.025821

4 ETW000 [dev trc ,00000] Connecting as SAPPRD/<pwd>@PRD on connection 0 ...

4 ETW000 24 0.025845

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

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x907931c,svrhp=0x907b48c)

4 ETW000 29 0.025889

4 ETW000 [dev trc ,00000] Assigning server context 0x907b48c to service context 0x907931c

4 ETW000 10684 0.036573

4 ETW000 [dev trc ,00000] Assigning username to user session 0x9083fe4 20 0.036593

4 ETW000 [dev trc ,00000] Assigning password to user session 0x9083fe4 28 0.036621

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x907931c,srvhp=0x907b48c,usrhp=0x9083fe4)

4 ETW000 27 0.036648

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

4 ETW000 1472 0.038120

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

4 ETW000 24 0.038144

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x907931c,srvhp=0x907b48c)

4 ETW000 23 0.038167

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x907b48c 104 0.038271

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

4 ETW000 33 0.038304

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1034 performing CON [dblink#1 @ 419]

4 ETW000 182 0.038486

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01034: ORACLE not available 20 0.038506

4 ETW000 ORA-27121: unable to determine size of shared memory segment

4 ETW000 Linux Error: 13: Permission denied [dblink#1 @ 419]

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

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

Another strange thing: I could use prdadm to manually login into oracle in command line:

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

fruits1:prdadm 10> sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 7 16:57:21 2010

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

SQL> conn / as sysdba;

Connected.

SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME

-

---

-

---

HOST_NAME

-

---

VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE

-

---

-

---

-

---

--- -

---

-

---

LOG_SWITCH_ LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST

-

---

-

---

--- -

---

-

---

-

---

1 PRD

fruits1

9.2.0.1.0 07-OCT-10 OPEN NO 1 STARTED

ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL

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

I become more and more confused. Pls help me.

Derek

[Former Member]

Hi Rajesh ,

Here is the env of prdadm:

HOSTNAME=fruits1

TERM=vt100

SHELL=/bin/csh

HISTSIZE=1000

SSH_CLIENT=::ffff:192.168.233.196 1823 22

QTDIR=/usr/lib/qt-3.3

SSH_TTY=/dev/pts/2

USER=prdadm

LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:.cmd=01;32:.exe=01;32:.com=01;32:.btm=01;32:.bat=01;32:.sh=01;32:.csh=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.zip=01;31:.z=01;31:.Z=01;31:.gz=01;31:.bz2=01;31:.bz=01;31:.tz=01;31:.rpm=01;31:.cpio=01;31:.jpg=01;35:.gif=01;35:.bmp=01;35:.xbm=01;35:.xpm=01;35:.png=01;35:.tif=01;35:

SSH_AUTH_SOCK=/tmp/ssh-YuHgiu3380/agent.3380

KDEDIR=/usr

SAPINST_JRE_HOME=/usr/java/j2sdk1.4.2_18

MAIL=/var/spool/mail/prdadm

PATH=/oracle/PRD/920_32/bin:.:/home/prdadm:/usr/sap/PRD/SYS/exe/run:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/java/j2sdk1.4.2_18/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin

INPUTRC=/etc/inputrc

PWD=/sapmnt/PRD/exe

JAVA_HOME=/usr/java/j2sdk1.4.2_18

LANG=en_US.UTF-8

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

SHLVL=2

HOME=/home/prdadm

LOGNAME=prdadm

CLASSPATH=.:/usr/java/j2sdk1.4.2_18/lib/tools.jar

SSH_CONNECTION=::ffff:192.168.233.196 1823 ::ffff:192.168.233.244 22

LESSOPEN=|/usr/bin/lesspipe.sh %s

G_BROKEN_FILENAMES=1

_=/bin/su

HOSTTYPE=i386-linux

VENDOR=intel

OSTYPE=linux

MACHTYPE=i386

GROUP=sapsys

HOST=fruits1

REMOTEHOST=192.168.233.196

SUPPORTED=zh_CN.UTF-8:zh_CN:zh:en_US.UTF-8:en_US:en:ja_JP.UTF-8:ja_JP:ja

SAPSYSTEMNAME=PRD

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

LD_LIBRARY_PATH=/usr/sap/PRD/SYS/exe/run:/oracle/PRD/920_32/lib

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=PRD

dbs_ora_schema=SAPPRD

ORACLE_PSRV=PRD

ORACLE_SID=PRD

DB_SID=PRD

ORACLE_HOME=/oracle/PRD/920_32

ORACLE_BASE=/oracle

ORA_NLS33=/oracle/client/92x_32/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/PRD

And here is the env of oraprd:

fruits1:oraprd 7> env

HOSTNAME=fruits1

TERM=vt100

SHELL=/bin/csh

HISTSIZE=1000

SSH_CLIENT=::ffff:192.168.233.196 1569 22

QTDIR=/usr/lib/qt-3.3

OLDPWD=/oracle/PRD

SSH_TTY=/dev/pts/4

USER=oraprd

LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:.cmd=01;32:.exe=01;32:.com=01;32:.btm=01;32:.bat=01;32:.sh=01;32:.csh=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.zip=01;31:.z=01;31:.Z=01;31:.gz=01;31:.bz2=01;31:.bz=01;31:.tz=01;31:.rpm=01;31:.cpio=01;31:.jpg=01;35:.gif=01;35:.bmp=01;35:.xbm=01;35:.xpm=01;35:.png=01;35:.tif=01;35:

SSH_AUTH_SOCK=/tmp/ssh-sCEeUY3288/agent.3288

KDEDIR=/usr

SAPINST_JRE_HOME=/usr/java/j2sdk1.4.2_18

MAIL=/var/spool/mail/oraprd

PATH=/oracle/PRD/920_32/bin:.:/oracle/PRD:/usr/sap/PRD/SYS/exe/run:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/java/j2sdk1.4.2_18/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin

INPUTRC=/etc/inputrc

PWD=/oracle/PRD/script

JAVA_HOME=/usr/java/j2sdk1.4.2_18

LANG=en_US.UTF-8

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

SHLVL=2

HOME=/oracle/PRD

LOGNAME=oraprd

CLASSPATH=.:/usr/java/j2sdk1.4.2_18/lib/tools.jar

SSH_CONNECTION=::ffff:192.168.233.196 1569 ::ffff:192.168.233.244 22

LESSOPEN=|/usr/bin/lesspipe.sh %s

G_BROKEN_FILENAMES=1

_=/bin/su

HOSTTYPE=i386-linux

VENDOR=intel

OSTYPE=linux

MACHTYPE=i386

GROUP=dba

HOST=fruits1

REMOTEHOST=192.168.233.196

SUPPORTED=zh_CN.UTF-8:zh_CN:zh:en_US.UTF-8:en_US:en:ja_JP.UTF-8:ja_JP:ja

SAPSYSTEMNAME=PRD

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

LD_LIBRARY_PATH=/usr/sap/PRD/SYS/exe/run:/oracle/PRD/920_32/lib

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=PRD

dbs_ora_schema=SAPPRD

ORACLE_PSRV=PRD

ORACLE_SID=PRD

DB_SID=PRD

ORACLE_HOME=/oracle/PRD/920_32

ORACLE_BASE=/oracle

ORA_NLS33=/oracle/PRD/920_32/ocommon/nls/admin/data

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/PRD

[Former Member]

Hi,

ORA-27121: unable to determine size of shared memory segment 4 ETW000 Linux Error: 13: Permission denied

Its seems be some permissions issue on ORACLE_HOME

Have you re-installed Oracle Software ?

Have you run /oracle/<SID>/920_64/root.sh after installation ?

if not, just re-run ROOT.SH as ROOT user.

Regards.

Rajesh Narkhede

[Former Member]

Hi,

you might also want to consider applying the lates patch to ORACLE.

9.2.0.1 is full of bugs.

Mark

[Former Member]

Hi Rajesh,

Thanks for your help.

I've tried the way you mentioned, us brconnect command to change the password of sapprd, however it didn't work (still the same error message in trans.log).

And then I checked that I ran root.sh in the process of oracle installtion. So may the problem is somewhere else.

Derek