« Oracle Forcing Start »

 

Sometimes oracle is starting with some datbases not running, we can force the start :

[oracle@vmlin64ora02 ~]export ORACLE_SID=databasetest

[oracle@vmlin64ora02 ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 20 15:11:06 2013

 

Copyright (c) 1982, 2009, Oracle. All rights reserved.

 

Connected.

SQL> shutdown abort;

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

 

Total System Global Area 3340451840 bytes

Fixed Size 2217952 bytes

Variable Size 2483030048 bytes

Database Buffers 838860800 bytes

Redo Buffers 16343040 bytes

Database mounted.

Database opened.

SQL> exit

~

[oracle@vmlin64ora02 ~]$ export ORACLE_SID=mydata

[oracle@vmlin64ora02 ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 28 12:33:32 2013

 

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> shutdown abort;

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

 

Total System Global Area 1603411968 bytes

Fixed Size                  2213776 bytes

Variable Size            1006635120 bytes

Database Buffers          587202560 bytes

Redo Buffers                7360512 bytes

Database mounted.

Database opened.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@vmlin64ora02 ~]$

 

 

 

 

[oracle@vmlin64ora02 ~]$ cat .bashrc

# .bashrc

 

# Source global definitions

if [ -f /etc/bashrc ]; then

        . /etc/bashrc

fi

 

# User specific aliases and functions

export ORACLE_SID=mydata

export ORACLE_HOME="/home/oracle/app/oracle/product/11.2.0/dbhome_1"

export ORACLE_HOME_LISTNER=$ORACLE_HOME

export LD_LIBRARY_PATH="/usr/lib:/home/oracle/app/oracle_client/product/11.2.0_v32/dbhome_1"

export TNS_ADMIN="/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin"

export PATH=$PATH:./:/home/oracle/app/oracle_client/product/11.2.0_v32:/home/oracle/app/oracle_client/product/11.2.0_v32:/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin

 

# ======================================================

#                       ALIAS

# ======================================================

#Util

alias v='ps -ufx'

alias verif='ps -ufx'

alias la='ls -la'

alias bin='cd ../bin'

alias conf='cd ../conf'

alias log='cd ../log'

alias tmp='cd ../tmp'