在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 기반 앱
AI Clothes Remover
사진에서 옷을 제거하는 온라인 AI 도구입니다.
Undress AI Tool
무료로 이미지를 벗다
Clothoff.io
AI 옷 제거제
AI Hentai Generator
AI Hentai를 무료로 생성하십시오.
인기 기사
뜨거운 도구
메모장++7.3.1
사용하기 쉬운 무료 코드 편집기
SublimeText3 중국어 버전
중국어 버전, 사용하기 매우 쉽습니다.
스튜디오 13.0.1 보내기
강력한 PHP 통합 개발 환경
드림위버 CS6
시각적 웹 개발 도구
SublimeText3 Mac 버전
신 수준의 코드 편집 소프트웨어(SublimeText3)
뜨거운 주제
7489
15
1377
52
77
11
52
19
19
41
Oracle의 테이블 스페이스 크기를 확인하는 방법
Apr 11, 2025 pm 08:15 PM
Oracle 테이블 스페이스 크기를 쿼리하려면 다음 단계를 따르십시오. 쿼리를 실행하여 테이블 스페이스 이름을 결정하십시오. 쿼리를 실행하여 테이블 스페이스 크기를 쿼리하십시오. sum (bytes)을 total_size, sum (bytes_free)으로 sum (bytes_free), sum (bytes) - sum (bytes_free)으로 dba_data_fices where tablespace_.
Oracle 데이터베이스를 가져 오는 방법
Apr 11, 2025 pm 08:06 PM
데이터 가져 오기 방법 : 1. SQLLOADER 유틸리티 사용 : 데이터 파일 준비, 제어 파일 작성 및 SQLLOADER 실행; 2. IMP/EXP 도구를 사용하십시오 : 데이터 내보내기, 데이터 가져 오기. 팁 : 1. 빅 데이터 세트에 권장되는 SQL*로더; 2. 대상 테이블이 존재해야하고 열 정의가 일치해야합니다. 3. 가져 오기 후에는 데이터 무결성을 확인해야합니다.
Oracle에서 테이블을 만드는 방법
Apr 11, 2025 pm 08:00 PM
Oracle 테이블 작성에는 다음 단계가 필요합니다. 테이블 작성 구문을 사용하여 테이블 이름, 열 이름, 데이터 유형, 제약 조건 및 기본값을 지정하십시오. 테이블 이름은 간결하고 설명 적이어야하며 30자를 초과해서는 안됩니다. 열 이름은 설명 적이어야하며 데이터 유형은 열에 저장된 데이터 유형을 지정합니다. NOT NULL 제약 조건은 열에서 NULL 값이 허용되지 않도록하고 기본 조항은 열의 기본값을 지정합니다. 테이블의 고유 한 레코드를 식별하기위한 주요 주요 제약. 외국 키 제약 조건은 테이블의 열이 다른 테이블의 기본 키를 지칭하도록 지정합니다. 기본 키, 고유 한 제약 조건 및 기본값이 포함 된 샘플 테이블 학생의 생성을 참조하십시오.
Oracle 설치를 제거하는 방법에 실패했습니다
Apr 11, 2025 pm 08:24 PM
Oracle 설치 실패에 대한 방법 제거 : Oracle Service를 닫고 Oracle Program 파일 및 레지스트리 키 삭제, Oracle 환경 변수를 제거하고 컴퓨터를 다시 시작하십시오. 제거되지 않으면 Oracle 범용 제거 도구를 사용하여 수동으로 제거 할 수 있습니다.
Oracle의 인스턴스 이름을 보는 방법
Apr 11, 2025 pm 08:18 PM
Oracle에서 인스턴스 이름을 보는 세 가지 방법이 있습니다. 명령 줄에 명령. "show instance_name"을 사용하십시오. sql*plus의 명령. 운영 체제의 작업 관리자, Oracle Enterprise Manager 또는 운영 체제를 통해 환경 변수 (Linux의 Oracle_Sid)를 확인하십시오.
Oracle을 수반하는 방법
Apr 11, 2025 pm 07:33 PM
Oracle은 여러 가지 중복 제거 쿼리 방법을 제공합니다. 별개의 키워드는 각 열에 고유 한 값을 반환합니다. 그룹 별 조항은 결과를 그룹화하고 각 그룹에 대해 비 반복 값을 반환합니다. 고유 한 키워드는 고유 한 행만 포함 된 인덱스를 만드는 데 사용되며 인덱스 쿼리는 자동으로 망상됩니다. row_number () 함수는 고유 한 숫자를 할당하고 1 행 만 포함하는 결과를 필터링합니다. 최소 () 또는 max () 함수는 숫자 열의 비 반복 값을 반환합니다. 교차 연산자는 두 결과 세트의 공통 값을 반환합니다 (중복 없음).
Oracle View를 암호화하는 방법
Apr 11, 2025 pm 08:30 PM
Oracle View 암호화를 사용하면보기에서 데이터를 암호화 할 수 있으므로 민감한 정보의 보안을 향상시킬 수 있습니다. 단계에는 다음이 포함됩니다. 1) 마스터 암호화 키 생성 (MEK); 2) 암호화 된 뷰 생성, 암호화 할보기 및 MEK를 지정하는 것; 3) 사용자가 암호화 된보기에 액세스하도록 승인합니다. 암호화 된 뷰 작동 방식 : 사용자가 암호화 된보기를 쿼리 할 때 Oracle은 MEK를 사용하여 데이터를 해독하여 공인 사용자 만 읽기 쉬운 데이터에 액세스 할 수 있도록합니다.
오라클에서 시간을 얻는 방법
Apr 11, 2025 pm 08:09 PM
Oracle에는 시간을 얻는 방법이 있습니다. current_timestamp : 현재 시스템 시간을 반환합니다. Systimestamp : current_timestamp보다 나노 초보다 더 정확합니다. sysdate : 시간 부분을 제외하고 현재 시스템 날짜를 반환합니다. to_char (sysdate, 'yyy-mm-dd hh24 : mi : ss') : 현재 시스템 날짜와 시간을 특정 형식으로 변환합니다. 추출 : 1 년, 월 또는 시간과 같은 시간 값에서 특정 부분을 추출합니다.
