cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP Database is not available via R3trans

Former Member
0 Kudos

Dear Team,

When I start sap in my unix.

quality:qasadm 1> startsap

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


13:21:11 06.02.2009 LOG: Effective User Id is root

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

  • This is Saposcol Version COLL 20.90 700 - v2.05 for HP-UX - 28.7.2006

  • 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 quality 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

It start sucessfully.

But at start why it is giving messege

ABAP Database is not available via R3trans

My listner start sucessfully.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

Login as <sid>adm and execute

R3trans -d

then check the resulting trans.log

Markus

Former Member
0 Kudos

Thanks for your reply.Login with qasadm

quality:qasadm 4> R3trans -d

This is R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).

unicode enabled version

R3trans finished (0000).

Thanks

manu

markus_doehr2
Active Contributor
0 Kudos

This is all pretty strange, I have no clue.

If the returncode is 0000, startsap should not say "R3trans can't connect to database..:"

Markus

Answers (5)

Answers (5)

JPReyes
Active Contributor
0 Kudos
  • Do not cross post.

Read the "Rules of Engagement" in detail before posting any further.

Regards

Juan

former_member204746
Active Contributor
0 Kudos

please do not duplicate posts across multiple forums.

Former Member
0 Kudos

The following will explain how SAP connect to the database:

1- It use the user OPS$SIDADM to connect to the DB to get SAPSR3 password stored in table OPS$SIDADM.SAPUSER.

2- If the user OPS$SIDADM can't connect to the database (because the user does not exist or is not created properly for example), or if the table OPS$SIDADM.SAPUSER does not exist, SAP will try to connect with the default password of SAPSR3 which is 'sap'.

What I can see in your log is:

- Your OPS$SIDADM user can't connect to the database (so maybe it does not exist or is not created properly)

- The password for SAPSR3 is not the default password.

So the easiest thing to do right now is to change the password of SAPSR3 at the database level:

ALTER USER SAPSR3 IDENTIFIED BY sap;

After that it should work (if your user SAPSR3 is unlocked).

Regards

Former Member
0 Kudos

Hi.

Could be password problem inside Oracle for the sap, or for older system user sapr3.

Try to set a new password with:

1. The Unix SIDadm user owns a table called sapuser.

You can check this with sql command:

desc ops$SIDadm.sapuser; select * from ops$SIDadm.sapuser;

If the table exist it contains the encrypted password for sapr3.(older system)

2. To set a new password for sapr3 in the database:

alter user sapr3 identified by kalle; (in sqlplus)

and as Unix user SIDadm enter command:

brconnect -u / -c -f chpass -o sapr3 -p kalle

3. Test connection R3trans -d

If the database user ops$SIDadcreaym does not exist,

typically after a database refresh,You need to create it:

Regards

Björn Malström,

Former Member
0 Kudos

Hi,

This was not a problem, since your DB is not yet started by the time u specified startsap command, so it first starts checks if DB is already running if not then it starts SAPOSCOL and then DB and then up's the SAP application.

In case if your DB is up and running already u dont see that message whn u execute startsap command.

Think this clarified u.

Regards,

Raju.

Former Member
0 Kudos

My startdb.log is

quality:qasadm 6> more startdb.log

-


Thu Feb 19 10:11:50 IST 2009

LOGFILE FOR STARTING ORACLE

Trying to start QAS database ...

-


Thu Feb 19 10:11:50 IST 2009

checking required environment variables

ORACLE_HOME is >/oracle/QAS/102_64<

ORACLE_SID is >QAS<

-


Thu Feb 19 10:11:50 IST 2009

check initora

-


Thu Feb 19 10:11:50 IST 2009

check initora

-


Thu Feb 19 10:11:50 IST 2009

checking V2 connect

TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 19-FEB-2009 10:11:50

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

Used parameter files:

/usr/sap/QAS/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 = quality) (PORT =

A = (SID = QAS) (GLOBAL_NAME = QAS.WORLD)))

OK (0 msec)

tnsping: V2 connect to QAS

-


Thu Feb 19 10:11:50 IST 2009

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-


Thu Feb 19 10:11:50 IST 2009

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-


Thu Feb 19 10:11:57 IST 2009

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 19 10:11:57 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 4714397696 bytes

Fixed Size 2050336 bytes

Variable Size 2365589216 bytes

Database Buffers 2332033024 bytes

Redo Buffers 14725120 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

-


Thu Feb 19 10:12:04 IST 2009

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/QAS/SYS/exe/run/startdb: Terminating with error code 12

0 Kudos

hi,

After startsap should be created a couple of logs (trans.log and startsap.log)

please, post both

martin_juen2
Contributor
0 Kudos

Hi.

Are there more than one system running on this machine?

Which database is connected when you run R3trans -x or R3trans -x. Is this the correct one?

What else you can do is to check the profiles and the environment variables of <sid>adm. Maybe there is a wrong setting.

Check iy the listener of the database is running on the correct port!

I think standard port is something like 17421 (that is not a save info). It there are more DBs, they have to use other ports too...

regards,

Martin

Former Member
0 Kudos

thanks for your reply whats the location of trans.log and startsap.log in HP Unix server

Thanks

manu

former_member227600
Contributor
0 Kudos

hi,

Login as <sid>adm

& give command ls -ltr ,you will find trans.log & startsap.log.

Logs location is /home/<sid>adm

Former Member
0 Kudos

Dear martin,

When I was first installing SAP . It was giving error. So I was again fresh Installed SAP . But that time i was unable to delete DVEBMGS00 . So I rename to DVEBMGS00 to DVEBMGS02. and then start installation of SAP.

I check the log.

quality:oraqas 11> more startsap_.log

Checking QAS Database

-


ABAP Database is running

Starting SAP-Collector Daemon

-


saposcol already running

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol on host quality started

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

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

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol already running

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

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

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol already running

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

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

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol on host quality started

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

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

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol already running

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

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

Starting SAP-Collector Daemon

-


saposcol already running

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

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

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol already running

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

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

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol on host quality started

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

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

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol already running

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

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

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


saposcol already running

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

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

Can I delete now DVEBMGS02 now?

Thanks

Manu

former_member204746
Active Contributor
0 Kudos

yes, you can delete.

Former Member
0 Kudos

Hi Manu,

Check the listener file again and check the entries for SID_NAME,ORACLE_HOME and for HOST.if there are any incorrect entries,correct them,it should work fine then

Also are there multiple DB running on single machine

Rohit

Former Member
0 Kudos

Dear Rohit,

How to Check listener file in HP unix.where it will be.

Thanks

manu

Former Member
0 Kudos

Dear karan,

I am senidng my trans Log and Startdb Log.

plesae check and suggest me....what to do.

quality:qasadm 3> more trans.log

4 ETW000 R3trans version 6.14 (release 700 - 25.01.08 - 14:11:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 19.02.2009 - 11:40:46

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 Feb 19 11:40:46 2009 240 0.000240

4 ETW000 [dev trc ,00000] db_con_init called 31 0.000271

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

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

4 ETW000 76 0.000425

4 ETW000 [dev trc ,00000] Thu Feb 19 11:40:47 2009 49064 0.049489

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

4 ETW000 69 0.049558

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

4 ETW000 54 0.049612

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

4 ETW000 101 0.049713

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

4 ETW000 390 0.050103

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

4 ETW000 54 0.050157

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

4 ETW000 75 0.050232

4 ETW000 [dev trc ,00000] New connection 0 created 58 0.050290

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

= 255, occ = NO

4 ETW000 57 0.050347

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

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

4 ETW000 46 0.050506

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

= 255, occ = NO

4 ETW000 60 0.050566

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 519 0.051085

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 50 0.051135

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 7733 0.058868

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

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

4 ETW000 58 0.059004

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

4 ETW000 96 0.059100

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x60000000010789e0 0x6000000001080310 0x600000000109

88

4 ETW000 59 0.059159

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

4 ETW000 [dev trc ,00000] Allocating server context handle 39 0.059292

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

4 ETW000 55 0.059347

4 ETW000 [dev trc ,00000] Assigning server context 0x6000000001092cc8 to service context 0x60000000010909b8

4 ETW000 106774 0.166121

4 ETW000 [dev trc ,00000] Allocating user session handle 140 0.166261

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x60000000010909b8,srvhp=0x6000000001092cc8,usrhp=0x6000000001080b28)

4 ETW000 60 0.166321

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

4 ETW000 8531 0.174852

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

4 ETW000 59 0.174911

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 40 0.174951

4 ETW000 [dev trc ,00000] Try to connect with default password 128 0.175079

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

4 ETW000 66 0.175145

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

4 ETW000 53 0.175198

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x60000000010789e0 0x6000000001080310 0x600000000109

88

4 ETW000 51 0.175249

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

4 ETW000 46 0.175295

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

4 ETW000 88 0.175383

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x60000000010909b8,srvhp=0x6000000001092cc8,usrhp=0x6000000001080b28)

4 ETW000 60 0.175443

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

4 ETW000 3442 0.178885

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

4 ETW000 48 0.178933

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

4 ETW000 60 0.178993

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

4 ETW000 482 0.179475

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

4 ETW000 95 0.179570

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 28000 33 0.179603

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

4 ETW000 401 0.180004

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-28000: the account is locked [dblink#5 @ 431]

4 ETW000 100 0.180104

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

and

STARTDB LOG

quality:qasadm 6> more startdb.log

-


Thu Feb 19 12:17:21 IST 2009

LOGFILE FOR STARTING ORACLE

Trying to start QAS database ...

-


Thu Feb 19 12:17:21 IST 2009

checking required environment variables

ORACLE_HOME is >/oracle/QAS/102_64<

ORACLE_SID is >QAS<

-


Thu Feb 19 12:17:21 IST 2009

check initora

-


Thu Feb 19 12:17:21 IST 2009

check initora

-


Thu Feb 19 12:17:21 IST 2009

checking V2 connect

TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 19-FEB-2009 12:17:21

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

Used parameter files:

/usr/sap/QAS/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 = quality) (PORT = 1527))) (CONNECT_DAT

A = (SID = QAS) (GLOBAL_NAME = QAS.WORLD)))

OK (10 msec)

tnsping: V2 connect to QAS

-


Thu Feb 19 12:17:21 IST 2009

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-


Thu Feb 19 12:17:22 IST 2009

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-


Thu Feb 19 12:17:27 IST 2009

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 19 12:17:27 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 4714397696 bytes

Fixed Size 2050336 bytes

Variable Size 2365589216 bytes

Database Buffers 2332033024 bytes

Redo Buffers 14725120 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

-


Thu Feb 19 12:17:35 IST 2009

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/QAS/SYS/exe/run/startdb: Terminating with error code 12

My SAP is not starting . Please suggest.

Manu

Former Member
0 Kudos

Hi,

It is due to ORA-28000: the account is locked

Check this command in sqlplus

>sqlplus/nolog

>conn /as sysdba

>select username,account_status from dba_users;

check whether sap usernames are opened or locked

Mahesh

Former Member
0 Kudos

Hi Manu,

This is the problem of SAPR3 USER,

Refer to notes 400241 and 951167.

This should solve your issue for sure

Rohit

Former Member
0 Kudos

Hi,

SAPSR3 user got locked at Oracle level, thats what the reason was.

Check the account status of this user at oracle, and unlock the user this will resolve your problem.

CHk for related SAP notes.

Regards,

Raju.

Former Member
0 Kudos

Thanks for your reply,

I have unlock the user . SQL> alter user SAPSR3 ACCOUNT UNLOCK;

User altered.

but problem is same,

Startdb log

quality:qasadm 9> more startdb.log

-


Thu Feb 19 15:32:39 IST 2009

LOGFILE FOR STARTING ORACLE

Trying to start QAS database ...

-


Thu Feb 19 15:32:39 IST 2009

checking required environment variables

ORACLE_HOME is >/oracle/QAS/102_64<

ORACLE_SID is >QAS<

-


Thu Feb 19 15:32:39 IST 2009

check initora

-


Thu Feb 19 15:32:39 IST 2009

check initora

-


Thu Feb 19 15:32:39 IST 2009

checking V2 connect

TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 19-FEB-2009 15:32:39

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

Used parameter files:

/usr/sap/QAS/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 = quality) (PORT = 1

A = (SID = QAS) (GLOBAL_NAME = QAS.WORLD)))

OK (0 msec)

tnsping: V2 connect to QAS

-


Thu Feb 19 15:32:39 IST 2009

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-


Thu Feb 19 15:32:39 IST 2009

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-


Thu Feb 19 15:32:47 IST 2009

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 19 15:32:47 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 4714397696 bytes

Fixed Size 2050336 bytes

Variable Size 2365589216 bytes

Database Buffers 2332033024 bytes

Redo Buffers 14725120 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

-


Thu Feb 19 15:32:55 IST 2009

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/QAS/SYS/exe/run/startdb: Terminating with error code 12

quality:qasadm 10>

what to do.

Thanks

manu

Former Member
0 Kudos

