on 03-12-2010 4:20 PM
Hello
I have a question at moment I am installationing the solman in Linux red had 5.4 64 bits with 8 GB ram and 20 GBin swap, but the installation is very slow in the creation data base was around 3 hours and in the creation tablespace not finished yet and this process started around 10 hours ago.
Whats is the problem?? What do I check ? and What can I do for that this process will be faster??
Any suggestion
Thanks
Danny
Edited by: Danny Sanchez on Mar 12, 2010 5:20 PM
Edited by: Danny Sanchez on Mar 12, 2010 5:21 PM
At moment , the import java phase has been started but however the system is slow
thanks
danny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Danny,
could you please post the content of the alert.log file (location /oracle/<SID>/saptrace/background).
Please be sure to post that content in the code tag otherwise it is not really nice to read.
To analyze any OS related issues - you can use nmon (http://www.ibm.com/developerworks/aix/library/au-analyze_aix/).
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
this is the log from importa java starts:
CREATE TABLESPACE SYSTEM DATAFILE '/oracle/SOL/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND
ON NEXT 20M MAXSIZE 10000M LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ORA-1543 signalled during: CREATE TABLESPACE SYSTEM DATAFILE '/oracle/SOL/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE ...
Fri Mar 12 11:27:07 2010
Beginning log switch checkpoint up to RBA [0xb.2.10], SCN: 197196
Fri Mar 12 11:27:07 2010
Thread 1 advanced to log sequence 11 (LGWR switch)
Current log# 3 seq# 11 mem# 0: /oracle/SOL/origlogA/log_g13m1.dbf
Current log# 3 seq# 11 mem# 1: /oracle/SOL/mirrlogA/log_g13m2.dbf
Fri Mar 12 11:29:10 2010
Beginning log switch checkpoint up to RBA [0xc.2.10], SCN: 201318
Fri Mar 12 11:29:10 2010
Thread 1 advanced to log sequence 12 (LGWR switch)
Current log# 4 seq# 12 mem# 0: /oracle/SOL/origlogB/log_g14m1.dbf
Current log# 4 seq# 12 mem# 1: /oracle/SOL/mirrlogB/log_g14m2.dbf
Fri Mar 12 11:31:53 2010
Beginning log switch checkpoint up to RBA [0xd.2.10], SCN: 205762
Fri Mar 12 11:31:53 2010
Thread 1 advanced to log sequence 13 (LGWR switch)
Current log# 1 seq# 13 mem# 0: /oracle/SOL/origlogA/log_g11m1.dbf
Current log# 1 seq# 13 mem# 1: /oracle/SOL/mirrlogA/log_g11m2.dbf
Fri Mar 12 11:32:29 2010
Thread 1 cannot allocate new log, sequence 14
Checkpoint not complete
Current log# 1 seq# 13 mem# 0: /oracle/SOL/origlogA/log_g11m1.dbf
Current log# 1 seq# 13 mem# 1: /oracle/SOL/mirrlogA/log_g11m2.dbf
Fri Mar 12 11:32:37 2010
Completed checkpoint up to RBA [0xb.2.10], SCN: 197196
Fri Mar 12 11:32:37 2010
Beginning log switch checkpoint up to RBA [0xe.2.10], SCN: 209613
Fri Mar 12 11:33:44 2010
Thread 1 advanced to log sequence 14 (LGWR switch)
Current log# 2 seq# 14 mem# 0: /oracle/SOL/origlogB/log_g12m1.dbf
Current log# 2 seq# 14 mem# 1: /oracle/SOL/mirrlogB/log_g12m2.dbf
Fri Mar 12 11:34:04 2010
Thread 1 cannot allocate new log, sequence 15
Checkpoint not complete
Current log# 2 seq# 14 mem# 0: /oracle/SOL/origlogB/log_g12m1.dbf
Current log# 2 seq# 14 mem# 1: /oracle/SOL/mirrlogB/log_g12m2.dbf
Fri Mar 12 11:34:18 2010
Completed checkpoint up to RBA [0xc.2.10], SCN: 201318
Fri Mar 12 11:36:32 2010
Beginning log switch checkpoint up to RBA [0xf.2.10], SCN: 213165
Fri Mar 12 11:36:32 2010
Thread 1 advanced to log sequence 15 (LGWR switch)
Current log# 3 seq# 15 mem# 0: /oracle/SOL/origlogA/log_g13m1.dbf
Current log# 3 seq# 15 mem# 1: /oracle/SOL/mirrlogA/log_g13m2.dbf
Fri Mar 12 11:39:30 2010
Thread 1 cannot allocate new log, sequence 16
Checkpoint not complete
Current log# 3 seq# 15 mem# 0: /oracle/SOL/origlogA/log_g13m1.dbf
Current log# 3 seq# 15 mem# 1: /oracle/SOL/mirrlogA/log_g13m2.dbf
Fri Mar 12 11:39:40 2010
Completed checkpoint up to RBA [0xd.2.10], SCN: 205762
Fri Mar 12 11:41:02 2010
Beginning log switch checkpoint up to RBA [0x10.2.10], SCN: 217769
Fri Mar 12 11:41:02 2010
Thread 1 advanced to log sequence 16 (LGWR switch)
Current log# 4 seq# 16 mem# 0: /oracle/SOL/origlogB/log_g14m1.dbf
Current log# 4 seq# 16 mem# 1: /oracle/SOL/mirrlogB/log_g14m2.dbf
Fri Mar 12 11:41:42 2010
Thread 1 cannot allocate new log, sequence 17
Checkpoint not complete
Current log# 4 seq# 16 mem# 0: /oracle/SOL/origlogB/log_g14m1.dbf
Current log# 4 seq# 16 mem# 1: /oracle/SOL/mirrlogB/log_g14m2.dbf
Fri Mar 12 11:43:57 2010
Completed checkpoint up to RBA [0xe.2.10], SCN: 209613
Fri Mar 12 11:45:01 2010
Beginning log switch checkpoint up to RBA [0x11.2.10], SCN: 221922
Fri Mar 12 11:45:01 2010
Thread 1 advanced to log sequence 17 (LGWR switch)
Current log# 1 seq# 17 mem# 0: /oracle/SOL/origlogA/log_g11m1.dbf
Current log# 1 seq# 17 mem# 1: /oracle/SOL/mirrlogA/log_g11m2.dbf
Fri Mar 12 11:47:33 2010
Thread 1 cannot allocate new log, sequence 18
Checkpoint not complete
Current log# 1 seq# 17 mem# 0: /oracle/SOL/origlogA/log_g11m1.dbf
Current log# 1 seq# 17 mem# 1: /oracle/SOL/mirrlogA/log_g11m2.dbf
Fri Mar 12 11:47:48 2010
Completed checkpoint up to RBA [0xf.2.10], SCN: 213165
Fri Mar 12 11:48:13 2010
Beginning log switch checkpoint up to RBA [0x12.2.10], SCN: 225543
Fri Mar 12 11:48:13 2010
Thread 1 advanced to log sequence 18 (LGWR switch)
Current log# 2 seq# 18 mem# 0: /oracle/SOL/origlogB/log_g12m1.dbf
Current log# 2 seq# 18 mem# 1: /oracle/SOL/mirrlogB/log_g12m2.dbf
Fri Mar 12 11:51:12 2010
Thread 1 cannot allocate new log, sequence 19
Checkpoint not complete
Current log# 2 seq# 18 mem# 0: /oracle/SOL/origlogB/log_g12m1.dbf
Current log# 2 seq# 18 mem# 1: /oracle/SOL/mirrlogB/log_g12m2.dbf
Fri Mar 12 11:52:38 2010
Completed checkpoint up to RBA [0x10.2.10], SCN: 217769
Fri Mar 12 11:52:51 2010
Beginning log switch checkpoint up to RBA [0x13.2.10], SCN: 228479
Fri Mar 12 11:52:51 2010
Thread 1 advanced to log sequence 19 (LGWR switch)
Current log# 3 seq# 19 mem# 0: /oracle/SOL/origlogA/log_g13m1.dbf
Current log# 3 seq# 19 mem# 1: /oracle/SOL/mirrlogA/log_g13m2.dbf
thanks
DAnny
Edited by: Danny Sanchez on Mar 13, 2010 4:15 PM
Edited by: Danny Sanchez on Mar 13, 2010 4:17 PM
CREATE TABLESPACE SYSTEM DATAFILE '/oracle/SOL/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND
ON NEXT 20M MAXSIZE 10000M LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ORA-1543 signalled during: CREATE TABLESPACE SYSTEM DATAFILE '/oracle/SOL/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE ...
Fri Mar 12 11:27:07 2010
Beginning log switch checkpoint up to RBA [0xb.2.10], SCN: 197196
Fri Mar 12 11:27:07 2010
Thread 1 advanced to log sequence 11 (LGWR switch)
Current log# 3 seq# 11 mem# 0: /oracle/SOL/origlogA/log_g13m1.dbf
Current log# 3 seq# 11 mem# 1: /oracle/SOL/mirrlogA/log_g13m2.dbf
Fri Mar 12 11:29:10 2010
Beginning log switch checkpoint up to RBA [0xc.2.10], SCN: 201318
Fri Mar 12 11:29:10 2010
Thread 1 advanced to log sequence 12 (LGWR switch)
Current log# 4 seq# 12 mem# 0: /oracle/SOL/origlogB/log_g14m1.dbf
Current log# 4 seq# 12 mem# 1: /oracle/SOL/mirrlogB/log_g14m2.dbf
Fri Mar 12 11:31:53 2010
Fri Mar 12 11:43:57 2010
Completed checkpoint up to RBA [0xe.2.10], SCN: 209613
Fri Mar 12 11:45:01 2010
Beginning log switch checkpoint up to RBA [0x11.2.10], SCN: 221922
Fri Mar 12 11:45:01 2010
Thread 1 advanced to log sequence 17 (LGWR switch)
Current log# 1 seq# 17 mem# 0: /oracle/SOL/origlogA/log_g11m1.dbf
Current log# 1 seq# 17 mem# 1: /oracle/SOL/mirrlogA/log_g11m2.dbf
Edited by: Danny Sanchez on Mar 13, 2010 6:36 PM
Fri Mar 12 11:47:33 2010
Thread 1 cannot allocate new log, sequence 18
Checkpoint not complete
Current log# 1 seq# 17 mem# 0: /oracle/SOL/origlogA/log_g11m1.dbf
Current log# 1 seq# 17 mem# 1: /oracle/SOL/mirrlogA/log_g11m2.dbf
Fri Mar 12 11:47:48 2010
Completed checkpoint up to RBA [0xf.2.10], SCN: 213165
Fri Mar 12 11:48:13 2010
Beginning log switch checkpoint up to RBA [0x12.2.10], SCN: 225543
Fri Mar 12 11:48:13 2010
Thread 1 advanced to log sequence 18 (LGWR switch)
Current log# 2 seq# 18 mem# 0: /oracle/SOL/origlogB/log_g12m1.dbf
Current log# 2 seq# 18 mem# 1: /oracle/SOL/mirrlogB/log_g12m2.dbf
Fri Mar 12 11:51:12 2010
Thread 1 cannot allocate new log, sequence 19
Checkpoint not complete
Current log# 2 seq# 18 mem# 0: /oracle/SOL/origlogB/log_g12m1.dbf
Current log# 2 seq# 18 mem# 1: /oracle/SOL/mirrlogB/log_g12m2.dbf
Fri Mar 12 11:52:38 2010
Completed checkpoint up to RBA [0x10.2.10], SCN: 217769
Fri Mar 12 11:52:51 2010
Beginning log switch checkpoint up to RBA [0x13.2.10], SCN: 228479
Fri Mar 12 11:52:51 2010
Thread 1 advanced to log sequence 19 (LGWR switch)
Current log# 3 seq# 19 mem# 0: /oracle/SOL/origlogA/log_g13m1.dbf
Current log# 3 seq# 19 mem# 1: /oracle/SOL/mirrlogA/log_g13m2.dbf
Thanks this is the log
Regards
Sorry Stafan this es the alert.log update:
Sat Mar 13 00:13:17 2010
Starting ORACLE instance (normal)
Sat Mar 13 00:13:17 2010
Specified value of sga_max_size is too small, bumping to 2332033024
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
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.4.0.
System parameters with non-default values:
processes = 80
sessions = 160
event = 10191 trace name context forever, level 1
sga_max_size = 2332033024
shared_pool_size = 1140850688
shared_pool_reserved_size= 113019715
filesystemio_options = setall
control_files = /oracle/SOL/origlogA/cntrl/cntrlSOL.dbf, /oracle/SOL/origlogB/cntrl/cntrlSOL.dbf, /oracle/SOL/sapdata1/cntrl/cntrlSOL.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1140850688
compatible = 10.2.0
log_archive_dest = /oracle/SOL/oraarch/SOLarch
log_buffer = 14242816
log_checkpoint_interval = 0
db_files = 254
log_checkpoints_to_alert = TRUE
dml_locks = 4000
replication_dependency_tracking= FALSE
undo_management = AUTO
undo_tablespace = PSAPUNDO
inmemory_undo = FALSE
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
parallel_execution_message_size= 16384
tablelookup_prefetch_size= 0
background_dump_dest = /oracle/SOL/saptrace/background
user_dump_dest = /oracle/SOL/saptrace/usertrace
core_dump_dest = /oracle/SOL/saptrace/background
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = SOL
open_cursors = 800
sortelimination_cost_ratio= 10
btree_bitmap_plans = FALSE
star_transformation_enabled= true
query_rewrite_enabled = false
indexjoin_enabled = FALSE
optimpeek_user_binds = FALSE
pga_aggregate_target = 1506929541
optimizermjc_enabled = FALSE
Sat Mar 13 00:13:19 2010
CREATE DATABASE SOL CONTROLFILE REUSE MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 254 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE '/oracle/SOL/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE '/oracle/SOL/sapdata1/temp_1/temp.data1' SIZE 570M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/SOL/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M SYSAUX DATAFILE '/oracle/SOL/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
LOGFILE GROUP 1 ('/oracle/SOL/origlogA/log_g11m1.dbf',
'/oracle/SOL/mirrlogA/log_g11m2.dbf') SIZE 50M REUSE ,
GROUP 2 ('/oracle/SOL/origlogB/log_g12m1.dbf',
'/oracle/SOL/mirrlogB/log_g12m2.dbf') SIZE 50M REUSE ,
GROUP 3 ('/oracle/SOL/origlogA/log_g13m1.dbf',
'/oracle/SOL/mirrlogA/log_g13m2.dbf') SIZE 50M REUSE ,
GROUP 4 ('/oracle/SOL/origlogB/log_g14m1.dbf',
'/oracle/SOL/mirrlogB/log_g14m2.dbf') SIZE 50M REUSE
Sat Mar 13 00:18:53 2010
Database mounted in Exclusive Mode
Sat Mar 13 00:53:55 2010
Successful mount of redo thread 1, with mount id 1301565343
Assigning activation ID 1301565343 (0x4d944f9f)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /oracle/SOL/origlogA/log_g11m1.dbf
Current log# 1 seq# 1 mem# 1: /oracle/SOL/mirrlogA/log_g11m2.dbf
Successful open of redo thread 1
Sat Mar 13 00:53:55 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Mar 13 00:53:55 2010
SMON: enabling cache recovery
Sat Mar 13 00:53:55 2010
create tablespace SYSTEM datafile '/oracle/SOL/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
EXTENT MANAGEMENT LOCAL online
Sat Mar 13 00:53:58 2010
Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.3.0]
Sat Mar 13 01:05:56 2010
Completed: create tablespace SYSTEM datafile '/oracle/SOL/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
EXTENT MANAGEMENT LOCAL online
The last ines of log
Sat Mar 13 06:32:48 2010
Completed: ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/SOL/sapdata2/sr3_8/sr3.data8' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Sat Mar 13 06:32:49 2010
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/SOL/sapdata2/sr3_9/sr3.data9' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Sat Mar 13 06:47:43 2010
Completed: ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/SOL/sapdata2/sr3_9/sr3.data9' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Sat Mar 13 06:47:44 2010
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/SOL/sapdata2/sr3_10/sr3.data10' SIZE 420M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Sat Mar 13 06:50:44 2010
Completed: ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/SOL/sapdata2/sr3_10/sr3.data10' SIZE 420M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Sat Mar 13 06:50:44 2010
CREATE TABLESPACE PSAPSR3701 DATAFILE '/oracle/SOL/sapdata3/sr3701_1/sr3701.data1' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO
Sat Mar 13 07:07:56 2010
Incremental checkpoint up to RBA [0xa.214b.0], current log tail at RBA [0xa.2cb6.0]
Sat Mar 13 07:56:13 2010
Incremental checkpoint up to RBA [0xa.2d1f.0], current log tail at RBA [0xa.2d2c.0]
Sat Mar 13 08:18:30 2010
Completed: CREATE TABLESPACE PSAPSR3701 DATAFILE '/oracle/SOL/sapdata3/sr3701_1/sr3701.data1' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO
Sat Mar 13 08:18:30 2010
ALTER TABLESPACE PSAPSR3701 ADD DATAFILE '/oracle/SOL/sapdata3/sr3701_2/sr3701.data2' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Edited by: Danny Sanchez on Mar 13, 2010 6:55 PM
Sat Mar 13 08:41:36 2010
Incremental checkpoint up to RBA [0xa.39f6.0], current log tail at RBA [0xa.3a02.0]
Sat Mar 13 09:28:08 2010
Incremental checkpoint up to RBA [0xa.40e0.0], current log tail at RBA [0xa.40f3.0]
Sat Mar 13 09:46:27 2010
Completed: ALTER TABLESPACE PSAPSR3701 ADD DATAFILE '/oracle/SOL/sapdata3/sr3701_2/sr3701.data2' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Sat Mar 13 09:46:27 2010
ALTER TABLESPACE PSAPSR3701 ADD DATAFILE '/oracle/SOL/sapdata3/sr3701_3/sr3701.data3' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Sat Mar 13 10:14:04 2010
Incremental checkpoint up to RBA [0xa.46be.0], current log tail at RBA [0xa.46c6.0]
Sat Mar 13 10:57:31 2010
Incremental checkpoint up to RBA [0xa.46fe.0], current log tail at RBA [0xa.470b.0]
Sat Mar 13 11:15:29 2010
Completed: ALTER TABLESPACE PSAPSR3701 ADD DATAFILE '/oracle/SOL/sapdata3/sr3701_3/sr3701.data3' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Sat Mar 13 11:15:30 2010
ALTER TABLESPACE PSAPSR3701 ADD DATAFILE '/oracle/SOL/sapdata3/sr3701_4/sr3701.data4' SIZE 1970M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Sat Mar 13 11:48:25 2010
Incremental checkpoint up to RBA [0xa.4c63.0], current log tail at RBA [0xa.4c74.0]
Sat Mar 13 12:38:25 2010
Incremental checkpoint up to RBA [0xa.51f3.0], current log tail at RBA [0xa.5200.0]
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.