SQL> startup mount pfile='/opt/app/oracle/admin/zxdb/pfile/init.ora.9202012152743';
ORACLE instance started.
Total System Global Area 3724607488 bytes
Fixed Size 2233880 bytes
Variable Size 805308904 bytes
Database Buffers 2902458368 bytes
Redo Buffers 14606336 bytes
Database mounted.
SQL> create pfile='/tmp/pfile_a1' from spfile;
create pfile='/tmp/pfile_a1' from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> create spfile='+data/zxdb/spfilezxdb.ora' from pfile;
File created.
SQL> create pfile='/tmp/pfile_a1' from spfile;
create pfile='/tmp/pfile_a1' from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> alter system set spfile='+data/zxdb/spfilezxdb.ora';
System altered.
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +data/zxdb/spfilezxdb.ora
SQL> create pfile='/tmp/pfile_a1' from spfile;
File created.
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string zxdb
SQL> show parameter target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
parallel_servers_target integer 256
pga_aggregate_target big integer 1184M
sga_target big integer 3568M
SQL> shutdown immeidate
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORA-01506: missing or illegal database name
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
oracle@zhixing-db1:/opt/app/oracle/admin/zxdb/pfile> cat /tmp/
.ICE-unix/ crsctl oraInstall2012-10-20_11-36-13-AM.out.zhixing-db2
.X0-lock dbca/ orbit-gdm/
.X11-unix/ getfileinfoconfigfile_1183862985462518328.txt orbit-root/
.esd-0/ gpg-2CrXu0/ pfile_a1
.gnome_thumbnail.R6JKKW.4EKJKW hsperfdata_grid/ pulse-KmuUER3JsMqF/
.linux_release hsperfdata_oracle/ scim-bridge-0.3.0.socket-0@localhost:0.0
.oracle/ hsperfdata_root/ scim-helper-manager-socket-root
CVU_11.2.0.1.0_grid/ installCopyFile.lst scim-panel-socket:0-root
CVU_11.2.0.1.0_oracle/ installDirFile.lst scim-socket-frontend-root
CVU_11.2.0.3.0_grid/ installExcludeFile.lst silentInstall.log
CVU_11.2.0.3.0_oracle/ installRemoveDirFile.lst ssh-LwRhz2144/
CVU_11.2.0.3.0_resource/ installRemoveFile.lst virtual-root.0pLqYZ/
Cleanup2012-10-20_11-36-13-AM.log keyring-YWQQmz/ virtual-root.IwX79C/
DetachHome2012-10-20_11-36-13-AM.log.zhixing-db2 logs/ virtual-root.hL1KHg/
OraInstall2012-09-11_08-53-45PM/ lost+found/ virtual-root.mDvTbV/
OraInstall2012-10-20_11-21-25-AM/ mk_initrd.log virtual-root.pGVst2/
OraInstall2012-10-20_11-36-13-AM/ oraInstall2012-10-20_11-36-13-AM.err.zhixing-db2
oracle@zhixing-db1:/opt/app/oracle/admin/zxdb/pfile> cat /tmp/pfile_a1
oracle@zhixing-db1:/opt/app/oracle/admin/zxdb/pfile>