Starting and stopping database in linux

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) and then issue “sqlplus / as sysdba” followed by shutdown command.

Comments

Post a Comment

Popular posts from this blog

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 etc.) 4.         Select the protocol in which the listener will be listening for the connections.
Read more

Oracle DB:Oracle 12C DB installation Error -Failed to access the temporary location

Image
While installing Oracle 12 database in Windows 7, an error "Failed to access the temporary location" occurs. Error: Cause - Failed to access the temporary location.  Action - Ensure that the current user has required permissions to access the temporary location.  Additional Information:  - Framework setup check failed on all the nodes  - Cause: Cause Of Problem Not Available  - Action: User Action Not Available Summary of the failed nodes <>- Version of exectask could not be retrieved from node “<>”  - Cause: Cause Of Problem Not Available  - Action: User Action Not Available Solution:  To get rid of this issue, add share in "Computer Management" 1. In Run (Win symbol+R) , type  compmgmt.msc 2. Under Shared Folders, Shares 3. Right click, Click on "New Share" 4. Click Next 5. Provide "C:\" in the Folder path and  click Next 6. Click Yes to continue  7. Provider "C$" fo
Read more

OSB : DB Adapter-Poll - Delete Logical Records using Oracle Service Bus 12c

Image
In this section, we will see how to use the Logical delete of records from table for polling tables from database.  Note: For creating connection factory, datasource, deployment , DBAdapter for poll and merge please verify my blog page  OSB : DB Adapter-Poll - Delete Physical Records using Oracle Service Bus 12c Here will explain only the essence of logical delete and how the data is picked and processed.  VERSION USED:  SOA SUITE 12C - 12.2.1.3 DB  12C - 12.2.0.1.0 SOURCE SCHEMA - SCOTT  SOURCE TABLE - EMP_UI TARGET SCHEMA - TGT  TARGET TABLE - EMP_UI_TGT Create table and insert records . In this option we have to add one more column for performing the logical delete just by updating the values.  Here we are making logical delete on column "STATUS" by changing poll value from "N" to "Y"  Physically the data will be available in the database but the process wont pick it as the condition mentioned for the pr
Read more