SAP startsap command can not run

[Former Member]

Hi,all

when I run the command startsap using <sid>adm system return messages:

Database db must be started on remote server

Log on to remote server and start database

if I want start sap, Must I start the remote Database service?

[former_member188883 · Accepted solution]

Hi Simily,

Whenever a startsap command is issued it does the following

1) First checks whether the database service is running or not. If not then it will try to start the database instance first.

Also it will ensure that connection to database is possible with R3trans -d

2) Once the database services are started, command will start SAP application services.

Once above steps are successfull you should be able to login to SAP system

In case your database services do not start with startsap command you can do the following

1) try to start the database manually with <orasid> user.

2) Once the database is started, check database connection using R3trans -d

3) Start the SAP application with user <sidadm>

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hello,

First of all, please confirm that your database and SAP Central Instance are on different servers (if they are on the same server and you get a "Database must be started on remote server" then there is probably a virtual host naming issue, but for now I'll assume that DB and CI are on different machines).

Do the following:

1) On the database server:

su - ora<sid> (or su - <sid>adm; either will do)
sqlplus / as sysdba
startup
exit

2) If the database comes up OK, then use command below on the application server:

su - <sid>adm
R3trans -d -w /dev/tty

The command should return exit code '0000', which means the SAP application layer is able to connect to the database. If R3trans fails (exit code '0012') look at the output and locate the Oracle error message returned (ORA-xxxxx).

If R3trans returned a status 0000 then issue the 'startsap', which should nowwork.

Good luck,

Mark

[vincentlim826]

is your DB and CI in different network segment ?

Regards,

Vincent

[Former Member]

hi,

Thanks you all replay,

First the error occur because I run the stopsap command using <sid>adm, before this opreate, the SAP system is run well.

after I run stopsap , and then when I run startsap,the issues occur.

and when I cd /oracle/<SID>/ directory and run startdb using oracleadm ,an error "Can not find executable sqlplus "

oracle database can't start.

[vincentlim826]

>> Can not find executable sqlplus

the executable of sqlplus should be under '/oracle/<sid>/<db release>/bin'

Check your environment path.

Maybe you could try add <sid>adm to group dba and oper.

Regards,

Vincent

[Former Member]

Thanks for your replay.

On my system there is no <db realease> directory under /oracle/<sid>.

my oracadm user memberof dba group

if I need run startdb command which file I should edit to modify the environment.

Thanks

[Former Member]

Hi Simily,

Could you clarify your configuration, please.

What is you Oracle release? Did you installed the SAP system, following by the SAP installation guide?

Best regards,

Orkun Gedik

[former_member188883]

Hi Simily,

I guess you have a distributed environment viz Database on 1 server and Application on 2nd sever.

If this is the case, please elablorate the scenario by mentioning the systems used in the landscape.

Regards,

Deepak Kori

[former_member189725]

Login to the database server as <sid>adm and execute the startdb command. This would issue the database startup . Then login to the sap application server and issue startsap command as user <sid>adm.

Edited by: Ratnajit Dey on Dec 30, 2011 9:34 AM