Re: How to increase MAX number of connections for Oracle DB server?

On Feb 2, 1:44 pm, "jshen...._at_gmail.com" <jshen...._at_gmail.com> wrote:
> In pfile initp65db.ora , the configuration is : (should I just change
> parameter process=128 to 1200 ?)
>
> ......
>
> control_files = ("/oracle/oradata/pin65db/control/rlvcontrol01", "/
> oracle/oradata/pin65db/control/rlvcontrol02", "/oracle/oradata/pi
> n65db/control/rlvcontrol03")
>
> #log_file_name_convert = ("/oracle/oradata/pindb-stdby","/oracle/
> oradata/pindb")
> #db_file_name_convert = ("/oracle/oradata/pindb-stdby","/oracle/
> oradata/pindb")
>
> open_cursors = 500
> max_enabled_roles = 30
> db_block_buffers = 1200000
>
> #shared_pool_size = 500000000
> shared_pool_size = 600000000
>
> #large_pool_size = 614400
> large_pool_size = 30M
> java_pool_size = 0
>
> log_checkpoint_interval = 10000
> log_checkpoint_timeout = 1800
>
> processes = 128

Either you ran the show parameter commands against a different database or this is not the init file used by your database - see the line above.

>
> log_buffer = 5242880
>
> # audit_trail = false # if you want auditing
> # timed_statistics = false # if you want timed statistics
> # max_dump_file_size = 10000 # limit trace file size to 5M each
>
> # Uncommenting the lines below will cause automatic archiving if
> archiving has
> # been enabled using ALTER DATABASE ARCHIVELOG.
> # log_archive_start = true
> # log_archive_dest_1 = "location=/oracle/app/oracle/admin/pindb/arch"
> # log_archive_format = arch_%t_%s.arc
>
> log_archive_start = true
> log_archive_dest_1 = "location=/arch/pin65db"
> log_archive_format = arch_%t_%s.arc
>
> #DBCA uses the default database value (30) for max_rollback_segments
> #100 rollback segments (or more) may be required in the future
> #Uncomment the following entry when additional rollback segments are
> created and made online
> #max_rollback_segments = 101
> # If using private rollback segments, place lines of the following
> # form in each of your instance-specific init.ora files:
>
> rollback_segments =
> (PINROLL00,PINROLL01,PINROLL02,PINROLL03,PINROLL04,PINROLL05,PINROLL06,PINR­OLL07,PINROLL08,PINROLL09,PINROLL10,P
> INROLL11,PINROLL12,PINROLL13,PINROLL14,PINROLL15,PINROLL16,PINROLL17,PINROL­L18,PINROLL19,PINROLL20,PINROLL21,PINROLL22,PINROLL23,PIN
> ROLL24,PINROLL25,PINROLL26,PINROLL27,PINROLL28,PINROLL29,PINROLL30,PINROLL3­1,PINROLL32,PINROLL33,PINROLL34,PINROLL35,PINROLL36,PINRO
> LL37,PINROLL38,PINROLL39,PINROLL40,PINROLL41,PINROLL42,PINROLL43,PINROLL44,­PINROLL45,PINROLL46,PINROLL47,PINROLL48,PINROLL49,PINROLL
> 50,PINROLL51,PINROLL52,PINROLL53,PINROLL54,PINROLL55,PINROLL56,PINROLL57,PI­NROLL58,PINROLL59,PINROLL60,PINROLLBIG,PINROLL61,PINROLL6
> 2,PINROLL63,PINROLL64,PINROLL65,PINROLL66,PINROLL67,PINROLL68,PINROLL69,PIN­ROLL70,PINROLL71,PINROLL72,PINROLL73,PINROLL74,PINROLL75,
> PINROLL76,PINROLL77,PINROLL78,PINROLL79,PINROLL80,PINROLL81,PINROLL82,PINRO­LL83,PINROLL84,PINROLL85,PINROLL86,PINROLL87,PINROLL88,PI
> NROLL89,PINROLL90,PINROLL91,PINROLL92,PINROLL93,PINROLL94,PINROLL95,PINROLL­96,PINROLL97,PINROLL98,PINROLL99)
>
> # Global Naming -- enforce that a dblink has same name as the db it
> connects to
> global_names = true
>
> # Uncomment the following line if you wish to enable the Oracle Trace
> product
> # to trace server activity. This enables scheduling of server
> collections
> # from the Oracle Enterprise Manager Console.
> # Also, if the oracle_trace_collection_name parameter is non-null,
> # every session will write to the named collection, as well as
> enabling you
> # to schedule future collections from the console.
> # oracle_trace_enable = true
>
> # define directories to store trace and alert files
> background_dump_dest = /oracle/app/oracle/admin/pin65db/bdump
> core_dump_dest = /oracle/app/oracle/admin/pin65db/cdump
> #Uncomment this parameter to enable resource management for your
> database.
> #The SYSTEM_PLAN is provided by default with the database.
> #Change the plan name if you have created your own resource plan.#
> resource_manager_plan = system_plan
> user_dump_dest = /oracle/app/oracle/admin/pin65db/udump
>
> db_block_size = 4096
> remote_login_passwordfile = exclusive
>
> os_authent_prefix = ""
>
> compatible = "8.1.0"
> sort_area_size = 65536
> sort_area_retained_size = 65536
>
> disk_asynch_io = TRUE
> db_files=1024
> #lock_sga=true
> db_block_lru_latches=12
> audit_trail = false
> transaction_auditing = false
> optimizer_mode = rule
> db_file_multiblock_read_count = 16
> dbwr_io_slaves=4
> parallel_execution_message_size=8192
> sort_multiblock_read_count = 8
> UTL_FILE_DIR=/oracle/migrate
Received on Fri Feb 02 2007 - 16:22:00 CST