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?