Oracle starts init. oraspfilepfile

When I got off work, the company's database was suddenly blocked. A buf table could not extract more than 20 million data and changed the program. The effect was not obvious. Because I have restarted it before.

When I got off work, the company's database was suddenly blocked. A buf table could not extract more than 20 million data and changed the program. The effect was not obvious. Because I have restarted it before.

When I got off work, the company's database was suddenly blocked. A buf table could not extract more than 20 million data and changed the program. The effect was not obvious. Since Oracle was restarted once before, I still want to restart oracle this time because the data is what the customer wants to send out, which is urgent, the manager went to the data center and restarted oracle. I don't know how he restarts. I only know that oracle cannot be restarted .. That phone number .. That's the urge ..

> Cmd

> Sqlplus sys/*** as sysdba

SQL> startup

ORA-00093: _ shared_pool_reserved_min_alloc must be between 4000 and 0

SQL>

Then I found one of

Pga_aggregate_taarget = 200 M

.....

Db_cache_size = 200 M

....

Shared_pool_size = 200 M

..

A init w. ora file, I don't know where to find it. I changed the three parameters to the previous one, changed them back, started or reported the above error, and the other error was:

SQL> startup

ORA-00821: Specified value of sga_target 280 M is too small, needs to be at least 692 M

SQL>

D: \ oracle \ product \ 10.2.0 \ db_1 \ admin \ orclyxkj \ pfile \ init. ora.4142011856

######################################## ######################################
# Copyright (c) 1991,200 1, 2002 by Oracle Corporation
######################################## ######################################

######################################## ###
# SGA Memory
######################################## ###
Sga_target = 890455552

This error occurs. I found the following file and changed sga_target = 890455552 (previously sga_target = 290455552), which is increased by 4 times, But it is strange that, including the above question, no matter how many parameters you change, the error is the same every time he reports. The above mentioned is at least 4000. I changed and, and I still reported the error. Now ,, since the original parameters have increased by 4 times, the same error is still reported, so I don't think these files work. Then I asked the experts in the group to solve the problem:

1. Self-built an oracle configuration file for init. ora (wherever you like, I put it under the C-drive root directory ):

Orclyxkj. _ db_cache_size = 192937984
Orclyxkj. _ java_pool_size = 4194304
Orclyxkj. _ large_pool_size = 4194304
Orclyxkj. _ shared_pool_size = 83886080
Orclyxkj. _ streams_pool_size = 0
*. Audit_file_dest = 'd: \ oracle \ product \ 10.2.0 \ db_1/admin/orclyxkj/adump'
*. Background_dump_dest = 'd: \ oracle \ product \ 10.2.0 \ db_1/admin/orclyxkj/bdump'
*. Compatible = '10. 2.0.1.0'
*. Control_files = 'd: \ oracle \ product \ 10.2.0 \ oradata \ orclyxkj \ control01.ctl ', 'd: \ oracle \ product \ 10.2.0 \ oradata \ orclyxkj \ control02.ctl', 'd: \ oracle \ product \ 10.2.0 \ oradata \ orclyxkj \ control03.ctl'
*. Core_dump_dest = 'd: \ oracle \ product \ 10.2.0 \ db_1/admin/orclyxkj/cdump'
*. Db_block_size = 8192
*. Db_cache_size = 188743680
*. Db_domain =''
*. Db_file_multiblock_read_count = 16
*. Db_name = 'orclyxkj'
*. Db_recovery_file_dest = 'd: \ oracle \ product \ 10.2.0 \ db_1/flash_recovery_area'
*. Db_recovery_file_dest_size = 2147483648
*. Dispatchers = '(PROTOCOL = TCP) (SERVICE = orclyxkjXDB )'
*. Job_queue_processes = 10
*. Open_cursors = 300
*. Pga_aggregate_target = 96468992
*. Processses = 150
*. Remote_login_passwordfile = 'clusive'
*. Sga_target = 1073741824 # The parameter is very small before it is started and an error is reported. Therefore, the parameter is increased to 2 GB in memory and 1 GB in memory.
*. Shared_pool_size = 0 # change the number of pools to 0 (I don't know why, but I will study it later)
*. Undo_management = 'auto'
*. Undo_tablespace = 'undotbs1'
*. User_dump_dest = 'd: \ oracle \ product \ 10.2.0 \ db_1/admin/orclyxkj/udump'

2. When starting:

SQL> startup pfile = c: \ init. ora

Then we found that oracle could be enabled! You can query it in SQL> below. However, this does not mean that oracle can be accessed through pl/SQL.

In addition, if you do not execute this statement before, pl/SQL will never be able to access oracle. After the execution, you can finally access:

SQL> create spfile from pfile = 'C: \ init. ora'

Note: The path after pfile = must be enclosed in single quotes. Otherwise, the "invalied file name" error is reported.

3. Configure the listener.

Open the Net Configration listening ent of oracle to delete the former listener, create a new listener, or directly configure the existing listener.

If you create a listener:

Oracle Net Configration guest ENT -- local Net service name configuration -- add -- service name (self-written, generally the same as the database name orclyxkj) -- TCP -- Host Name: (127.0.0.1) -- Do not test -- network service name (same as the previously set service name by default) -- specify the path to db_1 (D: \ oracle \ product \ 10.2.0 \ db_1)

If you change the old listener:

On the Oracle Net Manager page:

Local -- service name -- orclyxkj (your server name) --

-- Service ID:

Service name: orclyxkj

SID: (Gray, cannot be filled)

Connection Type: default database settings

-- Address Configuration:

Address 1:

Protocol: TCP/IP

Host Name: 192.168.1.X)

Port: XXXX (1521 by default)

------- Listener

LISTENER:

Address 1, which is the same as the above configuration. Save the configuration and configure the listener.

4. Enable the service:

My computer-Manage-services and applications-services (two oracle services need to be started ):

OracleOraDb10g_home1TNSListener(If the error "termination outside process" is reported during the startup, configure the listener correctly)

OracleServiceORCLYXKJ

These two services are enabled normally. Okay, you can access oracle normally through pl/SQL!

Excellent. I got it at half past four! Why is sga_target written? I want to know more!