Problems after changing the database name
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