[Oracle] DBA Tasks

January 10, 2007, 11:53 pm

1. Evaluate the database server hardware
2. Install the Oracle Database
3. Plan the database
4. Create and open the database
5. Back up the database
6. Enroll system users
7. Implement the database design
8. Recover from database failure
9. Monitor database performance

by am3n in Computer

[Oracle] Controlling iSQLPlus

January 10, 2007, 11:01 pm

iSQLPlus is a web-based application provided by Oracle to query sql using a web browser rather than installing a client software, oracle driver and setting up a tns names. Here how to control iSQLPlus:

Login as oracle (or useraccount where OracleDB installed)

CODE:
cd $ORACLE_HOME/bin/

To Start iSQLPlus

CODE:
$isqlctlplus start

To Stop iSQLPlus

CODE:
$isqlctlplus stop

To Access iSQLPlus

CODE:
http://your.server.ip.address:5560/isqlplus

by am3n in Linux

[Oracle] Controlling Enterprise Manager

January 10, 2007, 10:16 pm

Oracle has Enterprise Manager web-based application which ease DBA to maintain their Oracle Database. Below is how to control EM :

Login as oracle (or useraccount where OracleDB installed)

CODE:
cd $ORACLE_HOME/bin/

To Start Enterprise Manager

CODE:
#emctl start dbconsole

To Stop Enterprise Manager

CODE:
#emctl stop dbconsole

To View Status of Enterprise Manager

CODE:
#emctl status dbconsole

To Access Enterprise Manager

CODE:
http://your.server.ip.address:1158/em

by am3n in Linux

Page : 1