I also navigated to the option to "Run SQL Command Line" in the Windows start menu for 11g, but got another error.
C:\>tnsping xe TNS Ping Utility for 32-bit Windows: Version 22.214.171.124.0 - Production on 31-JAN-2 013 07:59:17 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Rob-PC)( PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE))) OK (21140 msec)
SQL> connect scott/tiger@xe; ERROR: ORA-12170: TNS:Connect timeout occurred
arizona9952 wrote:ORA-12514 ALWAYS only occurs due to a problem on DB Server system.
I recently installed Oracle database 11g XE onto my home computer running Windows 32 bit, but I can't connect to the database. I also have Oracle 10g R2 installed on my computer, and I can still connect to it finely. When trying to make a connection in SQL DEVELOPER, I get this error
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor