not able to connect to dba

[Former Member]

Hi Experts,

I m not able to connect to the oracle by anyuser, sysdba or else. below is the R3Trans -x log.

=================================================

4 ETW000 [dev trc ,00000] Allocating user session handle 150 0.208180

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=8000000100ab52e8,srvhp=8000000100ab7698,usrhp=8000000100ac1070)

4 ETW000 75 0.208255

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

4 ETW000 6811 0.215066

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

4 ETW000 49 0.215115

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=8000000100ab52e8,srvhp=8000000100ab7698)

4 ETW000 50 0.215165

4 ETW000 [dev trc ,00000] Deallocating server context handle 8000000100ab7698

4 ETW000 1484 0.216649

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

4 ETW000 227 0.216876

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

4 ETW000 [dev trc ,00000] Try to connect with default password 94 0.217030

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

4 ETW000 71 0.217101

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

4 ETW000 54 0.217155

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 8000000100aacd08 8000000100ab59a8 8000000100ab53b8

4 ETW000 83 0.217238

4 ETW000 [dev trc ,00000] Allocating server context handle 38 0.217276

4 ETW000 [dev trc ,00000] Attaching to DB Server BWB (con_hdl=0,svchp=8000000100ab52e8,srvhp=8000000100ab7698)

4 ETW000 263 0.217539

4 ETW000 [dev trc ,00000] Assigning server context 8000000100ab7698 to service context 8000000100ab52e8

4 ETW000 73974 0.291513

4 ETW000 [dev trc ,00000] Assigning username to user session 8000000100ac1070

4 ETW000 98 0.291611

4 ETW000 [dev trc ,00000] Assigning password to user session 8000000100ac1070

4 ETW000 123 0.291734

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=8000000100ab52e8,srvhp=8000000100ab7698,usrhp=8000000100ac1070)

4 ETW000 53 0.291787

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

4 ETW000 4327 0.296114

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

4 ETW000 50 0.296164

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=8000000100ab52e8,srvhp=8000000100ab7698)

4 ETW000 50 0.296214

4 ETW000 [dev trc ,00000] Deallocating server context handle 8000000100ab7698

4 ETW000 764 0.296978

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

4 ETW000 79 0.297057

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

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

4 ETW000 565 0.297657

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

4 ETW000 ORA-27123: unable to attach to shared memory segment

4 ETW000 HP-UX Error: 22: Invalid argument

4 ETW000 Additional information: 1

4 ETW000 Additional information: 2889264 [dblink#3 @ 428]

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

===========================================

when I try to connect to database. it is saying.

==============================================

SQL> conn sys as sysdba

Enter password:

ERROR:

ORA-09925: Unable to create audit trail file

HP-UX Error: 13: Permission denied

Additional information: 9925

ORA-01075: you are currently logged on

==============================================

I try to kill process ora_pmon_BWB but it is start again with different PID.

mccfwd08:stiw382 152> ps -ef|grep BWB

bwbadm 25719 1 0 03:27:03 ? 0:00 ora_ckpt_BWB

bwbadm 13378 7585 0 04:15:03 pts/5 0:00 grep BWB

bwbadm 25702 1 0 03:27:03 ? 0:00 ora_pmon_BWB

orabwb 14215 1 0 15:40:39 ? 0:00 /oracle/BWB/920_64/bin/tnslsnr LISTENER -inherit

bwbadm 25752 1 0 03:27:03 ? 0:00 ora_arc1_BWB

bwbadm 25131 25120 0 03:26:29 ? 0:00 ms.sapBWB_SCS44 pf=/usr/sap/BWB/SYS/profile/BWB_SCS44_mccfwd08

bwbadm 25736 1 0 03:27:03 ? 0:00 ora_reco_BWB

bwbadm 25707 1 0 03:27:03 ? 0:00 ora_dbw0_BWB

bwbadm 25731 1 0 03:27:03 ? 0:00 ora_smon_BWB

bwbadm 25120 1 0 03:26:29 ? 0:00 /usr/sap/BWB/SYS/exe/run/sapstart pf=/usr/sap/BWB/SYS/profile/S

orabwb 17900 17899 0 03:06:46 ? 0:00 oracleBWB (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

bwbadm 25739 1 0 03:27:03 ? 0:00 ora_arc0_BWB

bwbadm 25132 25120 0 03:26:30 ? 0:01 en.sapBWB_SCS44 pf=/usr/sap/BWB/SYS/profile/BWB_SCS44_mccfwd08

bwbadm 25710 1 0 03:27:03 ? 0:00 ora_lgwr_BWB

please help me to try to get me out of the problem, waiting anxiously for ur response.

Thanks in advance..

[Former Member · Accepted solution]

Hi,

Did you perform any change prior to this? Please check the permissions for oracle.

You can try cd /oracle/SID/102_64. chmod 6755 oracle tns*

And let us know the outcome.

Br,

Venky

[Former Member · Accepted solution]

hi Venky,

there was monthly activity. i used only stopsap. while I try to bring it up we had above issues.

chmod 6755 oracle tns*

I tried but in my project, we do not have orasid access.

[Former Member · Accepted solution]

Hi Mate

Have your issue resolved ? If not try to stop all the process running from ora<sid> and then restart the oracle.

Hope it will help you.

Thanks

Gaurav.

[Former Member · Accepted solution]

HI Gaurav,

today I am working with DB Team, to stop it completely.

[Former Member · Accepted solution]

Hi Experts,

Thanks for your suggestions. there was some idle ORASID processes. I killed them & start the system. It is up now.

Thanks again.

[volker_borowski2]

> I try to kill process ora_pmon_BWB but it is start again with different PID.

Hi,

mind to say, what happend before you tried anything like this?

Also some information about your environment would be nice, esp.

if there is some HA software available that is trying the restarts of your DB.

Killing proceses is not the usual way to stop oracle...

First of all: You did check the OS log for hardware errors, did you?

If this is not(!) HA environment:

stop all SAP instances

stop DB

stop Oracle listener

stop saposcol

stop sap startupservices

NOW: Check if any shared memory objects or semaphores are left, that should not be there, and clean them.

If you are not sure how to do this, consider to reboot the machine.

Startup the entire system again:

Switch to Oracle User, start the listener.

Do

lsnrctl status

and

tnsping SID

Both commands should work OK now.

Do

sqlplus / as sysdba (should report "connected to an idle instance")

being in sqlplus, enter "startup"

Messages following should end with "database opend"

leave sqlplus and switch to sidadm User

Do

R3trans -d

and check "trans.log" for errors.

If nothing is wrong up to here, you are ready to start SAP.

Volker

[Former Member]

HI Volker,

Thanks for your reply,

system does not have OS log hardware error.

mccfwd08:stiw382 49> grep -c "hardware error" /var/adm/syslog

0

*stop all SAP instances*

we have two application on the same host. do we need to stop both?

stop DB

we tried stopdb, it is not working. i have execute it no of times below is out put. the main reason is we are not able to connect to database by sysdba or else.

below command is not working

sqlplus / as sysdba

do we need to restart whole the unix box? is there any other luck?

[volker_borowski2]

Hi,

 system does not have OS log hardware error.
 mccfwd08:stiw382 49>  grep -c "hardware error" /var/adm/syslog
 0

Hmmm, that is a strong conclusion for a single grep of this specs..

What about "disk failed"? "network not responding" ? "Port already in use" ?

And what else could be in there?

You need to view and crosscheck the log!

*stop all SAP instances*
we have two application on the same host. do we need to stop both?

It depends.

Two appl.-instances of the same system? YES

Another instance of a different system? NO (...in case you know how to work ipcs and ipcrm).

stop DB
we tried stopdb, it is not working. i have execute it no of times below is out put. the main reason is we are not able to connect to database by sysdba or else.
below command is not working
sqlplus / as sysdba

And what is the error like?

Volker

[Former Member]

Hi Volker,

I have checked OS LOG. donot find any H/W network error. or else.

We have one BW instance & one ECC instance on the same server. ECC is working fine (no network issue). I have issues to start in BW instance.

I have restart BW many times.

Two appl.-instances of the same system? YES

Checking BWB Database
------------------------------
 ABAP Database is not available via R3trans

Stopping the SAP instance DVEBMGS24
----------------------------------
 Shutdown-Log is written to /home/bwbadm/stopsap_DVEBMGS24.log
 Instance DVEBMGS24 was not running!

Stopping the SAP instance SCS44
----------------------------------
 Shutdown-Log is written to /home/bwbadm/stopsap_SCS44.log
 Instance on host mccfwd08 stopped
 Waiting for cleanup of resources..........
 Database not running

we are getting below log for

sqlplus / as sysdba

mccfwd08:stiw382 19> sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.8.0 - Production on Mon Feb 20 13:42:21 2012

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

ERROR:
ORA-09925: Unable to create audit trail file
HP-UX Error: 13: Permission denied
Additional information: 9925
ORA-09925: Unable to create audit trail file
HP-UX Error: 13: Permission denied
Additional information: 9925

R3trans -x log is mentioned in the starting of the thread.

Thanks Volker,let me know for anything else