I am trying a new installation of Oracle XE on an Ubuntu 7.10 Server. After completing the installation, I attempt to login to SQLPLUS as follows:
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 21 21:17:37 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ORA-12514: TNS:listener does not currently know of service requested in connect
If I do a tnsping on XE, it comes back as:
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 21-NOV-2007 21:21:22
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ubuntu-server)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (10 msec)
What is causing the ORA-12514 when I try to login using SQLPLUS?