|
创建完毕。
确认数据库状态:
[php]
[oracle@ractest trace]$ sysdba
SQL*Plus: Release 11.1.0.4.0 - Beta on Thu Jun 28 04:42:32 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.4.0 - Beta
With the Partitioning, OLAP and Data Mining options
SQL> select * from v$version ;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.4.0 - Beta
PL/SQL Release 11.1.0.4.0 - Beta
CORE11.1.0.4.0Beta
TNS for Linux: Version 11.1.0.4.0 - Beta
NLSRTL Version 11.1.0.4.0 - Beta
SQL>
SQL> select status from v$instance ;
STATUS
------------
OPEN
SQL> select open_mode from v$database ;
OPEN_MODE
----------
READ WRITE
[root@ractest ~]# su - oracle
[oracle@ractest ~]$ ls -l
total 48
drwxr-xr-x 60 oracle dba 4096 Jun 28 03:40 11g
drwxr-x--- 3 oracle dba 4096 Jun 28 04:35 admin
drwxr-x--- 4 oracle dba 4096 Jun 28 04:24 cfgtoollogs
drwxr-x--- 3 oracle dba 4096 Jun 28 04:35 diag
drwxr-x--- 3 oracle dba 4096 Jun 28 04:35 oradata
drwxrwx--- 5 oracle dba 4096 Jun 28 03:40 oraInventory
[oracle@ractest ~]$ cd admin/
[oracle@ractest admin]$ ls
orcl
[oracle@ractest admin]$ ls -l
total 8
drwxr-x--- 5 oracle dba 4096 Jun 28 04:35 orcl
[oracle@ractest admin]$ cd orcl/
[oracle@ractest orcl]$ ls
adump dpdump pfile
[oracle@ractest orcl]$ ls -l
total 24
drwxr-x--- 2 oracle dba 4096 Jun 28 04:36 adump
drwxr-x--- 2 oracle dba 4096 Jun 28 04:35 dpdump
drwxr-x--- 2 oracle dba 4096 Jun 28 04:35 pfile
[oracle@ractest orcl]$ ls -l
total 24
drwxr-x--- 2 oracle dba 4096 Jun 28 04:36 adump
drwxr-x--- 2 oracle dba 4096 Jun 28 04:35 dpdump
drwxr-x--- 2 oracle dba 4096 Jun 28 04:35 pfile
[oracle@ractest orcl]$ ps -ef|grep ora
root 11522 11342 0 02:25 pts/3 00:00:00 su - oracle
oracle 11523 11522 0 02:25 pts/3 00:00:00 -bash
oracle 19779 11523 0 04:21 pts/3 00:00:00 /bin/sh -f /home/oracle/11g/bin/dbca
.....
oracle 20177 19780 2 04:35 pts/3 00:00:01 /home/oracle/11g/bin/sqlplus -S
oracle 20190 1 0 04:35 ? 00:00:00 ora_pmon_orcl
oracle 20192 1 0 04:35 ? 00:00:00 ora_vktm_orcl
oracle 20194 1 0 04:35 ? 00:00:00 ora_diag_orcl
oracle 20196 1 0 04:35 ? 00:00:00 ora_dbrm_orcl
oracle 20198 1 0 04:35 ? 00:00:00 ora_psp0_orcl
oracle 20202 1 0 04:35 ? 00:00:00 ora_dia0_orcl
oracle 20204 1 0 04:35 ? 00:00:00 ora_mman_orcl
oracle 20206 1 0 04:35 ? 00:00:00 ora_dbw0_orcl
oracle 20208 1 3 04:35 ? 00:00:03 ora_lgwr_orcl
oracle 20210 1 0 04:35 ? 00:00:00 ora_ckpt_orcl
oracle 20212 1 0 04:35 ? 00:00:00 ora_smon_orcl
oracle 20214 1 0 04:35 ? 00:00:00 ora_reco_orcl
oracle 20216 1 0 04:35 ? 00:00:00 ora_cjq0_orcl
oracle 20218 1 0 04:35 ? 00:00:00 ora_mmon_orcl
oracle 20220 1 0 04:35 ? 00:00:00 ora_mmnl_orcl
oracle 20230 1 0 04:35 ? 00:00:00 ora_smco_orcl
oracle 20232 1 0 04:36 ? 00:00:00 ora_fbar_orcl
oracle 20234 1 0 04:36 ? 00:00:00 ora_qmnc_orcl
oracle 20241 1 85 04:36 ? 00:00:40 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 20243 1 0 04:36 ? 00:00:00 ora_w000_orcl
oracle 20246 1 0 04:36 ? 00:00:00 ora_q000_orcl
root 20280 20248 0 04:36 pts/2 00:00:00 su - oracle
oracle 20281 20280 0 04:36 pts/2 00:00:00 -bash
oracle 20314 20281 0 04:36 pts/2 00:00:00 ps -ef
oracle 20315 20281 0 04:36 pts/2 00:00:00 grep ora
[oracle@ractest orcl]$ export ORACLE_SID=orcl
[oracle@ractest orcl]$ sysdba
SQL*Plus: Release 11.1.0.4.0 - Beta on Thu Jun 28 04:36:57 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.4.0 - Beta
With the Partitioning, OLAP and Data Mining options
SQL> show parameter backgr
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /home/oracle/diag/rdbms/orcl/o
rcl/trace
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.4.0 - Beta
With the Partitioning, OLAP and Data Mining options
[oracle@ractest orcl]$ cd /home/oracle/diag/rdbms/orcl/orcl/trace/
[oracle@ractest trace]$ ls -l
total 128
-rw-r----- 1 oracle dba 8823 Jun 28 04:37 alert_orcl.log
-rw-r----- 1 oracle dba 785 Jun 28 04:35 orcl_dia0_20202.trc
-rw-r----- 1 oracle dba 116 Jun 28 04:35 orcl_dia0_20202.trm
-rw-r----- 1 oracle dba 785 Jun 28 04:35 orcl_diag_20194.trc
-rw-r----- 1 oracle dba 116 Jun 28 04:35 orcl_diag_20194.trm
-rw-r----- 1 oracle dba 850 Jun 28 04:35 orcl_lgwr_20208.trc
-rw-r----- 1 oracle dba 116 Jun 28 04:35 orcl_lgwr_20208.trm
-rw-r----- 1 oracle dba 794 Jun 28 04:35 orcl_ora_20187.trc
-rw-r----- 1 oracle dba 151 Jun 28 04:35 orcl_ora_20187.trm
-rw-r----- 1 oracle dba 969 Jun 28 04:36 orcl_ora_20222.trc
-rw-r----- 1 oracle dba 188 Jun 28 04:36 orcl_ora_20222.trm
-rw-r----- 1 oracle dba 805 Jun 28 04:35 orcl_pmon_20190.trc
-rw-r----- 1 oracle dba 152 Jun 28 04:35 orcl_pmon_20190.trm
-rw-r----- 1 oracle dba 802 Jun 28 04:36 orcl_qmnc_20234.trc
-rw-r----- 1 oracle dba 116 Jun 28 04:36 orcl_qmnc_20234.trm
[oracle@ractest trace]$ tail -f alert_orcl.log
CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/home/oracle/oradata/orcl/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
Completed: CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/home/oracle/oradata/orcl/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
Thu Jun 28 04:36:19 2007
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: /home/oracle/oradata/orcl/redo02.log
Thu Jun 28 04:37:00 2007
Thread 1 advanced to log sequence 3
Current log# 3 seq# 3 mem# 0: /home/oracle/oradata/orcl/redo03.log
Thu Jun 28 04:37:34 2007
Thread 1 advanced to log sequence 4
Current log# 1 seq# 4 mem# 0: /home/oracle/oradata/orcl/redo01.log
Thu Jun 28 04:38:09 2007
Thread 1 advanced to log sequence 5
Current log# 2 seq# 5 mem# 0: /home/oracle/oradata/orcl/redo02.log
[/php] |
|