Oracle11gr2没有spfile和pfile怎么处理
想修改process连接数,发现没有spfile
create spfile from pfile
发现pfile也没有!!!!
shutdown immediate
SQL> startup nomount pfile=‘/data/oracle/product/11.2.0.4/db_1/dbs/initFUND.ora’;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2220200 bytes
Variable Size 2298482520 bytes
Database Buffers 1962934272 bytes
Redo Buffers 12144640 bytes
SQL> alter database mount;
SQL> alter database open;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
READ WRITE
SQL> show parameter pfile;
NAME TYPE VALUE
spfile string
SQL> !ls $ORACLE_HOME/dbs/
hc_FUND.dat init.ora init FUND.ora lkPYFUND ora_control1 ora_control2 pwdFUND spfileFUND.ora
发现已经有spfile
SQL> shutdown immedate;
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
SQL> alter system set processes = 1500;