Hi manu,

please check the status of listener lsnrctl status,whether it is started or not

start the listener with lsnrctl start using orasid

also can u paste the listener and sqlnet.ora files

Rohit

Former Member
0 Kudos

Hi Manu,

Start the database from the sql level..

log in as ora<SID>,

sqlplus /"as sysdba"

<startup;

After the log in as SIDadm and run startsap r3

Let me know is there any other instances are running on the same host or multiple database instances are installed?

If yes please check the listener.ora oand tnsnames.ora files of the both the instances...

Mahesh

Former Member
0 Kudos

Thanks for yours reply,

My lsnrctl is start sucessfully.

quality:oraqas 3> lsnrctl start

LSNRCTL for HPUX: Version 10.2.0.2.0 - Production on 20-FEB-2009 09:57:21

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

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

TNSLSNR for HPUX: Version 10.2.0.2.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=quality)(PORT=1527)))

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

STATUS of the LISTENER

-


Alias LISTENER

Version TNSLSNR for HPUX: Version 10.2.0.2.0 - Production

Start Date 20-FEB-2009 09:57:21

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=quality)(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

But WHEN I START SAP

quality:qasadm 1> startsap

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


10:05:22 20.02.2009 LOG: Effective User Id is root

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

  • This is Saposcol Version COLL 20.90 700 - v2.05 for HP-UX - 28.7.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 25263) is already running .....

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

saposcol already running

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

Trying to start QAS database ...

Log file: /home/qasadm/startdb.log

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

DB startup failed

quality:qasadm 2>

uality:qasadm 2> R3trans -d

This is R3trans version 6.14 (release 700 - 25.01.08 - 14:11:00).

unicode enabled version

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

R3trans finished (0012).

BUT WHEN I START ONLY SAP

quality:qasadm 3> startsap r3

Checking QAS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


10:07:30 20.02.2009 LOG: Effective User Id is root

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

  • This is Saposcol Version COLL 20.90 700 - v2.05 for HP-UX - 28.7.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 25263) is already running .....

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

saposcol already running

ABAP Database QAS must be started first

quality:qasadm 4>

I HAVE CHANGE THE PASSWORD VIA BRTOOLS.

quality:qasadm 4>

BR0280I BRTOOLS time stamp: 2009-02-20 10.03.54

BR0657I Input menu 59 - please check/enter input values

-


BRCONNECT options for changing password of database user

1 - BRCONNECT profile (profile) ............... [initQAS.sap]

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

3 ~ Database owner to change password (owner) . [sapsr3]

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

5 - BRCONNECT command line (command) .......... [-p initQAS.sap -l E -f chpass -o sapsr3]

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

-


BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2009-02-20 10.03.57

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

Its proper change.

I have checked vai SQL

SQL> desc OPS$QASadm.SAPSR3;

ERROR:

ORA-04043: object OPS$QASadm.SAPSR3 does not exist

SQL> select * from ops$QASadm.sapsr3;

select * from ops$QASadm.sapsr3

What other option should i checked and How?

Thanks

Manu

Former Member
0 Kudos

Hi Manu,

Is DEV & QAS instances are running on the same host. If yes check the listner.ora and tnsnames.ora files in the /oracle/SID/102_64/network/admin/ for both DEV and QAS. Compare both the Listener port nos, port no's has to different for each of the instances.

Try starting Database using sqlplus / as sysdba and startup command.

Former Member
0 Kudos

Thanks for your reply,

I have checked users in Oracle.

QL> SELECT username, lock_date, account_status expired_date from dba_users;

USERNAME LOCK_DATE EXPIRED_DATE

-


-


-


OPS$ORAPRD OPEN

OPS$SAPSERVICEPRD OPEN

OPS$PRDADM OPEN

SYS OPEN

SYSTEM OPEN

SAPSR3 OPEN

OUTLN 02-NOV-07 LOCKED

TSMSYS 02-NOV-07 EXPIRED & LOCKED

DIP 02-NOV-07 EXPIRED & LOCKED

DBSNMP 02-NOV-07 EXPIRED & LOCKED

10 rows selected.

In this It is showing all my PRD users. Because I have done clonning.

I thing I should change following user

OPS$ORAPRD to OPS$ORAQAS

OPS$SAPSERVICEPRD to OPS$SAPSERVICEQAS

OPS$PRDADM to OPS$QASADM

is it OK . if yes then How to change these user.in oracle.

Thanks

manu