(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db.rmohan.com)(PORT=1521)))
\nThe listener supports no services
\nThe command completed successfully
\n[oracle@db ~]$ sqlplus \/ as sysdba<\/p>\n
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 20 00:42:10 2014<\/p>\n
Copyright (c) 1982, 2009, Oracle. All rights reserved.<\/p>\n
Connected to an idle instance.<\/p>\n
SQL> select name from v$datafile;
\nselect name from v$datafile
\n*
\nERROR at line 1:
\nORA-01034: ORACLE not available
\nProcess ID: 0
\nSession ID: 0 Serial number: 0
\nSQL> startup mount
\nORA-01078: failure in processing system parameters
\nLRM-00109: could not open parameter file ‘\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/initDB11G.ora’
\nSQL> startup
\nORA-01078: failure in processing system parameters
\nLRM-00109: could not open parameter file ‘\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/initDB11G.ora’
\nSQL> exit
\nDisconnected
\n[oracle@db ~]$ env|grep ORA|sort
\nORACLE_BASE=\/u01\/app\/oracle
\nORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0\/db_1
\nORACLE_HOSTNAME=db.rmohan.com
\nORACLE_SID=DB11G
\nORACLE_UNQNAME=DB11G
\n[oracle@db ~]$ cat \/etc\/oratab
\ncat: \/etc\/oratab: No such file or directory
\n[oracle@db ~]$ export ORACLE_SID=orcl
\n[oracle@db ~]$ sqlplus \/ as sysdba<\/p>\n
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 20 00:44:23 2014<\/p>\n
Copyright (c) 1982, 2009, Oracle. All rights reserved.
\nConnected to:
\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<\/p>\n
SQL> startup
\nORA-01081: cannot start already-running ORACLE – shut it down first
\nSQL> shutdown
\nDatabase closed.
\nDatabase dismounted.
\nORACLE instance shut down.
\nSQL> startup mount
\nORACLE instance started.<\/p>\n
Total System Global Area 3223535616 bytes
\nFixed Size 2217672 bytes
\nVariable Size 1761610040 bytes
\nDatabase Buffers 1442840576 bytes
\nRedo Buffers 16867328 bytes
\nDatabase mounted.
\nSQL><\/p>\n","protected":false},"excerpt":{"rendered":"
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db.rmohan.com)(PORT=1521))) The listener supports no services The command completed successfully [oracle@db ~]$ sqlplus \/ as sysdba<\/p>\n
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 20 00:42:10 2014<\/p>\n
Copyright (c) 1982, 2009, Oracle. All rights reserved.<\/p>\n
Connected to an idle instance.<\/p>\n
SQL> select name from v$datafile; select name from v$datafile * ERROR at line 1: ORA-01034: ORACLE […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/3064"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3064"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/3064\/revisions"}],"predecessor-version":[{"id":3065,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/3064\/revisions\/3065"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}