Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems after changing the database name

gerhard2001Sep 13 2011 — edited Sep 14 2011
Hi!

I changed my database name on my oracle xe database, running on Ubuntu Linux, from XE to MUDB using 'nid'.

It works and the 'select name from v$database' shows me the database name 'MUDB'.

But I have some Problems:

I change in my initXE.ora the db name to 'MUDB' and changed the name of this initialization file to initMUDB.ora

When I want to startup the database in SQLPlus as 'sys / as sysdba' SQLPlus asks me for 'initXE.ora'

The second problem:

If I connect me directly on the server via sqlplus with 'connect sys/password as sysdba' it works.

If I connect me directly on the server via sqlplus with 'connect sys/password@MUDB as sysdba' it shows me the following error:

ORA-01031 insufficient privileges

I changed my listener.ora and tnsnames.ora in the following way:

# 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 = mac-ubuntu)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (MUDB)



# tnsnames.ora Network Configuration File:

MUDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mac-ubuntu)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MUDB)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)



Where could be my error?

Thanks for any help!

Gerhard
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2011
Added on Sep 13 2011
2 comments
245 views