I am trying to upgrade my Oracle 11g R2 Express database to Oracle 11g R2 Enterprise using the export/import dump. My OS is Windows Server 2008 R2. I now have both versions installed on the server. I want to get a new export of the data from XE because users has entered more data since I did the last dump. The issue is I can't connect to XE anymore using SQL Plus but I can connect to the Enterprise. The versions are using two different directories and have separate services. Does anyone know what could cause this? I just want to get a new dump of the XE data and import it into Enterprise.
Its Because there is no ORACLE_HOME set,
You have installed the EE version on same server so might me the PATH variable would be change and its pointing out to new EE home ,
Your step to loging on XE Db would be, set the ORACLE_HOME/ORACLE_SID on Command Prompt which should Point out to your old XE Home.
and then Try To login