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 09:11:02 -0200
The error I get is:
ORA-12154: TNS:could not resolve the connect identifier specified:
only CONN USER/SENHA@//127.0.0.1/LIN works!
This is my tnsnames:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = LIN)
)
)
I am I missing somenthing?
On Mon, Oct 25, 2010 at 8:59 AM, Guilherme Raymo Longo <
grlongo.ireland@xxxxxxxxx> wrote:
> 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:
