Oracle Enterprise Manager (EM) is the web-based interface to manage Oracle server.
Oracle SQL Developer is a free Oracle database browser.
Use EM to understand how Oracle server works.
Use SQL Developer to understand how to manage Oracle systems setting.
Oracle Enterprise Manager:
https://[hostname]:1158/em/console/aboutApplication
To start the dbconsole process:
Navigate into your $ORACLE_HOME/bin directory
Run the following statement:
./emctl start dbconsole
Additionally, you can stop the process and view its status.
To stop the dbconsole process:sqlplus
./emctl stop dbconsole
To view the status of the dbconsole process:
./emctl status dbconsole
Oracle SQL Developer:
To use SQL Developer simply install JavaSDK, download SQL Developer and run it using the java.exe.
Create another superuser, therefore you can browse SYS without having to login to the server.
Example:
CREATE USER supersu IDENTIFIED BY "0racle"
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE temp
quota unlimited on "USERS";
GRANT CONNECT, RESOURCE TO supersu;
GRANT DBA TO supersu;
You need to understand Oracle structures and many important default views inside SYS (browse to Other Users), such as: SYS.dba_users, SYS.dba_profiles, SYS. user_profiles, etc.
Done!]]>