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

• sent from my iPhone

On Monday, October 25, 2010, Guilherme Raymo Longo <grlongo.ireland_at_gmail.com> wrote:
> 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 SYSDBAConnected to an idle instance.SQL> STARTUPORA-01078: failure in processing system parametersLRM-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 sysdbaSQL> connect sys/ORACLE as sysdbaSQL> SHUTDOWN IMMEDIATE
> SQL> STARTUP MOUNT
> nid TARGET=SYS/ORACLE_at_XE DB_NAME=LIN SET_NAME=YES
>
> all good so far, then...
> SQL> startup mountSQL> 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?
>
>
>
>

-- 
Karl Arao
karlarao.wordpress.com
karlarao.tiddlyspot.com
--
http://www.freelists.org/webpage/oracle-l