Link to home
Start Free TrialLog in
Avatar of naze_p
naze_p

asked on

Startup problems with OMS

I used to get Error 997 about the overlapped I/O operations but as soon as I managed to fix that using the /wait:100 switch I started getting the following

'Could not start the OracleOraHome81ManagementServer service on local computer. The service did not return an error. This could be an internal Windows error or an internal service error.
If the problem persistes, contact the system administrator.'

I really need this because I need to transfer a database to the college (via export).. I have all the SQL commands for database creation in a file but dont know how to run the file to create the database..
Please help

Naze Pretz
Avatar of pbisht
pbisht

Hi Naze,

I faced a similar problem at one time.  Please refer to the following link to see if that helps you -

https://www.experts-exchange.com/questions/20564257/Oracle-Management-Server-Backup-Recovery.html

Initially, my problem was different.  But, if you notice, I also got the "Windows NT Internal Service Error" message when I tried to start OMS.  Look towards the middle of the page to see where I got the error.

Hope it helps you!  Moreover, you should have posted your problem in the "Database > Oracle" part of this website.  In any case, good luck.

- Puja
Hi Naze,

You don't need the OMS to run an export. Export and Import are standalone utilities that can be run from the windows command line.

Following statement will export the schema for SCOTT.
EXP USERID=SYSTEM/pwd@SERVER OWNER=SCOTT COMPRESS=Y ROWS=Y FILE=C:\SCOTTexp.DMP LOG=C:\SCOTTexp.LOG

To import it back use :
IMP USERID=SYSTEM/pwd@SERVER FROMUSER=SCOTT TOUSER=SCOTT FILE=C:\SCOTTexp.DMP LOG=C:\SCOTTimp.LOG

Before you import the objects make sure they don't already exist or you will get errors. The user SCOTT should be present and have disk quota assigned before running the import.
ASKER CERTIFIED SOLUTION
Avatar of SDutta
SDutta

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I believe my comment has led (or would have led) to a solution and should be accepted as an answer as per EE guidelines for recommending resolution to abandoned questions.
Fair enough.  Thanks.