在Linux EL4 系统上安装Oracle成功
折腾了好多天，费了好大劲，终于在Linux EL4 系统上安装Oracle了，Cool~ 庆祝一下运行DBCA出错问题已解决，应该是软件包不全的缘
折腾了好多天，，费了好大劲，终于在Linux EL4 系统上安装Oracle了，Cool~ 庆祝一下
运行DBCA出错问题已解决，应该是软件包不全的缘故，安装了需要的软件包，卸载了以前的安装，重新安装过程中虽然出了一些错误，最终还是安装成功了
总结：需要的RPM包大多在安装盘里有，应该首先查找安装盘，（哎网上找安装包够辛苦的....）,安装盘没有的可以到网上下载，最好是官方的网站。
不要轻易放弃你坚持的事，多总结经验教训，成功只是早晚的事
附一下AlertLog日志：
Fri Sep 17 10:35:24 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
sga_target = 167772160
control_files = /u01/oracle/oradata/myoracle/control01.ctl, /u01/oracle/oradata/myoracle/control02.ctl, /u01/oracle/oradata/myoracle/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=myoracleXDB)
job_queue_processes = 10
background_dump_dest = /u01/oracle/admin/myoracle/bdump
user_dump_dest = /u01/oracle/admin/myoracle/udump
core_dump_dest = /u01/oracle/admin/myoracle/cdump
audit_file_dest = /u01/oracle/admin/myoracle/adump
db_name = myoracle
open_cursors = 300
pga_aggregate_target = 16777216
PSP0 started with pid=3, OS id=27857
MMAN started with pid=4, OS id=27859
DBW0 started with pid=5, OS id=27861
PMON started with pid=2, OS id=27855
LGWR started with pid=6, OS id=27863
CKPT started with pid=7, OS id=27865
RECO started with pid=9, OS id=27869
CJQ0 started with pid=10, OS id=27871
MMON started with pid=11, OS id=27873
Fri Sep 17 10:35:26 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=27875
SMON started with pid=8, OS id=27867
Fri Sep 17 10:35:26 2010
starting up 1 shared server(s) ...
Fri Sep 17 10:35:28 2010
The input backup piece /u01/oracle/product/10.2.0/db_1/assistants/dbca/templates/Seed_Database.dfb is in compressed format.
Full restore complete of datafile 4 to datafile copy /u01/oracle/oradata/myoracle/users01.dbf. Elapsed time: 0:00:00
checkpoint is 446074
Full restore complete of datafile 2 to datafile copy /u01/oracle/oradata/myoracle/undotbs01.dbf. Elapsed time: 0:00:01
checkpoint is 446074
Fri Sep 17 10:36:00 2010
Full restore complete of datafile 3 to datafile copy /u01/oracle/oradata/myoracle/sysaux01.dbf. Elapsed time: 0:00:31
checkpoint is 446074
Fri Sep 17 10:36:23 2010
Full restore complete of datafile 1 to datafile copy /u01/oracle/oradata/myoracle/system01.dbf. Elapsed time: 0:00:53
checkpoint is 446074
Fri Sep 17 10:36:27 2010
Create controlfile reuse set database "myoracle"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/u01/oracle/oradata/myoracle/system01.dbf',
'/u01/oracle/oradata/myoracle/undotbs01.dbf',
'/u01/oracle/oradata/myoracle/sysaux01.dbf',
'/u01/oracle/oradata/myoracle/users01.dbf'
LOGFILE GROUP 1 ('/u01/oracle/oradata/myoracle/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/oracle/oradata/myoracle/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/oracle/oradata/myoracle/redo03.log') SIZE 51200K RESETLOGS
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Fri Sep 17 10:36:29 2010
Successful mount of redo thread 1, with mount id 1828633323
Fri Sep 17 10:36:29 2010
Completed: Create controlfile reuse set database "myoracle"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/u01/oracle/oradata/myoracle/system01.dbf',
'/u01/oracle/oradata/myoracle/undotbs01.dbf',
'/u01/oracle/oradata/myoracle/sysaux01.dbf',
'/u01/oracle/oradata/myoracle/users01.dbf'
LOGFILE GROUP 1 ('/u01/oracle/oradata/myoracle/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/oracle/oradata/myoracle/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/oracle/oradata/myoracle/redo03.log') SIZE 51200K RESETLOGS
Shutting down instance: further logons disabled
Fri Sep 17 10:36:29 2010
Stopping background process CJQ0
Fri Sep 17 10:36:29 2010
Stopping background process MMNL
Fri Sep 17 10:36:30 2010
Stopping background process MMON
Fri Sep 17 10:36:31 2010
Shutting down instance (immediate)
License high water mark = 1
Fri Sep 17 10:36:31 2010
Stopping Job queue slave processes
Fri Sep 17 10:36:31 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Fri Sep 17 10:36:31 2010
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Sep 17 10:36:31 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Sep 17 10:36:35 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
sga_target = 167772160
control_files = /u01/oracle/oradata/myoracle/control01.ctl, /u01/oracle/oradata/myoracle/control02.ctl, /u01/oracle/oradata/myoracle/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_no_recovery_through_resetlogs= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=myoracleXDB)
background_dump_dest = /u01/oracle/admin/myoracle/bdump
user_dump_dest = /u01/oracle/admin/myoracle/udump
core_dump_dest = /u01/oracle/admin/myoracle/cdump
audit_file_dest = /u01/oracle/admin/myoracle/adump
db_name = myoracle
open_cursors = 300
pga_aggregate_target = 16777216
PMON started with pid=2, OS id=27913
PSP0 started with pid=3, OS id=27915
MMAN started with pid=4, OS id=27917
DBW0 started with pid=5, OS id=27919
LGWR started with pid=6, OS id=27921
CKPT started with pid=7, OS id=27923
SMON started with pid=8, OS id=27925
RECO started with pid=9, OS id=27927
MMON started with pid=10, OS id=27929
Fri Sep 17 10:36:37 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=11, OS id=27931
Fri Sep 17 10:36:37 2010
starting up 1 shared server(s) ...
Fri Sep 17 10:36:37 2010
Create controlfile reuse set database "myoracle"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/u01/oracle/oradata/myoracle/system01.dbf',
'/u01/oracle/oradata/myoracle/undotbs01.dbf',
'/u01/oracle/oradata/myoracle/sysaux01.dbf',
'/u01/oracle/oradata/myoracle/users01.dbf'
LOGFILE GROUP 1 ('/u01/oracle/oradata/myoracle/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/oracle/oradata/myoracle/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/oracle/oradata/myoracle/redo03.log') SIZE 51200K RESETLOGS
Fri Sep 17 10:36:37 2010
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Fri Sep 17 10:36:38 2010
Successful mount of redo thread 1, with mount id 1828636405
Fri Sep 17 10:36:38 2010
Completed: Create controlfile reuse set database "myoracle"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/u01/oracle/oradata/myoracle/system01.dbf',
'/u01/oracle/oradata/myoracle/undotbs01.dbf',
'/u01/oracle/oradata/myoracle/sysaux01.dbf',
'/u01/oracle/oradata/myoracle/users01.dbf'
LOGFILE GROUP 1 ('/u01/oracle/oradata/myoracle/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/oracle/oradata/myoracle/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/oracle/oradata/myoracle/redo03.log') SIZE 51200K RESETLOGS
Fri Sep 17 10:36:38 2010
Stopping background process MMNL
Fri Sep 17 10:36:38 2010
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
MMON started with pid=10, OS id=27938
Fri Sep 17 10:36:38 2010
ALTER SYSTEM enable restricted session;
Fri Sep 17 10:36:38 2010
alter database "myoracle" open resetlogs
MMNL started with pid=11, OS id=27940
Fri Sep 17 10:36:38 2010
RESETLOGS after incomplete recovery UNTIL CHANGE 446074
Fri Sep 17 10:36:38 2010
Errors in file /u01/oracle/admin/myoracle/udump/myoracle_ora_27936.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/oracle/oradata/myoracle/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Sep 17 10:36:40 2010
Errors in file /u01/oracle/admin/myoracle/udump/myoracle_ora_27936.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/oracle/oradata/myoracle/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Sep 17 10:36:41 2010
Errors in file /u01/oracle/admin/myoracle/udump/myoracle_ora_27936.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/myoracle/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Sep 17 10:36:44 2010
Setting recovery target incarnation to 2
Fri Sep 17 10:36:44 2010
Assigning activation ID 1828636405 (0x6cfec6f5)
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: /u01/oracle/oradata/myoracle/redo03.log
Successful open of redo thread 1
Fri Sep 17 10:36:44 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Sep 17 10:36:44 2010
SMON: enabling cache recovery
Fri Sep 17 10:36:47 2010
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Fri Sep 17 10:36:47 2010
SMON: enabling tx recovery
Fri Sep 17 10:36:47 2010
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is US7ASCII
Threshold validation cannot be done before catproc is loaded.
Threshold validation cannot be done before catproc is loaded.
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=15, OS id=27942
Fri Sep 17 10:36:55 2010
LOGSTDBY: Validating controlfile with logical metadata
Fri Sep 17 10:36:55 2010
LOGSTDBY: Validation complete
Global Name changed to MYORACLE
Completed: alter database "myoracle" open resetlogs
Fri Sep 17 10:36:59 2010
alter database rename global_name to "myoracle"
Completed: alter database rename global_name to "myoracle"
Fri Sep 17 10:36:59 2010
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/oradata/myoracle/temp01.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/oradata/myoracle/temp01.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Fri Sep 17 10:36:59 2010
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
Fri Sep 17 10:37:03 2010
ALTER SYSTEM disable restricted session;
Fri Sep 17 10:37:03 2010
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Sep 17 10:37:08 2010
Starting background process CJQ0
CJQ0 started with pid=19, OS id=27967
Fri Sep 17 10:37:09 2010
The input backup piece /u01/oracle/product/10.2.0/db_1/assistants/dbca/templates/example01.dfb is in compressed format.
Full restore complete of datafile 5 to datafile copy /u01/oracle/oradata/myoracle/example01.dbf. Elapsed time: 0:00:07
checkpoint is 460200
Fri Sep 17 10:37:18 2010
ALTER TABLESPACE example READ WRITE
ORA-959 signalled during: ALTER TABLESPACE example READ WRITE...
Fri Sep 17 10:37:28 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 2213K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
Fri Sep 17 10:38:53 2010
Starting background process EMN0
EMN0 started with pid=18, OS id=28077
Fri Sep 17 10:38:53 2010
Shutting down instance: further logons disabled
Fri Sep 17 10:38:55 2010
Stopping background process CJQ0
Fri Sep 17 10:38:55 2010
Stopping background process QMNC
Fri Sep 17 10:38:56 2010
Stopping background process MMNL
Fri Sep 17 10:38:56 2010
Stopping background process MMON
Fri Sep 17 10:38:57 2010
Shutting down instance (immediate)
License high water mark = 4
All dispatchers and shared servers shutdown
Fri Sep 17 10:39:04 2010
ALTER DATABASE CLOSE NORMAL
Fri Sep 17 10:39:05 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Sep 17 10:39:05 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Sep 17 10:39:05 2010
Completed: ALTER DATABASE CLOSE NORMAL
Fri Sep 17 10:39:05 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Sep 17 10:39:08 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
sga_target = 167772160
control_files = /u01/oracle/oradata/myoracle/control01.ctl, /u01/oracle/oradata/myoracle/control02.ctl, /u01/oracle/oradata/myoracle/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_no_recovery_through_resetlogs= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=myoracleXDB)
background_dump_dest = /u01/oracle/admin/myoracle/bdump
user_dump_dest = /u01/oracle/admin/myoracle/udump
core_dump_dest = /u01/oracle/admin/myoracle/cdump
audit_file_dest = /u01/oracle/admin/myoracle/adump
db_name = myoracle
open_cursors = 300
pga_aggregate_target = 16777216
PMON started with pid=2, OS id=28080
PSP0 started with pid=3, OS id=28082
MMAN started with pid=4, OS id=28084
DBW0 started with pid=5, OS id=28086
LGWR started with pid=6, OS id=28088
SMON started with pid=8, OS id=28092
CKPT started with pid=7, OS id=28090
RECO started with pid=9, OS id=28094
MMON started with pid=10, OS id=28096
Fri Sep 17 10:39:10 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=11, OS id=28098
Fri Sep 17 10:39:10 2010
starting up 1 shared server(s) ...
Fri Sep 17 10:39:10 2010
ALTER DATABASE MOUNT
Fri Sep 17 10:39:14 2010
Setting recovery target incarnation to 2
Fri Sep 17 10:39:14 2010
Successful mount of redo thread 1, with mount id 1828598926
Fri Sep 17 10:39:14 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Sep 17 10:39:14 2010
ALTER DATABASE OPEN
Fri Sep 17 10:39:14 2010
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: /u01/oracle/oradata/myoracle/redo03.log
Successful open of redo thread 1
Fri Sep 17 10:39:14 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Sep 17 10:39:14 2010
SMON: enabling cache recovery
Fri Sep 17 10:39:15 2010
Successfully onlined Undo Tablespace 1.
Fri Sep 17 10:39:15 2010
SMON: enabling tx recovery
Fri Sep 17 10:39:15 2010
Database Characterset is US7ASCII
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=15, OS id=28106
Fri Sep 17 10:39:20 2010
Completed: ALTER DATABASE OPEN
Fri Sep 17 10:39:20 2010
Stopping background process MMNL
Fri Sep 17 10:39:20 2010
Stopping background process MMON
Fri Sep 17 10:39:20 2010
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Sep 17 10:39:21 2010
Starting background process MMON
Starting background process MMNL
Fri Sep 17 10:39:21 2010
ALTER SYSTEM enable restricted session;
Fri Sep 17 10:39:21 2010
alter database character set INTERNAL_CONVERT WE8ISO8859P1
MMNL started with pid=11, OS id=28123
MMON started with pid=10, OS id=28121
Fri Sep 17 10:39:27 2010
Updating character set in controlfile to WE8ISO8859P1
Synchronizing connection with database character set information
Refreshing type attributes with new character set information
Completed: alter database character set INTERNAL_CONVERT WE8ISO8859P1
Fri Sep 17 10:39:31 2010
ALTER SYSTEM disable restricted session;
Fri Sep 17 10:39:40 2010
Starting background process EMN0
EMN0 started with pid=18, OS id=28141
Fri Sep 17 10:39:40 2010
Shutting down instance: further logons disabled
Fri Sep 17 10:39:45 2010
Stopping background process QMNC
Fri Sep 17 10:39:47 2010
Stopping background process MMNL
Fri Sep 17 10:39:48 2010
Stopping background process MMON
Fri Sep 17 10:39:49 2010
Shutting down instance (immediate)
License high water mark = 1
All dispatchers and shared servers shutdown
Fri Sep 17 10:39:56 2010
ALTER DATABASE CLOSE NORMAL
Fri Sep 17 10:39:57 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Sep 17 10:39:57 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Sep 17 10:39:57 2010
Completed: ALTER DATABASE CLOSE NORMAL
Fri Sep 17 10:39:57 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Sep 17 10:39:58 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
sga_target = 167772160
control_files = /u01/oracle/oradata/myoracle/control01.ctl, /u01/oracle/oradata/myoracle/control02.ctl, /u01/oracle/oradata/myoracle/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=myoracleXDB)
job_queue_processes = 10
background_dump_dest = /u01/oracle/admin/myoracle/bdump
user_dump_dest = /u01/oracle/admin/myoracle/udump
core_dump_dest = /u01/oracle/admin/myoracle/cdump
audit_file_dest = /u01/oracle/admin/myoracle/adump
db_name = myoracle
open_cursors = 300
pga_aggregate_target = 16777216
PMON started with pid=2, OS id=28157
PSP0 started with pid=3, OS id=28159
MMAN started with pid=4, OS id=28161
DBW0 started with pid=5, OS id=28163
LGWR started with pid=6, OS id=28165
CKPT started with pid=7, OS id=28167
SMON started with pid=8, OS id=28169
RECO started with pid=9, OS id=28171
CJQ0 started with pid=10, OS id=28173
MMON started with pid=11, OS id=28175
Fri Sep 17 10:39:59 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=28177
Fri Sep 17 10:39:59 2010
starting up 1 shared server(s) ...
Fri Sep 17 10:39:59 2010
ALTER DATABASE MOUNT
Fri Sep 17 10:40:03 2010
Setting recovery target incarnation to 2
Fri Sep 17 10:40:03 2010
Successful mount of redo thread 1, with mount id 1828608703
Fri Sep 17 10:40:03 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Sep 17 10:40:03 2010
ALTER DATABASE OPEN
Fri Sep 17 10:40:03 2010
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: /u01/oracle/oradata/myoracle/redo03.log
Successful open of redo thread 1
Fri Sep 17 10:40:03 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Sep 17 10:40:03 2010
SMON: enabling cache recovery
Fri Sep 17 10:40:04 2010
Successfully onlined Undo Tablespace 1.
Fri Sep 17 10:40:04 2010
SMON: enabling tx recovery
Fri Sep 17 10:40:04 2010
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=28188
Fri Sep 17 10:40:08 2010
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Sep 17 10:40:08 2010
Completed: ALTER DATABASE OPEN
Fri Sep 17 10:56:12 2010
Thread 1 advanced to log sequence 2
Current log# 1 seq# 2 mem# 0: /u01/oracle/oradata/myoracle/redo01.log
熱AI工具
Undresser.AI Undress
人工智慧驅動的應用程序，用於創建逼真的裸體照片
AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。
Undress AI Tool
免費脫衣圖片
Clothoff.io
AI脫衣器
AI Hentai Generator
免費產生 AI 無盡。
熱門文章
熱工具
記事本++7.3.1
好用且免費的程式碼編輯器
SublimeText3漢化版
中文版，非常好用
禪工作室 13.0.1
強大的PHP整合開發環境
Dreamweaver CS6
視覺化網頁開發工具
SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)
熱門話題
oracle如何查表空間大小
Apr 11, 2025 pm 08:15 PM
要查詢 Oracle 表空間大小，請遵循以下步驟：確定表空間名稱，方法是運行查詢：SELECT tablespace_name FROM dba_tablespaces;查詢表空間大小，方法是運行查詢：SELECT sum(bytes) AS total_size, sum(bytes_free) AS available_space, sum(bytes) - sum(bytes_free) AS used_space FROM dba_data_files WHERE tablespace_
oracle數據庫如何導入
Apr 11, 2025 pm 08:06 PM
數據導入方法：1. 使用 SQLLoader 實用程序：準備數據文件、創建控製文件、運行 SQLLoader；2. 使用 IMP/EXP 工具：導出數據、導入數據。提示：1. 大數據集推薦 SQL*Loader；2. 目標表應存在，列定義匹配；3. 導入後需驗證數據完整性。
如何在oracle中創建表
Apr 11, 2025 pm 08:00 PM
創建 Oracle 表涉及以下步驟：使用 CREATE TABLE 語法指定表名、列名、數據類型、約束和默認值。表名應簡潔、描述性，且不超過 30 個字符。列名應描述性，數據類型指定列中存儲的數據類型。 NOT NULL 約束確保列中不允許使用空值，DEFAULT 子句可指定列的默認值。 PRIMARY KEY 約束標識表的唯一記錄。 FOREIGN KEY 約束指定表中的列引用另一個表中的主鍵。請參見示例表 students 的創建，其中包含主鍵、唯一約束和默認值。
Oracle安裝失敗如何卸載
Apr 11, 2025 pm 08:24 PM
Oracle 安裝失敗的卸載方法：關閉 Oracle 服務，刪除 Oracle 程序文件和註冊表項，卸載 Oracle 環境變量，重新啟動計算機。若卸載失敗，可使用 Oracle 通用卸載工具手動卸載。
oracle如何查看實例名
Apr 11, 2025 pm 08:18 PM
在 Oracle 中查看實例名的方法有三種：命令行中使用 "sqlplus" 和 "select instance_name from v$instance;" 命令。在 SQL*Plus 中使用 "show instance_name;" 命令。通過操作系統的任務管理器、Oracle Enterprise Manager 或檢查環境變量 (Linux 上的 ORACLE_SID)。
oracle如何去重查詢
Apr 11, 2025 pm 07:33 PM
Oracle 提供多種去重查詢方法：DISTINCT 關鍵字返回每列的唯一值。 GROUP BY 子句對結果分組並返回每個分組的非重複值。 UNIQUE 關鍵字用於創建僅包含唯一行的索引，查詢該索引將自動去重。 ROW_NUMBER() 函數分配唯一數字並過濾出僅包含第 1 行的結果。 MIN() 或 MAX() 函數可返回數字列的非重複值。 INTERSECT 運算符返回兩個結果集的公共值（無重複項）。
oracle視圖如何加密
Apr 11, 2025 pm 08:30 PM
Oracle 視圖加密允許您加密視圖中的數據，從而增強敏感信息安全性。步驟包括：1) 創建主加密密鑰 (MEk)；2) 創建加密視圖，指定要加密的視圖和 MEk；3) 授權用戶訪問加密視圖。加密視圖工作原理：當用戶查詢加密視圖時，Oracle 使用 MEk 解密數據，確保只有授權用戶可以訪問可讀數據。
oracle如何獲取時間
Apr 11, 2025 pm 08:09 PM
在 Oracle 中獲取時間有以下方法：CURRENT_TIMESTAMP：返回當前系統時間，精確到秒。 SYSTIMESTAMP：比 CURRENT_TIMESTAMP 更準確，精確到納秒。 SYSDATE：返回當前系統日期，不含時間部分。 TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'): 將當前系統日期和時間轉換為特定格式。 EXTRACT：從時間值中提取特定部分，如年份、月份或小時。
