for the 1st time database users - How to start the database

For the 1st time database users  - How to start the database
( please note:  not to be used on Production DATABASE)

Connect as the right user, who has the required privileges.

How to check that
run the below command to see if the database is running
ps -ef|grep pmon

It shows
 ora112 20836     1   0 16:38:26 ?           0:10 ora_pmon_KSKDB

Please note ora112 is the Unix user who has started the database.

So, connect as ora112.

How to connect to the database

Check if the database is created in the server
cat /etc/oratab
run . oraenv

Please enter the required DATABASE name,as below :-
ex:
/home/ora112[KSKDB]:. oraenv
ORACLE_SID = [KSKDB] ?
The Oracle base remains unchanged with value /opt/64bit/oracle
/home/ora112[KSKDB]:

Ensure you have set the right database ( ORACLE_SID), check by using
How to start the database


If the database is not running, ps -ef|grep pmon will not return any rows.
To start the database, follow the steps below:-
After setting the environment, connect using the access you have.

 login as sysdba

$sqlplus / as sysdba

run
SQL > startup

Once you get the database up, you can check using the below SQL
SQL > select name , open_mode from v$database;




Connect as sysdba for any DBA related work like  unlocking users, creating user, adding space etc.


No comments:

Post a Comment