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 with Listener connection

892388Mar 15 2012 — edited Jun 28 2012
I have installed Oracle 10gXE in Windows XP SP3

which is giving me the following error when trying to connect to the instance XE. Ora-12514.

Looking for information about this error, I managed to access the database instance after performing the following instructions.

sqlplus / nolog
conn sys / as sysdba skf
connected to idle instance (or something)
startup nomount
----
immediate shutdown
startup mount
---- mount the database
database recovery
----
alter database open
conn sys / skf as sysdba @ xe
connected

this gave me the opportunity to create a backup of the database. But again, reboot the OS again show the same error. Reinstall Oracle 10gXE to see if correcting the error, but no.

I was doing tests on a virtual machine, and I realized that running the status of the listener (lsnrctl status), the summary of services does not appear XE instance.

What else I can do?
The windows firewall is disabled, the PC is installed the Symantec End Point Protection with the firewall disabled.

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2012
Added on Mar 15 2012
23 comments
7,245 views