Re: ORA-12514 with 10g Install (LONG...)
Date: Sun, 20 Jan 2008 19:43:32 -0800 (PST)
Message-ID: <6a5a53eb-e0e0-4fef-b661-24085c026070@v46g2000hsv.googlegroups.com>
I'm back after a long hiatus. Thanks for all the inputs again, Frank
and Shakespeare. I am still trying and I am still having issues. Some
changes since the last time:
1. Now I have managed to install a loopback adapter successfully and
2. I have also switched to Oracle Enterprise Edition (Personal) as I
thought it might help me in troubleshooting my issues. But its
interesting that I get the exact same results.
3.I copied your listener and tnsnames ora files
Frank, in response to your suggestions, please see the results below:
Trying sqlplus gives me the following:
C:>sqlplus system/manager
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 20 19:49:22 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: SYS
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
C:\>
TNSPING yields:
C:\>tnsping XE
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-JAN-2008 22:26:10
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.2.0\db\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
I changed the listener.ora and tnsnames.ora to those suggested by you. (Note: Now I have Oracle Std Edition, so they might be slightly different.)
listner.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\db)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\db)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc))
(ADDRESS = (PROTOCOL = TCP)(HOST = scout.domain.com)(PORT =
1521))
)
)
tnsnames.ora:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scout.domain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
result of lsnrctl status
C:\>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 20- JAN-2008 22:38:44 Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=extproc)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=scout.domain.com)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production Start Date 20-JAN-2008 22:34:37 Uptime 0 days 0 hr. 4 min. 7 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=scout.domain.com) (PORT=1521)))
The listener supports no services
The command completed successfully
Please please help. Ive tried all things and am desperate now. Please let me know if I am doing something wrong.
Thanks again. Received on Sun Jan 20 2008 - 21:43:32 CST