Oracle Error: ORA-12514 on local Ubuntu Installation of XE
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:
sqlplus system@xe
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.
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
If I do a tnsping on XE, it comes back as:
tnsping xe
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?
sqlplus system@xe
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.
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
If I do a tnsping on XE, it comes back as:
tnsping xe
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER