FAQ
mmm.. how about your oratab?

sent from my iPhone

On Monday, October 25, 2010, Guilherme Raymo Longo
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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 24, '10 at 5:12p
activeOct 24, '10 at 6:49p
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase