Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



General Questions

Renaming DB on oracle 10g XE

Hi,  I am using oracle 10g XE and would like to rename the db name XE to another one. I would ask you whether is it possible to achieve the same, and how should i go about doing it, since i can not create a new db in XE.  Regards  Kunal

What do you try to achieve with changing the name of the XE database?  With Oracle XE you can only have one database, you should not change the name of it since several components have the XE name hardcoded.  You may want to read other comments on a similar issue here -->   Oracle XE and APEX - rename database ~   Madrid

Hi Madrid,  I get your point. I`ll explain you my scenario, and why i wanted the renaming.  hen i run my forms 6i application and we suppy the credentials as user/pass@XE, i wanted the user to use another name instead of XE.  To achieve the above scenario, i thought renaming would help. Could you advise me of something else.  I could create a new sid through oradim. could the new sid be used somehow.......  Regards,  Kunal

It is much simpler than renaming your Oracle Database.  What you need is to create a new entry at the tnsnames.ora file, currently you have an entry named XE, just copy/paste this whole entry and rename the XE= string with your desired alias name and keep the service name just exactly the way it is.  You will have two entries pointing to the same database, one will be named XE and the other will be named whatever you require.  ~   Madrid

Hi, In addition, you can try put the service names separated by comma:  XE,OTHER =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = XE)     )   )  Cheers  Legatti

Related Links

Listener.ora and TNS.ora in simple language
DB links for SYS to use
How to identify Which table is hashed
Can you really not delete old flashback logs?
Failure to connect to my Oracle Database
How RH Linux behavior with Oracle in that situation?
Aftr db upgrade,OEM reconfigured Startd but status:Not runnining :Help Plz
Relation between temp tablespace and index creation
Query text not seen in v$sql
Wanted to extract program unit with ddl of program unit for ORACLE_OCM job
Unable to login with 'SYS' using sqlplus
Histogram Question
ORA-12170: TNS:Connect timeout occurred
Instance lock files in $ORACLE_HOME/dbs/ on Unix systems
awr report