Home » RDBMS Server » Server Administration » 04030 URGENT PLEASE
04030 URGENT PLEASE [message #217765] Mon, 05 February 2007 06:16 Go to next message
zuhair
Messages: 12
Registered: February 2007
Location: DUBAI
Junior Member

I GOT THIS ERROR MESSAGE IN LOG FILE and this error happend every 2 hour

Errors in file e:\oracle\product\10.1.0\admin\dbtest\bdump\dbtest_cjq0_3740.trc:
ORA-00604: Message 604 not found; No message file for product=RDBMS, facility=ORA; arguments: [1]
ORA-04030: Message 4030 not found; No message file for product=RDBMS, facility=ORA; arguments: [8192] [sort subheap] [sort key]

Mon Feb 05 15:07:18 2007
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
Mon Feb 05 15:07:18 2007
kkjcre1p: unable to spawn jobq slave process

ANY HELP I WILL BE Thankful ***********************************************************

THIS IS THE PARAMETER I USED

processes = 300
sessions = 335
timed_statistics = TRUE
license_max_sessions = 10000
sga_max_size = 419430400
__shared_pool_size = 159383552
shared_pool_size = 159383552
__large_pool_size = 29360128
large_pool_size = 29360128
__java_pool_size = 29360128
java_pool_size = 29360128
shared_pool_reserved_size= 40000000
nls_language = ARABIC
nls_sort = BINARY
nls_date_language = AMERICAN
nls_date_format = DD-MON-RRRR
nls_currency = I.:1.
nls_numeric_characters = .,
nls_calendar = GREGORIAN
nls_dual_currency = I.:1.
nls_comp = BINARY
sga_target = 0
control_files = E:\ORACLE\PRODUCT\10.1.0\DB_1\DBTEST\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.1.0\DB_1\DBTEST\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.1.0\DB_1\DBTEST\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 159383552
db_cache_size = 159383552
compatible = 10.1.0.2.0
log_buffer = 3145728
log_checkpoint_interval = 10000
db_files = 255
db_file_multiblock_read_count= 8
db_recovery_file_dest = E:\oracle\product\10.1.0\flash_recovery_area
db_recovery_file_dest_size= 2147483648
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 900
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP)(DISPATCHERS=2)
shared_servers = 2
max_shared_servers = 3
max_dispatchers = 2
circuits = 100
shared_server_sessions = 100
local_listener = DBTEST
utl_file_dir = *
job_queue_processes = 2
background_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\DBTEST\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\DBTEST\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\DBTEST\CDUMP
audit_trail = FALSE
sort_area_size = 33333
sort_area_retained_size = 65536
db_name = DBTEST
open_cursors = 5000
optimizer_mode = RULE
query_rewrite_enabled = FALSE
pga_aggregate_target = 209715200
workarea_size_policy = AUTO
Re: 04030 URGENT PLEASE [message #217790 is a reply to message #217765] Mon, 05 February 2007 09:35 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Please explain why it is urgent for me to solve this problem for you?
Re: 04030 URGENT PLEASE [message #217946 is a reply to message #217790] Tue, 06 February 2007 03:18 Go to previous messageGo to next message
zuhair
Messages: 12
Registered: February 2007
Location: DUBAI
Junior Member

dear Sir,
now days we tray to make Agreements with other bank ,
and befor we transfer the new product to live we want to make it in test environment but the test DB cut every 2 hour and that give a bad feel ,

thanks & regards
Re: 04030 URGENT PLEASE [message #218021 is a reply to message #217946] Tue, 06 February 2007 07:51 Go to previous messageGo to next message
zuhair
Messages: 12
Registered: February 2007
Location: DUBAI
Junior Member

now i get this new error , any help
thanks




Errors in file e:\oracle\product\10.1.0\admin\dbtest\bdump\dbtest_cjq0_3152.trc:
ORA-00604: Message 604 not found; No message file for product=RDBMS, facility=ORA; arguments: [1]
ORA-04030: Message 4030 not found; No message file for product=RDBMS, facility=ORA; arguments: [8192] [sort subheap] [sort key]

skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
Re: 04030 URGENT PLEASE [message #218027 is a reply to message #218021] Tue, 06 February 2007 08:15 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Have you open iTAR for above issue.
contact Oracle Support.

regards
Taj
Re: 04030 URGENT PLEASE [message #218066 is a reply to message #217765] Tue, 06 February 2007 11:42 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
cjq0
Job queue processes are used for batch processing. The CJQ0 process dynamically spawns job queue slave processes (J000...J999) to run the jobs.


I suspect that 1 or more jobs exist which are throwing these errors.
You need to identify the jobs & deduce what they are attempting to do 7 either fix them or remove them.
You might find clues in the trace files being produced.
Previous Topic: Error Messages
Next Topic: Oracle 10g Installation - Sun 5.10 - Kernel Parameters
Goto Forum:
  


Current Time: Fri Dec 09 07:59:17 CST 2016

Total time taken to generate the page: 0.16794 seconds