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 OracleOraHome81ManagementS erver 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
'Could not start the OracleOraHome81ManagementS
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
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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