Re: sqlplus startup command still looking for old spfile even after renaming the database

You're using XE, not a fully featured version of the database so the only 
database you can have will be named XE; you can't change the ORAClE_SID, you 
cannot create additional databases.  You'll need to restore the initXE.ora file 
to get this database up and running. 
 
David Fitzjarrell





________________________________
From: Guilherme Raymo Longo <grlongo.ireland@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Sun, October 24, 2010 1:12:32 PM
Subject: sqlplus startup command still looking for old spfile even after 
renaming the database

Mates,  
one last question I hope....
I've followed all the steps required to change a database name.
The procedure is exausting and after all the effort I cannot startup the 
database and this is the output:


SQL> CONNECT SYS/ORACLE AS SYSDBA
Connected to an idle instance.
SQL> STARTUP
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 
'/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora'

One thing is that initXE.ora does not exist anymore, I have initLIN.ora because 
I changed my database name to LIN. I am gonna describe all the process and if 
someone could point me where I could change the parameter to fix my problem.

1 - $ORACLE_HOME, $PATH and $ORACLE_SID set properly. $ORACLE_SID = LIN

2 -  COMMANDS:
sqlplus / as sysdba
SQL> connect sys/ORACLE as sysdba
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP MOUNT

nid TARGET=SYS/ORACLE@XE DB_NAME=LIN SET_NAME=YES

all good so far, then...

SQL> startup mount
SQL> alter system set db_name=linner scope=spfile

orapwd file=$oracle_home/dbs/pwdLIN.ora password=ORACLE

TSNAMES.ORA:
# tnsnames.ora Network Configuration File:
LIN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = LAPcasa)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = LIN)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

LISTENER.ORA
# listener.ora Network Configuration File:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = LAPcasa)(PORT = 1521))
    )
  )

DEFAULT_SERVICE_LISTENER = (LIN)


I am missing someting?


      

Other related posts: