Posted on

Export Oracle Database to SQL

For those of us who have some experience with MySQL exporting the data to sql just just a normal way of working. No big fuss, just start phpmyadmin, select export and it’s done. With Oracle is not as easy – you can create dump using exp and import it using imp. Which is useless if you need to modify some data in between.
Google suggests many shareware tools to do the export, which will cost you at least $49. I, on the other hand, suggest using Free and supported SQL Developer from Oracle. It has tons of great features, one of which is Database Export. Just follow a simple creator and you’re done!

Posted on

Problem starting Oracle Database Control Service

Today I run into problem running Oracle Database Control Service on Windows 2003 Server. When I was trying to run it using Administrative Tools->Services I got an error:
“Windows could not start the OracleDBConsoleWIND on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2”.
Quick look in the Event Viewer proved it usless:
The OracleDBConsoleWIND service terminated with service-specific error 2 (0x2).
The solution came when I tried to run the service using console:
set ORACLE_SID=wind
C:\ptc\PDMLink>emctl start dbconsole
OC4J Configuration issue. C:\oracle\ora102/oc4j/j2ee/OC4J_DBConsole_winddev1_wind not found.
Gotcha!
In C:\oracle\ora102/oc4j/j2ee/ directory I had only:
OC4J_DBConsole_winddev1.devintl.com_wind
After some network reconfiguration the host started to appear using only host name, not fully qualified host name. Fair enough, I had just copied the folder to match current host name and the console is working again:

C:\ptc\PDMLink>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://winddev1.devintl.com:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsoleWI
ND service is starting...............
The OracleDBConsoleWIND service was started successfully.