SSH Secure Shell 3.2.9 (Build 283)

Copyright (c) 2000-2003 SSH Communications Security Corp - http://www.ssh.com/
 
This copy of SSH Secure Shell is a non-commercial version.
This version does not include PKI and PKCS #11 functionality.
 
 
Last login: Fri Feb  1 07:49:04 2013 from 192.168.0.100
[root@yinhui ~]# su - oracle
[oracle@yinhui ~]$ sqlplus / as sysdba;
 
SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 1 21:15:00 2013
 
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/hui/spfilehui.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/hui/spfilehui.ora
ORA-12547: TNS:lost contact
SQL> exit    
Disconnected
[oracle@yinhui ~]$ vi .bash_profile
# .bash_profile
 
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
 
# User specific environment and startup programs
 
PATH=$PATH:$HOME/bin
 
export PATH
 
ulimit -u 16384 -n 65536
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=hui
export PATH=$PATH:$ORACLE_HOME/bin
~
~
~
~
~
".bash_profile" 18L, 346C written
[oracle@yinhui ~]$ export ORACLE_SID=hui
[oracle@yinhui ~]$ sqlplus / as sysdba;
 
SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 1 21:18:31 2013
 
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/hui/spfilehui.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/hui/spfilehui.ora
ORA-12547: TNS:lost contact
SQL> exit
 
SQL> exit
Disconnected
[oracle@yinhui ~]$ su - grid
Password: 
[grid@yinhui ~]$  ls -l $ORACLE_HOME/bin/oracle
-rwxrwxr-x 1 grid oinstall 200678464 Feb  1 00:37 /u01/app/grid/bin/oracle
[grid@yinhui ~]$ chmod 6751 $ORACLE_HOME/bin/oracle
[grid@yinhui ~]$  ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 200678464 Feb  1 00:37 /u01/app/grid/bin/oracle
[grid@yinhui ~]$ su - oracle
Password: 
[oracle@yinhui ~]$  ls -l $ORACLE_HOME/bin/oracle
-rwxrwsr-x 1 oracle asmadmin 228886468 Feb  1 00:49 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[oracle@yinhui ~]$ sqlplus / as sysdba;
 
SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 1 21:22:19 2013
 
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup
ORACLE instance started.
 
Total System Global Area 1904054272 bytes
Fixed Size                  2227632 bytes
Variable Size            1090519632 bytes
Database Buffers          805306368 bytes
Redo Buffers                6000640 bytes
Database mounted.
Database opened.
SQL>