-bash-4.1$ sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Mon Dec 8 11:43:29 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
SQL> exit
Disconnected
-bash-4.1$ cd $ORACLE_HOME
-bash-4.1$ cd dbs/
-bash-4.1$ ll
total 20
-rw-rw----. 1 oracle dba 1544 Dec 8 10:52 hc_XE.dat
-rwxr-xr-x. 1 oracle dba 2851 Aug 29 2011 init.ora
-rw-r-----. 1 oracle dba 24 Nov 11 11:42 lkXE
-rw-r----- 1 oracle dba 1536 Dec 8 10:50 orapwXE
-rw-r----- 1 oracle dba 2560 Dec 8 10:52 spfileXE.ora
-bash-4.1$
-bash-4.1$ cp spfileXE.ora spfileXE.ora.bkp
-bash-4.1$ ll
total 28
-rw-rw----. 1 oracle dba 1544 Dec 8 12:01 hc_XE.dat
-rwxr-xr-x 1 oracle dba 2851 Dec 8 11:54 init.ora
-rw-r-----. 1 oracle dba 24 Nov 11 11:42 lkXE
-rw-r----- 1 oracle dba 1536 Dec 8 10:50 orapwXE
-rw-r----- 1 oracle dba 881 Dec 8 11:57 spfileXE.ora
-rw-r----- 1 oracle dba 2560 Dec 8 11:56 spfileXE.ora.bkp
BEFORE EDIT
-bash-4.1$ cat spfileXE.ora.bkp
C"???3CC2XE.__db_cache_size=197132288
XE.__java_pool_size=4194304
XE.__large_pool_size=4194304
XE.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
XE.__pga_aggregate_target=272629760
XE.__sga_target=515899392
XE.__shared_io_pool_size=0
XE.__shared_pool_size=301989888
XE.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/XE/adump'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/XE/control.dbf'
*.db_name='XE'
*.DB_RECOVERY_FILE_DEST='/u01/app/oraclCC"e/fast_recovery_area'
*.DB_RECOVERY_FILE_DEST_SIZE=10G
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=XEXDB)'
*.job_queue_processes=4
*.local_listener='(ADDRESS = (PROTOCOL=TCP) (HOST=cacti.siltechconsult.com.br) (PORT=1522))'
*.memory_target=786432000
*.open_cursors=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=20
*.shared_servers=4
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
CC"GeCC"FeC-bash-4.1$
-bash-4.1$ vim spfileXE.ora
LATER EDIT
-bash-4.1$ cat spfileXE.ora
*.audit_file_dest='/u01/app/oracle/admin/XE/adump'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/XE/control.dbf'
*.db_name='XE'
*.DB_RECOVERY_FILE_DEST='/u01/app/oracle/fast_recovery_area'
*.DB_RECOVERY_FILE_DEST_SIZE=10G
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=XEXDB)'
*.job_queue_processes=4
*.local_listener='(ADDRESS = (PROTOCOL=TCP) (HOST=cacti.siltechconsult.com.br) (PORT=1522))'
*.memory_target=500M
*.open_cursors=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=20
*.shared_servers=4
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
-bash-4.1$
-bash-4.1$ pwd
/u01/app/oracle/product/11.2.0/xe/dbs
-bash-4.1$ sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Mon Dec 8 12:03:40 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup pfile='/u01/app/oracle/product/11.2.0/xe/dbs/spfileXE.ora';
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2228080 bytes
Variable Size 314572944 bytes
Database Buffers 201326592 bytes
Redo Buffers 3809280 bytes
Database mounted.
Database opened.
SQL>
0 comentários:
Post a Comment