在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
Outils d'IA chauds
Undresser.AI Undress
Application basée sur l'IA pour créer des photos de nu réalistes
AI Clothes Remover
Outil d'IA en ligne pour supprimer les vêtements des photos.
Undress AI Tool
Images de déshabillage gratuites
Clothoff.io
Dissolvant de vêtements AI
AI Hentai Generator
Générez AI Hentai gratuitement.
Article chaud
Outils chauds
Bloc-notes++7.3.1
Éditeur de code facile à utiliser et gratuit
SublimeText3 version chinoise
Version chinoise, très simple à utiliser
Envoyer Studio 13.0.1
Puissant environnement de développement intégré PHP
Dreamweaver CS6
Outils de développement Web visuel
SublimeText3 version Mac
Logiciel d'édition de code au niveau de Dieu (SublimeText3)
Comment vérifier la taille de l'espace de table d'Oracle
Apr 11, 2025 pm 08:15 PM
Pour interroger la taille de l'espace de table Oracle, suivez les étapes suivantes: Déterminez le nom de l'espace de table en exécutant la requête: sélectionnez Tablespace_name dans dba_tablespaces; Requête la taille de l'espace de table en exécutant la requête: sélectionnez SUM (Bytes) comme total_size, sum (bytes_free) comme disponible_space, sum (bytes) - sum (bytes_free) comme used_space à partir de dba_data_files où tablespace_
Comment importer une base de données Oracle
Apr 11, 2025 pm 08:06 PM
Méthode d'importation de données: 1. Utilisez l'utilitaire SqlLoader: Préparez les fichiers de données, créez des fichiers de contrôle et exécutez SqlLoader; 2. Utilisez l'outil IMP / EXP: les données d'exportation, les données d'importation. Astuce: 1. Chargeur SQL * recommandé pour les ensembles de Big Data; 2. La table cible doit exister et la définition de la colonne correspond; 3. Après l'importation, l'intégrité des données doit être vérifiée.
Comment créer une table dans Oracle
Apr 11, 2025 pm 08:00 PM
La création d'une table Oracle implique les étapes suivantes: Utilisez la syntaxe de la table Create pour spécifier les noms de table, les noms de colonne, les types de données, les contraintes et les valeurs par défaut. Le nom du tableau doit être concis et descriptif et ne doit pas dépasser 30 caractères. Le nom de la colonne doit être descriptif et le type de données spécifie le type de données stocké dans la colonne. La contrainte non nulle garantit que les valeurs nulles ne sont pas autorisées dans la colonne, et la clause par défaut spécifie les valeurs par défaut pour la colonne. Contraintes de clé primaire pour identifier l'enregistrement unique du tableau. La contrainte de clé étrangère spécifie que la colonne du tableau fait référence à la clé primaire dans un autre tableau. Voir la création des élèves de la table de l'échantillon, qui contient des clés primaires, des contraintes uniques et des valeurs par défaut.
Comment désinstaller l'installation d'Oracle a échoué
Apr 11, 2025 pm 08:24 PM
Désinstaller la méthode pour la défaillance de l'installation d'Oracle: Fermez le service Oracle, supprimez les fichiers du programme Oracle et les clés de registre, désinstallez les variables d'environnement Oracle et redémarrez l'ordinateur. Si la désinstallation échoue, vous pouvez désinstaller manuellement à l'aide de l'outil Oracle Universal Disinstal.
Comment afficher le nom d'instance d'Oracle
Apr 11, 2025 pm 08:18 PM
Il existe trois façons d'afficher les noms d'instance dans Oracle: utilisez le "SQLPlus" et "SELECT INSTRESS_NAME FROM V $ INSTERNE;" Commandes sur la ligne de commande. Utilisez "Show instance_name;" Commande dans SQL * Plus. Vérifiez les variables d'environnement (Oracle_sid sur Linux) via le gestionnaire de tâches du système d'exploitation, Oracle Enterprise Manager ou via le système d'exploitation.
Comment remettre à nouveau Oracle
Apr 11, 2025 pm 07:33 PM
Oracle fournit plusieurs méthodes de requête de déduplication: le mot-clé distinct renvoie une valeur unique pour chaque colonne. Le groupe par clause regroupe les résultats et renvoie une valeur non réactive pour chaque groupe. Le mot-clé unique est utilisé pour créer un index ne contenant que des lignes uniques, et l'interrogation de l'index sera automatiquement déducteur. La fonction ROW_NUMBER () attribue des nombres uniques et filtre les résultats qui contiennent uniquement la ligne 1. La fonction min () ou max () renvoie les valeurs non réactives d'une colonne numérique. L'opérateur intersecte renvoie les valeurs communes des deux ensembles de résultats (pas de doublons).
Comment crypter Oracle View
Apr 11, 2025 pm 08:30 PM
Oracle View Encryption vous permet de crypter les données dans la vue, améliorant ainsi la sécurité des informations sensibles. Les étapes incluent: 1) la création de la clé de cryptage maître (MEK); 2) Création d'une vue cryptée, spécifiant la vue et MEK à crypter; 3) Autoriser les utilisateurs à accéder à la vue cryptée. Comment fonctionnent les vues cryptées: lorsqu'un utilisateur interroge pour une vue cryptée, Oracle utilise MEK pour décrypter les données, garantissant que seuls les utilisateurs autorisés peuvent accéder aux données lisibles.
Comment obtenir du temps dans Oracle
Apr 11, 2025 pm 08:09 PM
Il existe les méthodes suivantes pour obtenir du temps dans Oracle: current_timestamp: renvoie le temps du système actuel, précis en secondes. Systimestamp: plus précis que current_timestamp, aux nanosecondes. Sysdate: renvoie la date du système actuelle, à l'exclusion de la partie d'heure. To_char (sysdate, 'yyy-mm-dd hh24: mi: ss'): convertit la date et l'heure du système actuels en format spécifique. Extrait: extrait une partie spécifique d'une valeur temporelle, comme un an, un mois ou une heure.
