R/3 not coming up.

[Former Member]

Hi,

I'm trying to do a system start using startsap. Just to give a background, I ran SGEN and the archive logs directory went full. Its currently 100% full with around 24 mb left.

I disabled the archive log by the following commands in SQL.

SQL> SHUTDOWN

SQL> STARTUP MOUNT

SQL> ALTER DATABASE NOARCHIVELOG;

SQL> ALTER DATABASE OPEN;

Then did an SAP start. This is a non dual stack system so JAVA SID is EEA, when I switch to eeaadm and do a startsap, then the JAVA side comes up, so means DAta base is running fine.

Below are the details of startsap for ABAP, Please help me, as my delivery of the system is in another couple of hrs and now this .

Checking EE0 Database

-

---

Database is running

Starting Startup Agent sapstartsrv

-

---

Instance Service on host sapbl028 started

Starting SAP Instance DVEBMGS00

-

---

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

Instance already running

Starting SAP-Collector Daemon

-

---

17:53:54 02.08.2009 LOG: Effective User Id is root

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

• This is Saposcol Version COLL 20.95 701 - V2.7.1 2008-08-11 HP-UX IA64

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 24736) is already running .....

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

saposcol already running

Thanks,

Nitin

[Former Member]

Just to add,

Checking the sap services after start gives me only these many services, infact there should be so many.

> ps -ef | grep sap | grep ee0adm

ee0adm 12627 12625 0 17:22:47 ? 0:00 /usr/sap/EE0/DVEBMGS00/exe/igspw_mt -mode=profile -no=0 -restartcount=0 pf=/usr/sap/EE0/SYS/profile/EE0_DVEBMGS00_sapbl028

ee0adm 12628 12625 0 17:22:47 ? 0:00 /usr/sap/EE0/DVEBMGS00/exe/igspw_mt -mode=profile -no=1 -restartcount=0 pf=/usr/sap/EE0/SYS/profile/EE0_DVEBMGS00_sapbl028

ee0adm 12626 12625 0 17:22:47 ? 0:00 /usr/sap/EE0/DVEBMGS00/exe/igsmux_mt -mode=profile -restartcount=0 pf=/usr/sap/EE0/SYS/profile/EE0_DVEBMGS00_sapbl028

ee0adm 12623 12568 0 17:22:47 ? 0:00 co.sapEE0_DVEBMGS00 pf=/usr/sap/EE0/SYS/profile/EE0_DVEBMGS00_sapbl028 -F

ee0adm 12568 1 0 17:22:47 ? 0:00 /usr/sap/EE0/DVEBMGS00/exe/sapstart pf=/usr/sap/EE0/SYS/profile/START_DVEBMGS00_sapbl028

ee0adm 12621 12568 0 17:22:47 ? 0:00 ms.sapEE0_DVEBMGS00 pf=/usr/sap/EE0/SYS/profile/EE0_DVEBMGS00_sapbl028

ee0adm 12625 12568 0 17:22:47 ? 0:00 ig.sapEE0_DVEBMGS00 -mode=profile pf=/usr/sap/EE0/SYS/profile/EE0_DVEBMGS00_sapbl028

ee0adm 24736 1 0 Jul 31 ? 3:26 /usr/sap/EE0/SYS/exe/run/saposcol

ee0adm 12624 12568 0 17:22:47 ? 0:00 se.sapEE0_DVEBMGS00 pf=/usr/sap/EE0/SYS/profile/EE0_DVEBMGS00_sapbl028 -F

ee0adm 24567 1 0 Jul 31 ? 0:01 /usr/sap/EE0/DVEBMGS00/exe/sapstartsrv pf=/usr/sap/EE0/SYS/profile/EE0_DVEBMGS00_sapbl028 -D

Thanks,

Nitin

[anindya_bose]

Nitin

Move or archive or compress some archive log files. Then restart your database and then try to start SAP.

See what happens

[Former Member]

Check the LISTENER, and if listener is not up start it and than start SAP again.

[Former Member]

Please give me the command for Move & Thanks

[Former Member]

Java is working so means the DB is working fine, what do you suggest.

[anindya_bose]

move source directory destination directory...

[Former Member]

Check R3trans is working, if not post trans.logs

[Former Member]

After stopping the SAP, stopsap

These were the services that were still there after stopping, I stopped saposcol rest of the services are these,

oraee0 25204 1 0 Jul 24 ? 0:00 xterm -geometry 80x241010 -ls -title sapbl028:2 (oraee0) Desktop

