| the stupid TNS Listener! [message #340812] |
Thu, 14 August 2008 08:08  |
cornercuttin
Messages: 2
Registered: August 2008
Location: Oklahoma
|
Junior Member |
|
|
alright, i have been working on this for a week now and about ready to throw this computer right out the window.
i just need a simple oracle database to be working so that i can start using some other software that requires Oracle. thats it. i keep getting TNS Listener errors.
i have Oracle 10g and am trying to install on Windows Server 2003. here is what i have done:
- installed the database software
- installed the client (admin package)
- created a database using the client software (called orcl)
- created a listener using the client software (called LISTENER)
now i am a programmer, not an Oracle admin, so a lot of this is guesswork for me (we are a small company and really don't have an Oracle admin).
i have the software installed at C:\oracle\product\10.2.0\. that means that the client is installed at C:\oracle\product\10.2.0\client_1 and the database software is at C:\oracle\product\10.2.0\db_1.
first question: where do i point my oracle home? at the client_1 or db_1?
secondly, here is my tnsnames.ora file:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = my.host.name.here.com) (PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0))
)
(CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO))
)
my listener.ora file is:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\client_1)
(PROGRAM = extproc)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = C:\oracle\product\10.2.0\client_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = my.host.name.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
now these files were created by Oracle and put in C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN. do they need to go in the equivalent folder in the db_1?
also, i commented out the SQLNET.AUTHENTICATION_SERVICES= (NTS) in the sqlnet.ora file because it says so in some instructions i have. is that right?
as of right now, i am getting the ORA-01034 error. on a fresh install, everything works fine. but once i reboot, the listener never wants to work.
any clues on what i am doing wrong? if you can help me, and you ever make it to OKC, there will be a beer waiting on the table for you. i'm so tired of this thing.
|
|
|
|
| Re: the stupid TNS Listener! [message #340818 is a reply to message #340812] |
Thu, 14 August 2008 08:45  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
Point 1:
When you have installed the database server software on the server, there is no additional client required on the server, since it is included in the server package.
So, Point 2 follows :
All ORACLE_HOME entries on the server should point to the server install.
Especially, the listener must run with the server ORACLE_HOME.
And, ORA-01034 means "Oracle not available". You have set the database to auto-start on reboot? (with oradim or in the windows services panel)
|
|
|
|
| Re: the stupid TNS Listener! [message #340830 is a reply to message #340818] |
Thu, 14 August 2008 09:14 |
cornercuttin
Messages: 2
Registered: August 2008
Location: Oklahoma
|
Junior Member |
|
|
i set SQLNET.AUTHENTICATION_SERVICES to NONE, and the damn thing fired up.
did a reboot, and (of course) got nothing. the listener would come up for a minute, but the database would not start/connect. when i would try to start it, the error i got was something like "TNS lost contact". i noticed that as soon as i tried to start it (the database), the TNS process would die.
i have ORACLE_HOME set to C:\oracle\product\10.2.0\db_1. i have the listener.ora, tnsnames.ora, and sqlnet.ora files in the NETWORK\ADMIN folders in both the db_1 and client_1 folders as well.
i just got the listener to start via the web interface, but i cannot get the database to start. I am getting 2 erros, ORA-01034, and error "ORA-27101:shared memory realm does not exist."
i am looking in the listener.log file, and there is a lot of this (i took out the timestamp):
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.79)(PORT=XXXXX)) * establish * orcl * 0
where PORT starts at 1522 and just increments up about a hundred times.
does this give any insight to any parameters that i may be missing in my listener.ora file?
btw, thanks a lot for replying. it is a relief to know that someone is trying to help me.
[Updated on: Thu, 14 August 2008 09:19] Report message to a moderator |
|
|
|
| Re: the stupid TNS Listener! [message #340833 is a reply to message #340830] |
Thu, 14 August 2008 09:29 |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
The most common causes for ORA-27101 during database startup is that ORACLE_HOME or ORACLE_SID are not set correctly.
Also, the listener is just a services that listenes to network connections, and connects them to a running database. It can do nothing when the database is not running.
So we should first check if the database is really up.
Try this from the command promt:
set ORACLE_SID=orcl
sqlplus /nolog
You should then get a sql*plus prompt.
then there :
if you then get a "connected to an idle instance" do an
and the database should start.
A cheat sheet for creating (and managing) a database and is here :
http://www.adp-gmbh.ch/ora/admin/creatingdbmanually.html
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
