I have searched for my error in the forum and there is no part of the suggested solutions I can follow since I cannot connect to the database
Everything was working fine April 5. I went on three weeks holiday and last night I had a problem with my app login, but I was able to connect in sql developer.
Now I cannot connect in sql plus or in sql developer. The message in SQL+ is
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
In sql developer it is similar: Test failed: Listener refused the connection with the following error ORA 12505, TNS:listener does not currently know of SID in connect descriptor.
I have reviewed the path and other oracle environment variables and while they weren't there, putting them in has made no difference.
What could have happened while I was away (apart from several reboots for Windows and Dell and anti virus software)?
I am the only user. This is a very minimal setup. I could restore from the last backup if this would help, but I have never done this so I don't know what the result would be. My own data is completely recoverable from exports if a database restore would fix the problem..
Thanks for your help
------------------
ORACLE_HOME is C:\oraclexe\app\oracle\product\11.2.0\server
ORACLE_BASE C:\oraclexe\app\oracle
ORACLE_SID (never heard of this one before) is XE - is this wrong ?
My TNSNAMES.ORA is unchanged (C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN)
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DELL-DESKTOP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
The listener.ora is in the same place
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = DELL-DESKTOP)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)