oraee0 25199 25198 0 Jul 24 ? 0:00 Xvnc :2 -PasswordFile /oracle/EE0/.vnc/passwd -auth /oracle/EE0/.Xauthority -UserPasswdVerifier=VncAuth -desktop sapbl028:2 (or

oraee0 5176 1 0 Jul 24 ? 0:01 Xvnc :6 -PasswordFile /oracle/EE0/.vnc/passwd -auth /oracle/EE0/.Xauthority -UserPasswdVerifier=VncAuth -desktop sapbl028:6 (or

oraee0 5177 5176 0 Jul 24 ? 0:00 Xvnc :6 -PasswordFile /oracle/EE0/.vnc/passwd -auth /oracle/EE0/.Xauthority -UserPasswdVerifier=VncAuth -desktop sapbl028:6 (or

oraee0 25198 1 0 Jul 24 ? 0:20 Xvnc :2 -PasswordFile /oracle/EE0/.vnc/passwd -auth /oracle/EE0/.Xauthority -UserPasswdVerifier=VncAuth -desktop sapbl028:2 (or

ee0adm 24567 1 0 Jul 31 ? 0:01 /usr/sap/EE0/DVEBMGS00/exe/sapstartsrv pf=/usr/sap/EE0/SYS/profile/EE0_DVEBMGS00_sapbl028 -D

Could this be a problem ? Shall i stop the services the one below and saposcol and the start again

ee0adm 24567 1 0 Jul 31 ? 0:01 /usr/sap/EE0/DVEBMGS00/exe/sapstartsrv pf=/usr/sap/EE0/SYS/profile/EE0_DVEBMGS00_sapbl028 -D

Thanks,

Nitin

[Former Member]

I tried R3trans -d and got a no connect, but that couldnt be a problem as i got the same error for an already running server.

[Former Member]

trans.log

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

4 ETW000 40 0.095268

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

4 ETW000 41 0.095309

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x60000000010a02c8

4 ETW000 957 0.096266

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

4 ETW000 141 0.096407

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1033 27 0.096434

4 ETW000 [dev trc ,00000] Try to connect with default password 142 0.096576

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

4 ETW000 42 0.096618

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

4 ETW000 45 0.096663

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x6000000001085fe0 0x600000000108d910 0x600000000109e088

4 ETW000 43 0.096706

4 ETW000 [dev trc ,00000] Allocating server context handle 29 0.096735

4 ETW000 [dev trc ,00000] Attaching to DB Server EE0 (con_hdl=0,svchp=0x600000000109dfb8,srvhp=0x60000000010a02c8)

4 ETW000 55 0.096790

4 ETW000 [dev trc ,00000] Sun Aug 2 08:05:43 2009 42844 0.139634

4 ETW000 [dev trc ,00000] Assigning server context 0x60000000010a02c8 to service context 0x600000000109dfb8

4 ETW000 46 0.139680

4 ETW000 [dev trc ,00000] Assigning username to user session 0x600000000108e128

4 ETW000 44 0.139724

4 ETW000 [dev trc ,00000] Assigning password to user session 0x600000000108e128

4 ETW000 76 0.139800

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x600000000109dfb8,srvhp=0x60000000010a02c8,usrhp=0x600000000108e128)

4 ETW000 44 0.139844

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

4 ETW000 4963 0.144807

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

4 ETW000 40 0.144847

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

4 ETW000 41 0.144888

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x60000000010a02c8

4 ETW000 1957 0.146845

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

4 ETW000 53 0.146898

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1033 27 0.146925

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1033 performing CON [dblink#1 @ 431]

4 ETW000 302 0.147227

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01033: ORACLE initialization or shutdown in progress [dblink#1 @ 431]

4 ETW000 40 0.147267

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

Regards,

Nitin

[Former Member]

This log is generated after stopping,

[anindya_bose]

have a look at the notes below

https://service.sap.com/sap/support/notes/655240

https://service.sap.com/sap/support/notes/602843

Do you have auth to restart your whole UNix server? If yes, then you can try that.

But please make sure you ove some files from Oraarch directory to make some free space there.

[Former Member]

Hi Guys,

Thanks for your messages.

I can see that the Java is running fine, Which clearly shows that the DB is running ok. But not sure why the R/3 is not coming up and that error in the log file.

I had also made changed to the profiles. Could this be an issue? How to use the old profiles now?

Regards,

Nitin

[Former Member]

Check Note 400241 - Problems with ops$ or sapr3 connect to Oracle. Also Did you try to restart the services and/or server if there is a possibility?

[markus_doehr2]

What did you do prior to this problem? Did you maybe install Oracle patches?

Markus

[fidel_vales]

>

> I can see that the Java is running fine, Which clearly shows that the DB is running ok. But not sure why the R/3 is not coming up and that error in the log file. 

Hi,

Java connects to the DB using the JDBC driver and passing the "connection string", all needed information is stored "inside", somewhere, thee J2EE

R/3 is using a totally different connection method. You MUST jave the proper oracle clinet installed, the user has to belong to certain groups, etc.

One of the MOST important differences is that you MUST set the proper environment variables to be able to connect.

As Markus mentioned, probably you have changed something that makes the connection fail.

We know that your DB is up (you seem to be able to connect via Java) that means that something else is wrong.

From your unformatted trans.log the first error found is the following one:

> *** ERROR => CONNECT failed with sql error '1033'

and later on you have the explanation:

>***LOG BY0=>ORA-01033: ORACLE initialization or shutdown in progress

as we know that the DB is up (you should doublecheck this) then you are trying to connect to the wrong database, probably you have some environment variables wrong, or perhaps the tnsnames.ora or ...

you already were given two notes that give information on how to troubleshoot this error. Please, read them and follow the instructions there