Re: sqlplus startup command still looking for old spfile even after renaming the database
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: "grlongo.ireland@xxxxxxxxx" <grlongo.ireland@xxxxxxxxx>
- Date: Mon, 25 Oct 2010 02:35:19 +0800
mmm.. how about your oratab?
- sent from my iPhone
On Monday, October 25, 2010, Guilherme Raymo Longo
<grlongo.ireland@xxxxxxxxx> 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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
