Starting sap

[Former Member]

Hi Friends,

I have stopped sap and trying to start sap, couldn't start sap, i am getting the below error message, can anyone help please.

This is on unix HP/ oracle.

<HOST>:<SID>adm > startsap

Database <SID> must be started on remote server

Log on to remote server and start database

I have even tried stopping the listener and starting the listener and also at the SQL plus i have shutdown the database and started up.

But still i am not able to start sap

Can anyone help me please

anuroop

[Former Member]

If you are installing DB and CI instance on same host then

please check SAP profiles names with extension

I have faced the same issue on EHP7 ERP 6 installation.

When I checked the SAP profiles I found Default profile name is DEFAULT.

I changed it to DEFAULT.PFL and it works for me.

Regards.

[former_member185534]

Hello to All,

I checked entry"SAPDBHOST" and "DEFAULT.PFL".It is OK.

But the error is same :-

"Database <SID> must be started on remote server

Log on to remote server and start database"

Kindly help me to resolve this problem.

Regards,

JUNAID AHMAD

[Former Member]

Hello Anuroop,

Can you please let me know the parameters that was missing and which has resolved this issue...

I do face the same problem while starting the SAP and R3trans -d ends with RC =0

Thanks,

Sharma

[Former Member]

Database <SID> must be started on remote server
Log on to remote server and start database

your DB and CI are running on different hosts.....first login into DB and start your database and start sap from your CI host

Regards

Nick Loy

[Former Member]

Resolve,it was due the missing parameters in the profile parameters.

Thanks

[Former Member]

Hi Anuroop,

I guess your db and ci host are different. hence you require to start the DB first and try executing the startsap command.

Also try with R3trans -d to and paste the trans.log file from where you execute it.

Even if it does not start, try to paste the dev_disp and dev_w0 from /usr/sap/SID/D*/work directory.

Regards

Prash

[Former Member]

Hi Anuroop,

Please follow the following procedure to start SAP. (If possible take Operating system reboot...)

login as root

#su - orasid
#lsnrctl stop
#lsnrctl start
# exit

# su - sidadm
# stopsap
# startsap

Above sequence start the oracle and sap sequentially... (It will stop the service if it is already started...)

I think you have missed the startup sequence ...

If it still not help you, just post the startdb.log, stopdb.log, startsap_.log, stopsap_.log from orasid and sidadm users home directory...

Regards.

Rajesh Narkhede

[peter_dzurov]

try to log out and log in again with sidadm user and run startsap again.

[sunny_pahuja2]

Please paste startdb.log in home directory of the user <sid>adm.

Thanks

Sunny

[Former Member]

Hi Sunny, here is the log:---

TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 08-JAN-2010 12:13:28

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

Used parameter files:

/usr/sap/DMR/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 = pcdop1) (PORT = 1023))) (CONNECT_DATA = (SID = DMR) (GL

OBAL_NAME = DMR.WORLD)))

OK (10 msec)

tnsping: V2 connect to DMR

-

---

Fri Jan 8 12:33:28 GMT 2010

Connect to the database to check the database state:

R3trans: connect check finished with return code: 0

Database already running