Shulou(Shulou.com)06/01 Report--

The picture above is the general architecture of the oracle system.

Today, suddenly all the terminal POS machines of the company could not be spent by card, and the finance room could not recharge. A lot of phone calls came over. The first reaction was that there was something wrong with the database. Log in to the database server. Sure enough, after sqlplus was connected, it kept asking for a user name, and a prompt popped up:

ERROR:

ORA-00020: maximum number of processes (150) exceeded

Enter user-name: sys

Enter password:

ERROR:

ORA-00020: maximum number of processes (150) exceeded

Enter user-name: sys

Enter password:

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

After thinking and analyzing for a while, I decisively killed the related processes of oracle through the task manager, and finally got in. Through research, the solutions are as follows:

Oracle@wu101:~ > sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 15 17:07:40 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > show parameter processes

NAME TYPE VALUE

-

Aq_tm_processes integer 1

Db_writer_processes integer 1

Gcs_server_processes integer 0

Global_txn_processes integer 1

Job_queue_processes integer 1000

Log_archive_max_processes integer 4

Processes integer 150

SQL > alter system set processes=1500 scope = spfile

System altered.

SQL > commit

Commit complete.

The command SQL > shutdown abort # is carefully executed. If it is in a production environment, it is better to use "shutdown immediate". Rookies are in their own environment, so they are forced to go offline so violently.

ORACLE instance shut down.

SQL > startup

ORACLE instance started.

Total System Global Area 1603411968 bytes

Fixed Size 2228784 bytes

Variable Size 1073745360 bytes

Database Buffers 520093696 bytes

Redo Buffers 7344128 bytes

Database mounted.

Database opened.

SQL > show parameter processes

NAME TYPE VALUE

-

Aq_tm_processes integer 1

Db_writer_processes integer 1

Gcs_server_processes integer 0

Global_txn_processes integer 1

Job_queue_processes integer 1000

Log_archive_max_processes integer 4

Processes integer 1500

The paths to the pfile and spfile of oracle on windows are in the following directory:

D:\ app\ Administrator\ product\ 11.2.0\ dbhome_1\ database

Today I would like to share with you an example of how to solve the oracle problem.

For example, when starting Oracle, it prompts "ORA-00600: internal error code, arguments" error?

SQL > startup

ORA-00600: internal error code, arguments: [ksunfy: too few sessions], [9504], [75040], [] "

Solution: the error here indicates that the values of Oracle's processes and sessions have been adjusted too high.

(1) to modify the values of processes and sessions, you can first create a new pfile through the existing problematic spfile. Because pfile is a text file, it can be opened. Use the following command to create vim INIThlecard.ORA under D:\ app\ Administrator\ product\ 11.2.0\ dbhome_1\ database, and then modify the values as follows:

* .processes=10000

* .sessions=10000

Save

(2) SQL > create spfile from pfile

File created.

SQL > startup

ORACLE instance started.

Total System Global Area 8.5516E+10 bytes

Fixed Size 2237776 bytes

Variable Size 8858372784 bytes

Database Buffers 7.6504E+10 bytes

Redo Buffers 151142400 bytes

Database mounted.

Database opened.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.