Posts

Starting and Stopping Enterprise Manager for Oracle database 11g instance in liunx

Image
Starting Enterprise Manager Ø   Open terminal and type following command Command : emctl start dbconsole Now open web browser and type https://<ip.domain>:port/em Login using sys user Stopping Enterprise Manager Ø   Open terminal and type following command Command : emctl stop dbconsole After stopping check the url https://<ip.domain>:port/em

Configure, Modify, Rename,Delete a listener for Oracle 11g database

Image
  Steps to configure listener When a client like SQL Developer, toad etc. wants to establish a connection to an Oracle Server, it usually first contacts the listener . The listener then creates a foreground process ( dedicated mode ) or attaches the request to an existing foreground process ( shared mode ). The client then directly communicates with that foreground process . A listener can accept requests for more than one instance. Likewise, more than one listener can accept requests for the same instance (load balancing). 1.         Open terminal and go to the bin folder under ORACLE_HOME  cd /u01/app/oracle/product/11.2.0/dbhome_1/bin ./netca 2.         Since there are no existing listeners we will get only add listener as option. Click on Add option and click next. 3.         Provide the name for the listener (Eg. ORCL, DB11G e...

Deleting an oracle 11g database instance

Image
Steps to delete a database instance 1.         We can delete a database using dbca command. Open terminal and go to the following path If the environment variables are not set then use the below command cd /u01/app/oracle/product/11.2.0/dbhome_1/bin If the environment variables are set then use the below command cd $ORACLE_HOME/bin Now type ./dbca in the terminal .                          2.         Click Next to continue 3.         Select option Delete a database 4.         Select the database that needs to be deleted 5.         Provide confirmation for deleting the database 6.      ...

Starting and stopping database in linux

Image
Steps to start the database instance Ø   Open terminal window and type the following command   cd /u01/app/oracle/product/11.2.0/dbhome_1/bin   sqlplus / as sysdba Ø   We will get SQL> prompt . Ø   Here type startup if already the OracleSID is set in the environment variables under bash_profile. Else export the SID using the below command   export ORACLE_SID=<sid> (In our case the sid is DB11G) and then issue “ sqlplus / as sysdba ” followed by startup command. Steps to stop a database instance Ø   Open terminal window and type the following command   cd /u01/app/oracle/product/11.2.0/dbhome_1/bin   sqlplus / as sysdba Ø   We will get SQL> prompt . Ø   Here type shutdown if already the OracleSID is set in the environment variables under bash_profile. Else export the SID using the below command   export ORACLE_SID=<sid> (In our case the sid is DB11G...