ORA-12514: TNS:监听程序当前无法识别连接描述符中请求的服务

因为系统升级了内存8G到16G，oracle数据库会出现无法识别出内存已经变大，重装oracle即可解决问题。

 

重启OracleServiceORCL服务。

  alter system set sga_max_size=500M SCOPE=SPFILE;

startup pfile='E:\oracle\product\11.2.0\dbhome_1\dbs\pfile01.ora'

SQL>create spfile from pfile;
SQL>shutdown immediate;
SQL>startup;

 

ORA-00823: Specified value of sga_target greater than sga_max_size

 

 

本人已经尝试，的确可以成功。

 

更改sga_max_size的时候不小心少加了单位'M'，结果遇到了ORA-00823导致数据库起不来。
1.根据pfile创建spfiel后，修改pfile中的sga_max_size参数
2.用pfile启动数据库，测试正常。
3.根据pfiel创建spfile
4.用spfile启动数据库。

 

SQL>ALTER SYSTEM SET sga_max_size = 4096 SCOPE=SPFILE;  -- 少写了一个M,害得数据库起不来

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup nomount
ORA-00823: Specified value of sga_target greater than sga_max_size

SQL> CREATE PFILE='/opt/ora11g/product/11.2.3/db_1/dbs/pfile01.ora' FROM SPFILE;
File created.

SQL> !
[oracle@oradb01 emd]$ vi /opt/ora11g/product/11.2.3/db_1/dbs/pfile01.ora

*.sga_max_size=4096 改为
*.sga_max_size=4096M

SQL> startup PFILE='/opt/ora11g/product/11.2.3/db_1/dbs/pfile01.ora' 
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size                  2266024 bytes
Variable Size            1681919064 bytes
Database Buffers         2583691264 bytes
Redo Buffers                7905280 bytes
Database mounted.
Database opened.
SQL> !
[oracle@oradb01 emd]$ cd /opt/ora11g/product/11.2.3/db_1/dbs/

[oracle@oradb01 dbs]$ cp spfileorcl.ora spfileorcl.ora_bak01

[oracle@oradb01 dbs]$ exit
exit

SQL> CREATE SPFILE='/opt/ora11g/product/11.2.3/db_1/dbs/spfileorcl.ora' FROM PFILE='/opt/ora11g/product/11.2.3/db_1/dbs/pfile01.ora';

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2235208 bytes
Variable Size            1677722808 bytes
Database Buffers         2583691264 bytes
Redo Buffers               12132352 bytes
Database mounted.
Database opened.

 要动态修改一定要用spfile启动。如果现在是用pfile启动，可以这样切换成spfile启动：
SQL>create spfile from pfile;
SQL>shutdown immediate;
SQL>startup;

转载于:https://www.cnblogs.com/Simeonwu/p/8516099.html