FAQ
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_at_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?

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 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