|
折騰了好多天，費了好大勁，終于在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 <tablespace_name> ADD TEMPFILE
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
本文出自：億恩科技【m.czbl888.cn】
服務器租用/服務器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質保障！--億恩科技[ENKJ.COM]
|
0371-60135900
京公網安備41019702002023號
香港服務器租用
美國服務器租用
電信骨干機房
聯通骨干機房
