asked on

spfile

[oracle@server2 dbs]$ . oraenv vin
ORACLE_SID = [vin] ? vin

The Oracle base for ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db2 is /oracle/app/oracle

[oracle@server2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 20 06:22:08 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------
VIN

SQL> ALTER SYSTEM SET control_files='+DATA1' scope=spfile;
ALTER SYSTEM SET control_files='+DATA1' scope=spfile

*
ERROR at line 1:

ORA-32001: write to SPFILE requested but no SPFILE is in use

SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------

spfile string

SQL> create spfile from pfile;

File created.

SQL> ALTER SYSTEM SET control_files='+DATA1' scope=spfile;
ALTER SYSTEM SET control_files='+DATA1' scope=spfile

*
ERROR at line 1:

ORA-32001: write to SPFILE requested but no SPFILE is in use

SQL> show parameter pfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------

spfile string

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@server2 dbs]$ ls
hc_DBUA0.dat init.ora lkVIN peshm_DBUA0_0 spfilevin.ora
hc_vin.dat initvin.ora ora

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Steve Wales

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.