cancel
Showing results for 
Search instead for 
Did you mean: 

Installation very very slow Oracle linux Solman

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

At moment , the import java phase has been started but however the system is slow

thanks

danny

stefan_koehler
Active Contributor
0 Kudos

Hello Danny,

then use nmon to analyze if your system is using swap space, etc.

Regards

Stefan

Former Member
0 Kudos

Hello Thanks for all

The problem was solved, the hardware 's team found once problem between the server and the storage and they change the storage, After we started the installation again and this installation was faster.

Thanks

Danny

stefan_koehler
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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]