Windows And Oracle 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.

Following group are also not available in windows group

ORA_XEP_DBA

ORA_XEP_OPER

SAP_LocalAdmin

SAP_XEP_LocalAdmin

SAP_XEP_GlobalLocalAdmin

i have added in Oracle forum but not helpful so i think windows users can help

Kindly help.

[Former Member · Accepted solution]

Hi...

now my oracle is up but not able to login in sap.

one is : oraclesri102isql*plus service is not getting started.

help.

regards,

[markus_doehr2 · Accepted solution]

> now my oracle is up but not able to login in sap.

Your system is hosed up.

> one is : oraclesri102isql*plus service is not getting started.

That service is not important for a SAP system.

Chintan,

it is not supported to make changes to a domain structure after you installed the system (see the given note). That's why your SAP system is not coming up, all filesystem-, registry and user permissions are invalid.

The only way to resurrect your system is to reinstall it.

Configure first the operating system (as standalone or in a domain) - and then install the SAP system, not vice versa.

Markus

[markus_doehr2]

> 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.

A domain change implies a system copy because all permissions (filesystem, shares, ACLs etc.) were changed.

Note 1233320 - Domain migration for SAP system

<...>

To change the domain, you must perform a homogeneous system copy.

Only then SAP supports a domain switch.

<...>

Markus

[Former Member]

Please check your environment varible ORACLE_HOME is set and listner service is running.

Syntax:

cmd> lsnrctl status/start/stop

To check database

cmd> sqlplus "/as sysdba"

[former_member204746]

check that ORACLESERVICE[SID] is started properly.

[Former Member]

Hi Chintan_SAP

Did u apply any policies in domain server(at the of installation).once check policies with usernames and passwords.

first u start the database manually through sqlplus with sysdba.if database is not mounted(not open) check the corresponding oracle errors.

if database is mounted u start the listner and the SAP manually through CMD prompt.

Thanks and Regards

srinivas.