Solved: Problem starting SAP - 2EETW169 no connect possibl...

Hi there,

Recently I just restored my QAS database and now, I'm having a problem to start the SAP application.

I'm using ECC6, HPUX B11.23 and Oracle 10.

drqaecc:qasadm 22> R3trans -d

This is R3trans version 6.14 (release 700 - 05.03.09 - 08:28:00).

unicode enabled version

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

R3trans finished (0012).

What could be the problem here?

Appreciate for any of your help and advice.

Thank you.

- Peter

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hello

- check the trans.log for the specific error from R3trans

- check if the listener is running

- look into the oracle alertlog /oracle/QAS/saptrace/background/alert_QAS.log

- check if your database is up and running:

oraqas> sqlplus / as sysdba
SQL> select * from v$instance;

If you cannot solve it, then please post the error details from trans.log.

Cheers Michael

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Michael,

Thanks for your response.

Sorry, I'm new to handling the SAP and Oracle system.

So appreciate for your help and patient.

Please find below for my answer.

- check the trans.log for the specific error from R3trans

-> Please advice how to find the path for trans.log.

- Peter

Edited by: mart1n1 on Aug 30, 2010 11:55 AM

- check if the listener is running

lsnrctl status

LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 30-AUG-2010 18:02:52

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

STATUS of the LISTENER

Alias LISTENER

Version TNSLSNR for HPUX: Version 10.2.0.4.0 - Production

Start Date 30-AUG-2010 15:19:15

Uptime 0 days 2 hr. 43 min. 37 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

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

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

Listening Endpoints Summary...

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

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

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

Services Summary...

Service "QAS" has 1 instance(s).

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

The command completed successfully

- look into the oracle alertlog /oracle/QAS/saptrace/background/alert_QAS.log

Mon Aug 30 13:34:04 2010

ALTER DATABASE MOUNT

Mon Aug 30 13:34:08 2010

Setting recovery target incarnation to 2

Mon Aug 30 13:34:08 2010

Successful mount of redo thread 1, with mount id 2117825676

Mon Aug 30 13:34:08 2010

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Mon Aug 30 15:00:34 2010

Starting ORACLE instance (normal)

Mon Aug 30 15:00:34 2010

Specified value of sga_max_size is too small, bumping to 5620367360

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.4.0.

System parameters with non-default values:

processes = 80

sessions = 96

event = 10191 trace name context forever, level 1

sga_max_size = 5620367360

shared_pool_size = 2785017856

shared_pool_reserved_size= 278330867

filesystemio_options = setall

control_files = /oracle/QAS/origlogA/cntrl/cntrlQAS.dbf, /oracle/QAS/origlogB/cntrl/cntrlQAS.dbf, /oracle/QAS/sapdata1/cntrl/cntrl

QAS.dbf

control_file_record_keep_time= 30

db_block_size = 8192

db_cache_size = 2785017856

compatible = 10.2.0

log_archive_dest = /oracle/QAS/oraarch/QASarch

log_buffer = 14485504

log_checkpoint_interval = 0

db_files = 254

log_checkpoints_to_alert = TRUE

dml_locks = 4000

replication_dependency_tracking= FALSE

undo_management = AUTO

undo_tablespace = PSAPUNDO

inmemory_undo = FALSE

undo_retention = 43200

recyclebin = off

remote_os_authent = TRUE

remote_login_passwordfile= EXCLUSIVE

job_queue_processes = 1

parallel_execution_message_size= 16384

tablelookup_prefetch_size= 0

background_dump_dest = /oracle/QAS/saptrace/background

user_dump_dest = /oracle/QAS/saptrace/usertrace

core_dump_dest = /oracle/QAS/saptrace/background

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = QAS

open_cursors = 800

sortelimination_cost_ratio= 10

btree_bitmap_plans = FALSE

star_transformation_enabled= true

query_rewrite_enabled = false

indexjoin_enabled = FALSE

optimpeek_user_binds = FALSE

pga_aggregate_target = 3711078236

optimizermjc_enabled = FALSE

PMON started with pid=2, OS id=2905

PSP0 started with pid=3, OS id=2907

MMAN started with pid=4, OS id=2909

DBW0 started with pid=5, OS id=2911

LGWR started with pid=6, OS id=2913

CKPT started with pid=7, OS id=2915

SMON started with pid=8, OS id=2917

RECO started with pid=9, OS id=2919

CJQ0 started with pid=10, OS id=2921

MMON started with pid=11, OS id=2923

MMNL started with pid=12, OS id=2925

Mon Aug 30 15:00:37 2010

ALTER DATABASE MOUNT

Mon Aug 30 15:00:41 2010

Setting recovery target incarnation to 2

Mon Aug 30 15:00:41 2010

Successful mount of redo thread 1, with mount id 2117849045

Mon Aug 30 15:00:41 2010

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

- check if your database is up and running:

oraqas> sqlplus / as sysdba

SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME

HOST_NAME

VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE

--- -

LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST

--- -

BLO

---

1 QAS

drqaecc

10.2.0.4.0 30-AUG-10 MOUNTED NO 1 STARTED

INSTANCE_NUMBER INSTANCE_NAME

HOST_NAME

VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE

--- -

LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST

--- -

BLO

---

ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL

Hi Shivaji Chowdhury,

Thanks for your response.

Please check your trans.log, make sure the listner running fine.

-> Please refer to my response posted in this thread.

Also check the dev_w*, sqlnet.ora files & TNS entries too and if the prob not resolved then provide us the detail logs.

-> There are quite a lot of dev-w* files, which one to check?

Please find below for the oracle and sql config files.

more tnsnames.ora

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

Filename......: tnsnames.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

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

QAS.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = drqaecc)

(PORT = 1527)

)

(CONNECT_DATA =

(SID = QAS)

(GLOBAL_NAME = QAS.WORLD)

)

more listener.ora

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

Filename......: listener.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = QAS.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = QAS)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = drqaecc)

(PORT = 1527)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = QAS)

(ORACLE_HOME = /oracle/QAS/102_64)

)

more sqlnet.ora

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

Filename......: sqlnet.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/SQLNET.ORA#4 $

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

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

05.01.06 set to default

#TCP.NODELAY=YES

05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

Thank you.

- Peter

Edited by: mart1n1 on Aug 30, 2010 12:17 PM

trans.log is created on the same directory you executed R3trans -d... simply post the contents.

Regards

Juan

Hi All,

I managed to find the trans.log file. Please refer to below output. Thanks.

Sorry, the below output alignment will be out as I could not find any options to keep it together.

4 ETW000 R3trans version 6.14 (release 700 - 05.03.09 - 08:28:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 30.08.2010 - 18:44:33

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] Mon Aug 30 18:44:33 2010 281 0.000281

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

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

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

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

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

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

4 ETW000 68 0.041641

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

4 ETW000 261 0.041902

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

4 ETW000 35 0.041937

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

4 ETW000 46 0.041983

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

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 38 0.042095

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

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

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

4 ETW000 34 0.042225

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 590 0.042815

4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 38 0.042853

4 ETW000 [dev trc ,00000] application info callback registered 19 0.042872

4 ETW000 [dev trc ,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000 6662 0.049534

4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 439 0.049973

4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

4 ETW000 32 0.050005

4 ETW000 [dev trc ,00000] charset='', chset='UTF8', UNI_ASC=FALSE/FALSE 39 0.050044

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 140 0.050184

4 ETW000 [dev trc ,00000] Connecting as /@QAS on connection 0 (nls_hdl 0) ... (dbsl 700 220409)

4 ETW000 38 0.050222

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

4 ETW000 95 0.050317

4 ETW000 [dev trc ,00000] 0 UTF8 0x60000000010c5510 0x60000000010cce40 0x60000000010dd7d8

4 ETW000 33 0.050350

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 67 0.050417

4 ETW000 [dev trc ,00000] Allocating server context handle 37 0.050454

4 ETW000 [dev trc ,00000] Attaching to DB Server QAS (con_hdl=0,svchp=0x60000000010dd708,srvhp=0x60000000010e0d38)

4 ETW000 35 0.050489

4 ETW000 [dev trc ,00000] Assigning server context 0x60000000010e0d38 to service context 0x60000000010dd708

4 ETW000 70342 0.120831

4 ETW000 [dev trc ,00000] Allocating user session handle 126 0.120957

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x60000000010dd708, srvhp=0x60000000010e0d38, usrhp=0x60000000010cd658)

4 ETW000 37 0.120994

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 8457 0.129451

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1033: 187 0.129638

4 ETW000 [dev trc ,00000] ORA-01033: ORACLE initialization or shutdown in progress

4 ETW000 58 0.129696

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

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

4 ETW000 40 0.129765

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x60000000010e0d38 from con_hdl=0

4 ETW000 386 0.130151

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

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1033 38 0.130330

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1033) 32 0.130362

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1033 110 0.130472

4 ETW000 [dev trc ,00000] ORA-01033: ORACLE initialization or shutdown in progress

4 ETW000 34 0.130506

4 ETW000 [dev trc ,00000] Try to connect with default password 29 0.130535

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

4 ETW000 32 0.130567

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

4 ETW000 85 0.130652

4 ETW000 [dev trc ,00000] 0 UTF8 0x60000000010c5510 0x60000000010cce40 0x60000000010dd7d8

4 ETW000 34 0.130686

4 ETW000 [dev trc ,00000] Allocating server context handle 19 0.130705

4 ETW000 [dev trc ,00000] Attaching to DB Server QAS (con_hdl=0,svchp=0x60000000010dd708,srvhp=0x60000000010e0d38)

4 ETW000 35 0.130740

4 ETW000 [dev trc ,00000] Assigning server context 0x60000000010e0d38 to service context 0x60000000010dd708

4 ETW000 71836 0.202576

4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0x60000000010cd658

4 ETW000 32 0.202608

4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0x60000000010cd658

4 ETW000 88 0.202696

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0x60000000010dd708, srvhp=0x60000000010e0d38, usrhp=0x60000000010cd658)

