在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
Alat AI Hot
Undresser.AI Undress
Apl berkuasa AI untuk mencipta foto bogel yang realistik
AI Clothes Remover
Alat AI dalam talian untuk mengeluarkan pakaian daripada foto.
Undress AI Tool
Gambar buka pakaian secara percuma
Clothoff.io
Penyingkiran pakaian AI
AI Hentai Generator
Menjana ai hentai secara percuma.
Artikel Panas
Alat panas
Notepad++7.3.1
Editor kod yang mudah digunakan dan percuma
SublimeText3 versi Cina
Versi Cina, sangat mudah digunakan
Hantar Studio 13.0.1
Persekitaran pembangunan bersepadu PHP yang berkuasa
Dreamweaver CS6
Alat pembangunan web visual
SublimeText3 versi Mac
Perisian penyuntingan kod peringkat Tuhan (SublimeText3)
Topik panas
1377
52
Cara memeriksa saiz meja oracle
Apr 11, 2025 pm 08:15 PM
Untuk menanyakan saiz ruang meja oracle, ikuti langkah -langkah berikut: Tentukan nama meja dengan menjalankan pertanyaan: pilih Tablespace_Name dari DBA_TableSpaces; Tanya saiz meja dengan menjalankan pertanyaan: pilih jumlah (bait) sebagai total_size, jumlah (bytes_free) sebagai tersedia_space, jumlah (bytes) - jumlah (bytes_free) sebagai digunakan_space dari dba_data_files di mana tablespace_
Cara mengimport pangkalan data oracle
Apr 11, 2025 pm 08:06 PM
Kaedah Import Data: 1. Gunakan utiliti SQLLoader: Sediakan fail data, buat fail kawalan, dan jalankan SQLLoader; 2. Gunakan alat IMP/EXP: data eksport, data import. Petua: 1. Disyorkan SQL*loader untuk set data besar; 2. Jadual sasaran harus wujud dan perlawanan definisi lajur; 3. Selepas mengimport, integriti data perlu disahkan.
Cara membuat jadual di oracle
Apr 11, 2025 pm 08:00 PM
Mewujudkan Jadual Oracle melibatkan langkah -langkah berikut: Gunakan sintaks Create Table untuk menentukan nama jadual, nama lajur, jenis data, kekangan, dan nilai lalai. Nama jadual harus ringkas dan deskriptif, dan tidak boleh melebihi 30 aksara. Nama lajur hendaklah menjadi deskriptif, dan jenis data menentukan jenis data yang disimpan dalam lajur. Kekangan tidak null memastikan bahawa nilai null tidak dibenarkan dalam lajur, dan klausa lalai menentukan nilai lalai untuk lajur. Kekangan utama utama untuk mengenal pasti rekod unik jadual. Kekangan utama asing menentukan bahawa lajur dalam jadual merujuk kepada kunci utama dalam jadual lain. Lihat penciptaan pelajar jadual sampel, yang mengandungi kunci utama, kekangan unik, dan nilai lalai.
Cara menyahpasang pemasangan Oracle gagal
Apr 11, 2025 pm 08:24 PM
Nyahpasang Kaedah untuk kegagalan pemasangan Oracle: Tutup Perkhidmatan Oracle, Padam Fail Program Oracle dan Kekunci Pendaftaran, Nyahpasang pembolehubah persekitaran Oracle, dan mulakan semula komputer. Jika penyahpasang gagal, anda boleh menyahpasang secara manual menggunakan alat penyahpasang Oracle Universal.
Cara melihat contoh nama oracle
Apr 11, 2025 pm 08:18 PM
Terdapat tiga cara untuk melihat nama contoh di Oracle: Gunakan "sqlplus" dan "pilih instance_name dari v $ instance;" Perintah pada baris arahan. Gunakan "pertunjukan instance_name;" Perintah dalam SQL*Plus. Semak Pembolehubah Alam Sekitar (ORACLE_SID pada Linux) melalui Pengurus Tugas Sistem Operasi, Pengurus Oracle Enterprise, atau melalui sistem operasi.
Cara menyampaikan semula oracle
Apr 11, 2025 pm 07:33 PM
Oracle menyediakan pelbagai kaedah pertanyaan deduplikasi: Kata kunci yang berbeza mengembalikan nilai yang unik untuk setiap lajur. Kumpulan oleh klausa mengumpulkan hasil dan mengembalikan nilai tidak berulang bagi setiap kumpulan. Kata kunci yang unik digunakan untuk membuat indeks yang mengandungi hanya baris unik, dan pertanyaan indeks akan secara automatik deduplicate. Fungsi row_number () memberikan nombor unik dan menapis hasil yang mengandungi hanya baris 1. Min () atau max () mengembalikan nilai tidak berulang dari lajur angka. Operator Intersect mengembalikan nilai -nilai bersama kedua -dua set hasil (tiada pendua).
Cara menyulitkan pandangan oracle
Apr 11, 2025 pm 08:30 PM
Penyulitan Oracle View membolehkan anda menyulitkan data dalam pandangan, dengan itu meningkatkan keselamatan maklumat sensitif. Langkah -langkah termasuk: 1) mewujudkan kunci penyulitan induk (MEK); 2) mencipta pandangan yang disulitkan, menyatakan pandangan dan MEK untuk disulitkan; 3) Memberi kuasa pengguna untuk mengakses pandangan yang disulitkan. Bagaimana pandangan yang disulitkan berfungsi: Apabila permintaan pengguna untuk paparan yang disulitkan, Oracle menggunakan MEK untuk menyahsulit data, memastikan bahawa hanya pengguna yang diberi kuasa dapat mengakses data yang boleh dibaca.
Cara Mendapatkan Masa di Oracle
Apr 11, 2025 pm 08:09 PM
Terdapat kaedah berikut untuk mendapatkan masa di Oracle: Current_TimeStamp: Mengembalikan masa sistem semasa, tepat untuk beberapa saat. SystimeStamp: Lebih tepat daripada Current_TimeStamp, kepada nanodekonda. SYSDATE: Mengembalikan tarikh sistem semasa, tidak termasuk bahagian masa. To_char (sysdate, 'yyy-mm-dd hh24: mi: ss'): Menukar tarikh dan masa sistem semasa ke format tertentu. Ekstrak: Ekstrak bahagian tertentu dari nilai masa, seperti tahun, bulan, atau jam.
