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

  • Karl Arao at Oct 24, 2010 at 6:35 pm
    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
  • Subodh Deshpande at Oct 24, 2010 at 6:49 pm
    hi
    when you are giving startup it will lokk for spfile at $ORACLE_HOME/dbs
    location only.
    create pfile using spfile and start stop the datbase otherwise.and check
    check the path and SID it is pointing to in environment.
    have you put proper entry in oratab..
    listener and tnsfiles has nothing to do with startup and
    shutdown..thanks..subodh

    On 24 October 2010 22:42, 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 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?

    --
    ==============================
    DO NOT FORGET TO SMILE TODAY
    ==============================

    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
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