I cant start the db could u please look into this error

[Former Member]

ROOT: DEVADM> startsap all

Checking DEV Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

15:43:13 09.11.1998 LOG: Effective User Id is root

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

• This is Saposcol Version COLL 20.90 700 - Intel x86 with Linux, PL:75, Aug 29 2006

• 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 5952) is already running .....

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

saposcol already running

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

Trying to start DEV database ...

Log file: /home/DEVadm/startdb.log

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

DB startup failed

Log file of startdb.log:

-

---

Mon Nov 9 15:44:19 EST 1998

LOGFILE FOR STARTING ORACLE

Trying to start DEV database ...

-

---

Mon Nov 9 15:44:19 EST 1998

checking required environment variables

ORACLE_HOME is >/oracle/DEV/102_32<

ORACLE_SID is >DEV<

-

---

Mon Nov 9 15:44:19 EST 1998

check initora

-

---

Mon Nov 9 15:44:19 EST 1998

check initora

-

---

Mon Nov 9 15:44:19 EST 1998

checking V2 connect

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 09-NOV-1998 15:44:19

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

Used parameter files:

/usr/sap/DEV/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = sample) (PORT = 1527))) (CONNECT_DATA = (SID

= DEV) (GLOBAL_NAME = DEV.WORLD)))

OK (0 msec)

tnsping: V2 connect to DEV

-

---

Mon Nov 9 15:44:19 EST 1998

Connect to the database to check the database state:

R3trans: connect check finished with return code: 139

Database not available

-

---

Mon Nov 9 15:44:20 EST 1998

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Mon Nov 9 15:44:44 EST 1998

starting database

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 9 15:44:44 1998

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 398458880 bytes

Fixed Size 1219640 bytes

Variable Size 209716168 bytes

Database Buffers 184549376 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning and Data Mining options

-

---

Mon Nov 9 15:45:00 EST 1998

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

R3trans check finished with return code: 139

• ERROR: Startup of database failed

Notify Database Administrator.

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

[andreas_herzog · Accepted solution]

then query the listener in order to get the information about the system(s) involved...

> lsnrctl

> status

you shoould see something like this (3 systems on one server...):

<i>Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=<SID>.WORLD))

STATUS of the LISTENER

-

---

Alias LISTENER

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

Start Date 16-MAY-2007 20:15:32

Uptime 43 days 12 hr. 8 min. 53 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /etc/listener.ora

Listener Log File /oracle/<SID>/102_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=<SID>.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=<SID>)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=<SID>.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=<SID>)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=<SID>.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=<SID>)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<server>)(PORT=1527)))

Services Summary...

Service "<SID>" has 1 instance(s).

Instance "<SID>", status UNKNOWN, has 1 handler(s) for this service...

Service "<SID>" has 1 instance(s).

Instance "<SID>", status UNKNOWN, has 1 handler(s) for this service...

Service "<SID>" has 1 instance(s).

Instance "<SID>", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

</i>

GreetZ, AH

[Former Member]

hello expert please login with database user i.e orasid or db2sid and start tnsname,lsnrctl services using foolwing way

goto command prompt . and

type ''lsnrctl'' and after goes to lsnrctl prompt site

type the commands the ''stop'' and ''start'' the commands

and check the status using ''status'' command and exit from ''lsnrctl'' prompt.

and type in ''tnsping sid'' with database userprompt

if database is oracle use sqlplus command with system/manager as sysdba or sysdba

from sql prompt type startup now database is starting

after database starting logoff from database user and logon to the sidadm user satrtsap using startsap command if u get any error see corresponding log file

[hannes_kuehnemund]

Dear surya,

please start the tnslsnr first, before starting SAP. To do so, login as user 'oradev' and type 'tnslsnr start'. After that, please use 'startsap' to start the database.

Thanks,

Hannes Kuehnemund

SAP LinuxLab

[Former Member]

HI,

the listner is already started this is the mesg.

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-JUN-2007 10:44:54

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

TNS-01106: Listener using listener name LISTENER has already been started

[Former Member]

Hi,

Can you run R3trans -x (with devadm user), and paste here the errors from trans.log?

Best Regards,

JC Llanes.

[HJ1]

Hi

i also facing the same issue.

please help me.

here the R3trans log

his is R3trans version 6.14 (release 700 - 24.04.08 - 14:09:00).

unicode enabled version

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

R3trans finished (0012).

[Former Member]

same here!!!!

please help mine is affecting PRD

[hannes_kuehnemund]

If PRD is affected you should open a call via OSS.