4 ETW000 38 0.202734

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 5277 0.208011

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1033: 120 0.208131

4 ETW000 [dev trc ,00000] ORA-01033: ORACLE initialization or shutdown in progress

4 ETW000 41 0.208172

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

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

4 ETW000 30 0.208230

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x60000000010e0d38 from con_hdl=0

4 ETW000 140 0.208370

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

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1033 20 0.208421

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1033) 22 0.208443

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1033 110 0.208553

4 ETW000 [dev trc ,00000] ORA-01033: ORACLE initialization or shutdown in progress

4 ETW000 36 0.208589

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

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

4 ETW000 42 0.208823

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

Edited by: mart1n1 on Aug 30, 2010 12:29 PM

Hi,

Error is

ORA-12541: TNS:no listener

Listener is not running , Can you restart using

lsnrctl stop

lsnrctls start

After this provide the output of

tnsping QAS

Regards,

Hu Juan,

Thanks for the info.

I managed to find the file and had posted its content.

Please kindly help to check and advice.

Thank you.

- Peter

Hi Gagan,

Please refer to below output. Thanks.

oraqas 1> lsnrctl stop

LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 30-AUG-2010 18:53:14

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

The command completed successfully

oraqas 2> lsnrctl start

LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 30-AUG-2010 18:53:27

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

TNSLSNR for HPUX: Version 10.2.0.4.0 - Production

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

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

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

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

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

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

STATUS of the LISTENER

Alias LISTENER

Version TNSLSNR for HPUX: Version 10.2.0.4.0 - Production

Start Date 30-AUG-2010 18:53:27

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

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

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

Listening Endpoints Summary...

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

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

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

Services Summary...

Service "QAS" has 1 instance(s).

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

The command completed successfully

oraqas 4> tnsping QAS

TNS Ping Utility for HPUX: Version 10.2.0.4.0 - Production on 30-AUG-2010 18:55:36

Used parameter files:

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

Used TNSNAMES adapter to resolve the alias

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

OK (0 msec)

HI All,

There is an error message when listener is started.

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

I'm not sure what is the error about and what caused it.

Is there anything that I've missed out or checked?

Please kindly advice.

Thank you.

- Peter

Edited by: mart1n1 on Aug 30, 2010 12:43 PM

Your database is not up, status is mounted, should be open. You probably need to recover the database after the restore.

SQL> recover database;
SQL> alter database open;

The exact procedure depends on why you restored at all and if you have all redologs available. We cannot tell that so far.

Cheers Michael

Hi,

It looks like that first you stopped SAP but it was not stopped properly and immediately you started again. Log on to oracle and first stop it properly and then try to start.

Thanks

Sunny

Hi Michael,

Thanks for your advice.

I've already tried your suggestion, please refer below.

SQL> recover database;

Media recovery complete.

SQL> alter database open;

Database altered.

Initially, when the restore process is completed, I had performed the followings:

1) recover database using backup controlfile until cancel

-> It did not compele successfully as there are a few missing archive log files.

2) alter database open resetlogs

-> No problem.

As of now, what should I do now?

Please kindly advice.

Thanks.

- Peter

Try to startsap - Cheers Michael

Hi Sunny,

I've not started the SAP application yet as I'm having some problem starting listener.

However, when I executed: startup mount, there is no problem. Please see below.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 5620367360 bytes

Fixed Size 2064184 bytes

Variable Size 2818572488 bytes

Database Buffers 2785017856 bytes

Redo Buffers 14712832 bytes

Database mounted.

Thanks.

- Peter

HI Michael,

Thanks for your advice.

After I tried your suggestion, it seems that the SAP database is able to start up.

Please refer below.

qasadm 21> startsap

Checking QAS Database

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

19:20:13 30.08.2010 LOG: Effective User Id is root

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

This is Saposcol Version COLL 20.95 700 - 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
Starting collector (create new process)

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

saposcol on host drqaecc started

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

Trying to start QAS database ...

Log file: /home/qasadm/startdb.log

QAS database started

/usr/sap/QAS/SYS/exe/run/startdb completed successfully

Starting SAP Instance DVEBMGS00

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

Instance Service on host drqaecc started

Instance on host drqaecc started

I've checked and tried to logon to my QAS system, it's working fine.

Thanks a lot for your kind help as I've been struggling with this issue for a few days already.

Greatly appreciate it.

- Peter

It works!

Thank you!

Answers (1)

This is one of common error often reported. Couple of things to look.

Please check your trans.log, make sure the listner running fine. Also check the dev_w*, sqlnet.ora files & TNS entries too and if the prob not resolved then provide us the detail logs.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count

Problem starting SAP - 2EETW169 no connect possible: "DBMS = ORACLE

Accepted Solutions (1)

Accepted Solutions (1)

Answers (1)

Answers (1)

SKU for Additional Storage

Re: IAS as proxy

Re: cloud connector

Re: SAP Cloud Identity Services

Corporate Git Setup on SAP BTP versus connecting t...