Oracle & Dispatcher Problem

[Former Member]

Hi...

Our server is Windows server 2003 64 bit on which SAP IDES 6.0 is there.

its working fine. then we have remove Domin through RUN>DCPROMO command so all my user has been removed so i have again created windows users.

after that all my service working fine with Dispatcher.

but when i am trying to logon with SAPLOGON its giving "Application server shutdown" and then Dispatcher service is getting stop.

then i am trying in SQL Plus with Username/Pwd it is giving following error.

"Oracle not available.

Shared Memory realm does not exsist."

i have tried with already available forums but its not working.

kindly help me.

Regards,

[Former Member]

okay

[former_member204746]

you probably forgot to start the OracleService windows service. start it and change its startup type to AUTOMATIC.

[Former Member]

Here one thing i am adding is all the windows users have been deleted so i have created one user for oracle login.

[Former Member]

have you assigned all the permissions to the Oracle user <orasid>,also have you defined all te Oracle users

Rohit

[Former Member]

This can happen when the ORACLE_SID is not defined or incorrectly defined in the env variables.

Check all the Oracle related variables and let us know the values

Try starting Oracle database from SQL plus using orasid as user and then start SAP

Refer to Note 491174 and perform all the tests as mentioned

You will be able to solve it

Let me know if it helps

Rohit

[Former Member]

Hi....

Thanks i have tried same but its not working for me.

Regards,