ORA-12500,無法啟動專用進(jìn)程

406443027

oracle log：
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
  processes                = 300
  sessions                 = 335
  __shared_pool_size       = 83886080
  __large_pool_size        = 4194304
  __java_pool_size         = 8388608
  nls_language             = SIMPLIFIED CHINESE
  nls_territory            = CHINA
  sga_target               = 289406976
  control_files            = D:\ORACLE\PRODUCT\10.1.0\ORADATA\MY\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.1.0\ORADATA\MY\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.1.0\ORADATA\MY\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 188743680
  compatible               = 10.1.0.2.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = D:\oracle\product\10.1.0\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=myXDB)
  job_queue_processes      = 10
  background_dump_dest     = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MY\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MY\UDUMP
  core_dump_dest           = D:\ORACLE\PRODUCT\10.1.0\ADMIN\MY\CDUMP
  sort_area_size           = 65536
  db_name                  = my
  open_cursors             = 300
  pga_aggregate_target     = 95420416
Mon Jun 21 01:02:16 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
PMON started with pid=2, OS id=1096
DBW0 started with pid=4, OS id=1904
LGWR started with pid=5, OS id=284
CKPT started with pid=6, OS id=784
SMON started with pid=7, OS id=600
CJQ0 started with pid=9, OS id=776
MMAN started with pid=3, OS id=744
Mon Jun 21 01:02:21 2010
alter database mount exclusive
RECO started with pid=8, OS id=804
Mon Jun 21 01:02:21 2010
Controlfile identified with block size 16384
Mon Jun 21 01:02:25 2010
Setting recovery target incarnation to 2
Mon Jun 21 01:02:25 2010
Successful mount of redo thread 1, with mount id 1037880157
Mon Jun 21 01:02:25 2010
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Jun 21 01:02:26 2010
alter database open
Mon Jun 21 01:02:26 2010
Beginning crash recovery of 1 threads
attempting to start a parallel recovery with 2 processes
parallel recovery started with 2 processes
Mon Jun 21 01:02:26 2010
Started first pass scan
Mon Jun 21 01:02:27 2010
Completed first pass scan
4867 redo blocks read, 600 data blocks need recovery
Mon Jun 21 01:02:28 2010
Started redo application at
Thread 1: logseq 5, block 10017, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.1.0\ORADATA\MY\REDO01.LOG
Mon Jun 21 01:02:29 2010
Completed redo application
Mon Jun 21 01:02:30 2010
Completed crash recovery at
Thread 1: logseq 5, block 14884, scn 0.348205
600 data blocks read, 600 data blocks written, 4867 redo blocks read
Mon Jun 21 01:02:31 2010
Thread 1 advanced to log sequence 6
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 6
  Current log# 2 seq# 6 mem# 0: D:\ORACLE\PRODUCT\10.1.0\ORADATA\MY\REDO02.LOG
Successful open of redo thread 1
Mon Jun 21 01:02:32 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 21 01:02:32 2010
SMON: enabling cache recovery
Mon Jun 21 01:02:34 2010
Successfully onlined Undo Tablespace 1.
Mon Jun 21 01:02:34 2010
SMON: enabling tx recovery
Mon Jun 21 01:02:34 2010
Database Characterset is ZHS16GBK
Mon Jun 21 01:02:35 2010
Published database character set on system events channel
Mon Jun 21 01:02:35 2010
All processes have switched to database character set
Mon Jun 21 01:02:38 2010
Starting background process QMNC
QMNC started with pid=15, OS id=1552
Mon Jun 21 10:47:40 2010
replication_dependency_tracking turned off (no async multimaster replication found)
Mon Jun 21 10:47:41 2010
Starting background process MMON
Starting background process MMNL
MMON started with pid=16, OS id=604
MMNL started with pid=17, OS id=616
Mon Jun 21 10:47:43 2010
Completed: alter database open
Mon Jun 21 10:47:55 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.

406443027

在創(chuàng)建services的時候，測試連接過程中一直報 ORA-12500，無法為服務(wù)提供專用進(jìn)程，使用sql developer連接也報同樣的錯誤;
SQL> select count(*) from V$session;

  COUNT(*)
----------
        13
SQL> show parameter proces
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     300
SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 276M
sga_target                           big integer 276M

renxiao2003

1   .可能已經(jīng)達(dá)到連接的上限了,關(guān)掉幾個session再連.
2.   alter   system   set   process=150;但是如果內(nèi)存跟不上,照樣不行.

從你的參數(shù)設(shè)置來看，可能是因為內(nèi)存原因造成的。

sga_max_size                         big integer 276M
sga_target                           big integer 276M

可能是你的sga_max_size值小了點吧。不知道你的計算機(jī)的內(nèi)存是多大。

evaspring

1   .可能已經(jīng)達(dá)到連接的上限了,關(guān)掉幾個session再連.
2.   alter   system   set   process=150;但是如果 ...
renxiao2003 發(fā)表于 2010-06-22 08:47

    max不一定要比target大，但是 276M的也太小了吧，一般來說 target 的值最好設(shè)置為 系統(tǒng)內(nèi)存的 40% 左右 ~

renxiao2003

回復(fù) 4# evaspring


    你的速度也挺快。我剛才改了我的帖子了�？淳W(wǎng)上說的target是Oracle自動管理的！

evaspring

回復(fù)  evaspring


    你的速度也挺快。我剛才改了我的帖子了。看網(wǎng)上說的target是Oracle自動管理的！
renxiao2003 發(fā)表于 2010-06-22 08:53

    是的，現(xiàn)在ORACLE 推薦就是使用自動內(nèi)存管理。

406443027

回復(fù) 3# renxiao2003


    我的機(jī)器內(nèi)存就1G，1024*0.4，應(yīng)該400M左右我看看。啊！謝謝~