修改ORACLE_SID=ora4
$ vi .profile
# This is the default standard profile provided to a user.
# They are expected to edit it to meet their own needs.
ORACLE_BASE=/export/home/oracle
ORACLE_HOME=$ORACLE_BASE/product/10.0
ORACLE_SID=ora4
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
PATH=$ORACLE_HOME/bin:/bin:/sbin:/usr/ccs/bin:/usr/local/bin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/usr/local/lib:/usr/lib
DISPLAY=192.168.1.66:0.0
TMPDIR=/var/tmp
export ORALCE_BASE ORACLE_HOME ORACLE_SID NLS_LANG PATH LD_LIBRARY_PATH DISPLAY TMPDIR
umask 022
MAIL=/usr/mail/${LOGNAME:?}
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified[/COLOR]
ORACLE instance started.
Total System Global Area134217728 bytes
Fixed Size
1278928 bytes
Variable Size
96472112 bytes
Database Buffers 33554432 bytes
Redo Buffers
2912256 bytes
Database mounted.
Database opened.
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Oct 17 09:47:31 2007
Copyright (c) 1982, 2005, Oracle.All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter session set sql_trace=true;
Session altered.
SQL> alter database backup controlfile to trace;
Database altered.
SQL> @gettrcname.sql
TRACE_FILE_NAME
--------------------------------------------------------------------------------
/export/home/oracle/product/10.0/admin/ora1/udump/ora1_ora_21011.trc
SQL> !more /export/home/oracle/product/10.0/admin/ora1/udump/ora1_ora_21011.trc
/export/home/oracle/product/10.0/admin/ora1/udump/ora1_ora_21011.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /export/home/oracle/product/10.0
System name:SunOS
Node name:solaris
Release:5.10
Version:Generic
Machine:i86pc
Instance name: ora1
