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

From: Guilherme Raymo Longo <grlongo.ireland_at_gmail.com>
Date: Sun, 24 Oct 2010 15:12:32 -0200
Message-ID: <AANLkTimnQfKeOzmee_SifBnYBnZVtjsOPV0ARUad_NCa_at_mail.gmail.com>

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_at_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?

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Oct 24 2010 - 12:12:32 CDT