Dear all,
I met this problem,please see the attchment , if you know what happened ,please help me solve them.
When we start a session , it show message window:
................
cannot continue in <session name> (before program)...,
error 1018(bdb_errno 1018) on select.
................

Why are them?

Thanks and Best Regards!
Gavin

If you use oracle, then subtract 1000 and you get ORA-18 as an error.

Type in Unix: oerr ORA 18

and you get:

00018, 00000, "maximum number of sessions exceeded"
// *Cause: All session state objects are in use.
// *Action: Increase the value of the SESSIONS initialization parameter.

So by increasing the Sessions Parameter in your init file drastically and restarting your DB, the error should vanish! Alternatively you can increase the parameter processes, this should indirectly increase the number of permitted session.

Regards

OK,thanks, I have modified the parameter, and restart DB, it's ok, thank you very much!

Best solution is increase "Processes" parameter.
"Sessions" parameter depended on "Processes" parameter.

Best regards,
Ramil.

In AIX 5.3 with oracle 10 g where from will we be able to increase the sessions as well as processes in the Oracle Level

Thanxs in advance
Regards

Darpan

Dear all, thanks for ur reply, I want to know where is the "processes" file or "parameter" file?

Gavin

See pls $ORACLE_HOME/dbs/init<SID>.ora file
Regards,
Ramil

or the corresponding spfile, if you use one.

Dear Friends

how can i change the parameters
plz guide me

Thanks in advance

Regards
Neha



See pls $ORACLE_HOME/dbs/init<SID>.ora file
Regards,
Ramil

If you do not know how to change Oracle parameters, maybe its time to get a DBA on-board/help, changes to the Oracle parameters may render inoperable your instance! You have been warned, baanboard or its members can only provide advice, any actions done by you are your responsibility/risk.

Changes to parameters in Oracle are best done within Oracle, as a dba user, by using the SQL stament format of (the parameters can be seen by querying the v$parameter view):

alter system set <parameter_name>=<value> scope=both;

Search google for "alter system set" for further information, the scope=both makes the change in both spfile (binary) and memory. For non-dynamic parameters (like the process parameter), the change is not effective until the instance has been restarted.
To create the corresponding text file (init<SID>.ora file), run after the change a: create pfile from spfile;

So, to change a nr. of processes from 30 to 50, for example, you would issue the command:

alter system set process=50 scope=both;
create pfile from spfile;

A restart of the instance will be needed to make it effective. Notice that since the sessions and transactions parameters default values are calculated from the processes parameter, you may need to review these as well.
Google for any of the mentioned commands for further information.

Actually scope=both in 'alter system set...' command means that parameter is modified in memory (running Oracle instance, dynamic parameters) and spfile. You cannot directly modify pfile (the parameter file in text format) using SQL commands but you can edit it using a text editor.


alter system set <parameter_name>=<value> scope=both;

Search google for "alter system set" for further information, the scope=both makes the change in both spfile (binary) and pfile (text). For non-dynamic parameters (like the process parameter), the change is not effective until the instance has been restarted.