Oracle ORA-00119,ORA-00132 错误处理(二)

2014-11-24 18:07:44 · 作者: · 浏览: 1
*.job_queue_processes=10


*.local_listener='LISTENER_ODBP' --将改行注释掉或置空


*.open_cursors=300


*.pga_aggregate_target=94371840


*.processes=150


*.remote_login_passwordfile='EXCLUSIVE'


*.sga_target=285212672


*.undo_management='AUTO'


*.undo_tablespace='UNDOTBS1'


*.user_dump_dest='/u01/app/oracle/admin/odbp/udump'



SQL> startup nomount pfile='/u01/app/oracle/10g/dbs/initodbp.ora';


ORACLE instance started.



Total System Global Area 285212672 bytes


Fixed Size 1267068 bytes


Variable Size 150997636 bytes


Database Buffers 130023424 bytes


Redo Buffers 2924544 bytes



SQL> create spfile from pfile;



File created.



SQL> startup force;


ORACLE instance started.



Total System Global Area 285212672 bytes


Fixed Size 1267068 bytes


Variable Size 150997636 bytes


Database Buffers 130023424 bytes


Redo Buffers 2924544 bytes


Database mounted.


Database opened.