Re: sqlplus startup command still looking for old spfile even after renaming the database
- From: Guilherme Raymo Longo <grlongo.ireland@xxxxxxxxx>
- To: David Fitzjarrell <oratune@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 25 Oct 2010 08:59:02 -0200
Thanks everyone for the replies!
I had a problem at home wih my internet so I was´nt able to replay.
After reading David´s email, I gave a better look at the sql script and I
noticed that the connection statement was:
CONN SYS/ORACLE@LIN as sysdba
In fact LIN was not the db_name as I was thinking... It was the instance
name.
Speaking to a friend of mine he said that If I wanted to have a db with a
name other than XE through the admin I should manually create a database
with the name I want and than drop the XE database. So problem solved.
After creating a database and changing its instance name to LIN in
listener.ora, tnsnames.ora and in the system:
ALTER SYSTEM SET instance_names='LIN';
I was able to connect with the command:
CONN SYS/ORACLE@//127.0.0.1/LIN as sysdba.
The only thing that I could not archieve yet is to connect without having to
specify the absolute path to the instance.
I need to connect like that:
CONN SYS/ORACLE@LIN as sysdba. and when I try it gives me an ora error I
can´t remember right now.
That it.
Thanks all!
On Sun, Oct 24, 2010 at 5:41 PM, David Fitzjarrell <oratune@xxxxxxxxx>wrote:
> 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:
