Lsnrctl Pb

Hello,

I just finished installing Oracle 9i with the OUI, runInstaler. When I try to lauch a listener:
-----
LSNRCTL> start LISTENER
Starting /home/oracle/OraHome2/bin/tnslsnr: please wait...

TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
Linux Error: 13: Permission denied

LSNRCTL>
----
----
I reinstalled the Oracle 9i DB, and this is what I got, in the listener.log file:

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12542
TNS-12560
TNS-00512
Linux Error: 98 Address already in use
-----
Any ideas what this is all about ? why it is not working ?

PT

Hello,

I invoke LSNRCTL, when I type status, I get the following twice:
-----
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:prtocol adaptor error
TNS-00511: No listener
Linux Error: 111: Conneciton refused
-----

Any ideas what this might be ? How can I solve this ?

PT

Hello,

When I type status after a start, I get this:
-----
Alias: LISTENER
Version TNSLSNR for Linux: Version 9.2.0.5.0 - Production
Start Date
Uptime 0 days 0 hr. 2 min. 4 sec
Trace Level off
Security OFF
SMNP OFFF
Listener Parameter File
Listener Log File
Listening Enpoints Summary
(PROTOCOL=ipc)(KEY=EXTPROC)
(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)
...
Services Summary...
Service "PLSExtProc" has 1 instance(s)..
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully.
> exit
----

IS it working now ? What does it do ?

PT

How about reading some manuals?

Believe me, that advice has just fallen on deaf ears. After spamming dbaclick, he's over here spamming this site with the same inane questions. "I've installed Oracle whatever on my Linux server (did I say it was Linux yet?), and the display on my monitor is dim. Should I try installing a patch?"

Put a BAN ? :D :D :D

Hello people,

I am a newbie with Oracle.
It might be true that I ask a lot of questions.
I have a lot of stuff to learn and read about that does not make sens to me at first.

I am reading the literature that was pointed out to me.
There is so much information to digest...........

I hope that by posting + the reading I can get to understand my system and difficulties to get me going.

I find it ironic that you would ban a person with such an interest in Oracle. Let me mention that some of the problems I am experiencing are very difficult for a beginner like me to crasp.

My posting and susequent replies have been a greath help to me so far, I wish I can count on your continued support.

Regards,

PT

a forum is not a school!

Hello,

Yes, I understand.
By the way, I found a greath source of information about the LSNRCTL utility at www.oracleutilities.com.

It talks about the utility, what it does and the commands it uses.
This is the kind of information I was craving for.

It can help me get along a little more.
I tought I would share that with everyone.

PT

PS: I still have those Java Runtime Exceptions with the DBCA that I am trying to understand what are all about ? I can't find that in a manual !!!!

Quote:

---

Originally posted by ptreves
By the way, I found a greath source of information about the LSNRCTL utility at www.oracleutilities.com.

---

:rolleyes:

Quote:

---

Originally posted by ptreves
Hello people,

I am a newbie with Oracle.

---

really? The 50 questions you have asked would lead me to believe you are an expert.

Quote:

---

It might be true that I ask a lot of questions.
I have a lot of stuff to learn and read about that does not make sens to me at first.

I am reading the literature that was pointed out to me.
There is so much information to digest...........

I hope that by posting + the reading I can get to understand my system and difficulties to get me going.

I find it ironic that you would ban a person with such an interest in Oracle. Let me mention that some of the problems I am experiencing are very difficult for a beginner like me to crasp.

---

We tend to help people that want to help themselves, not people who can't read the instructions and keep posting the same three questions every few hours.

Quote:

---

My posting and susequent replies have been a greath help to me so far, I wish I can count on your continued support.

Regards,

PT

---

Yeah, count on being ignored.

Quote:

---

Originally posted by pando
Put a BAN ? :D :D :D

---

Lets vote...

Hello again,

I am dissapointed by the harsh criticism that I have been getting by certain members. Most of the post have been related to error messages that I have encountered during my installation procedure and when attempting to use various tools and utilities (eg.: OEM, LSNRCTL, DBCA,etc.).

Those posts can be of general interests to any Oracle User.
If the problem is so easy to answer why not just give an answer or a source of reference.

I have been searching at Metalink and found in certain cases even when following all the installation procedure to the letter, some installation errors can still occur particularly with the DBCA.

I am doing my best on reading up the literature and expand my knowledge on Oracle.

PT

its simple, uninstall everything - then try again following the installation guide to the letter. If you do you wont get any errors.

Its not hard!

Don't get dissappoint.These are only an advise.u can't learn the things in 1 or 2 days.Give more concentration on documentation and note down basic things required for any installation.Its not an Herculus task.

Quote:

---

Originally posted by ptreves

I am doing my best on reading up the literature and expand my knowledge on Oracle.

PT

---

how about start reading the installation guide?¿

Considering my teacher is having many of the same errors.
Reading manuals is apparently not enough, because even ORACLE cant solve the below that I got on my own setup.
And this is before & after a fullblown wipe & re-install of 9i.
I did at one time have a good setup, and something burped along the way...> I figure I messed up stuff external to ORACLE that is now keeping it from working...........
ORACLES solution: Re-install XP.... which aint gonna happen on this pc for a while.


The original installand the repeat effort was done by a teacher who not only used to work for oracle but has been a published author of oracle too....and is having a fit.
I dont think advice on 'read the book' is correct solution.
Especially with oracles solution being the usual 'reinstall OS' answer. Which is rarely the real answer on most apps (having been a helpdesk tech in the past myself, it was the ultimate answer to get rid of a pest).

LSNRCTL for 32-bit Windows: Version 9.0.1.1.1 - Production on 03-DEC-2004 22:32:19

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 - Production
System parameter file is D:\oracle\ora90\network\admin\listener.ora
Log messages written to D:\oracle\ora90\network\log\listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pjc-office)(PORT=1521)))
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 13: Permission denied

Listener failed to start. See the error message(s) above...

Quote:

---

Log messages written to D:\oracle\ora90\network\log\listener.log

---

What does that show?

Whenever I have a problem that I can't solve and my fellow DBA's here can't either, most of us here go to THIS site. 9 times out of 10 I get my answer lickity split.

Quote:

---

Originally posted by OracleDoc
Whenever I have a problem that I can't solve and my fellow DBA's here can't either, most of us here go to THIS site. 9 times out of 10 I get my answer lickity split.

---

can't tell if your being sarcastic or not :confused:

Quote:

---

Originally posted by davey23uk
can't tell if your being sarcastic or not :confused:

---

?? Really?? after all this time of you and I banning together to thwart stupidity here and the remarks I've made about mister "Redneck". I thought for sure you'd be falling out of your chair on that one. :D

Hello,

I am quite dissapointed by the attitude of certain people.
This is suppose to be a mutual help site.

Doing research on my own, I have found a Guide about Report Services COnfiguration for Windows/Unix. This guide goes in details about the role of each parameter and their use.

This is the kind of information that can be very usefull.
Again, I did not resolve my issue yet, I am working on it, but it points me in the right direction.

This is the kind of support I would expect !!!!
Not sarcastic remarks.........

The are tons of ORacle documents out there.
Plus each Oracle document is 100-300 pages each. It takes a long time to get familiar with the documentation, this is where fellow DBA can help guide each other towards a solution....
-----
Coming back to my problem I set the PROCESSES parameter to 9999 in my init.ora file, but this still did not resolve the issue.

PT

Quote:

---

Originally posted by ptreves
Coming back to my problem I set the PROCESSES parameter to 9999 in my init.ora file, but this still did not resolve the issue.

---

I'd be very surprised if that would fix a problem with the listener. Are you in the right thread?

Hello,

I am going to install PatchSet 3 for Oracle 9i iDS running on Windows XP Pro. This latest patch from Oracle addresses many issues with the iDS environment.

I have been doing a lot of reading on the Reports Services Configuration, some of the errors that I have encountered could be addressed by this Patchset such as problems with ReOpening Reports, Runtime Error ifweb90.exe ,REP-50003, REP-50004, etc...

I will keep you posted.
For the iAS, there is only one Patch Set available 9.4.0.1. The readme does not mention any relevant bug fixes relating to Parameter forms and such.

PT

PS: Considering that by default my PROCESSES parameter is set to 50 (small), to what value do you believe I should set this parameter based on the query results I have posted + the Reports Services errors REP-51018 / REP-50004 ?

PS2: I am doing my homework............

Quote:

---

Originally posted by ptreves
Hello,

I just finished installing Oracle 9i with the OUI, runInstaler. When I try to lauch a listener:
-----
LSNRCTL> start LISTENER
Starting /home/oracle/OraHome2/bin/tnslsnr: please wait...

TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
Linux Error: 13: Permission denied

---

Geeeshhh!!
Set your oracle SID in your enviornments setting

Quote:

---

Originally posted by OracleDoc
Set your oracle SID in your enviornments setting

---

Uh? If I'm listening for 10 db's, which one do I set?

ohh nevermind me. I just now saw what O.S. it was.

Quote:

---

Originally posted by ptreves
Hello,

I am going to install PatchSet 3 for Oracle 9i iDS running on Windows XP Pro. This latest patch from Oracle addresses many issues with the iDS environment.

I have been doing a lot of reading on the Reports Services Configuration, some of the errors that I have encountered could be addressed by this Patchset such as problems with ReOpening Reports, Runtime Error ifweb90.exe ,REP-50003, REP-50004, etc...


PS2: I am doing my homework............

---

Instead of reading more books or applying patches, just want to remind you that your question is basic. So I suggest, you just have to stick to the basic:
Is your o.s. user login is the owner of your installation(usually oracle)?, Do you have the proper environment like ORACLE_SID, ORACLE_HOME, LIBPATH, PATH etc. Have you check the logs?
what is the output when you type from prompt lsnrctl status LISTENER?
etc..etc...

Quote:

---

Originally posted by reydp
Instead of reading more books or applying patches, just want to remind you that your question is basic. So I suggest, you just have to stick to the basic:
Is your o.s. user login is the owner of your installation(usually oracle)?, Do you have the proper environment like ORACLE_SID, ORACLE_HOME, LIBPATH, PATH etc. Have you check the logs?
what is the output when you type from prompt lsnrctl status LISTENER?
etc..etc...

---

just to say this thread got started off months ago, the listener thing was fixed I guess :-)

it got hijacked by someone else

Hello,

Just to let you know, my lister is working fine and my database is up and running normally.

I was finally able to complete the installation.
This thread shoud be closed.

The issues I am having now are related to Oracle 9i iDS (9.0.2.0.1) + WebReports.

PT

NO. The job's not finished yet.

Tell us what was wrong to provoke this specific error. We want to learn too - especially Tulsaboyw. :)

Hi DaPi,

Thanks for your comment.
As I have said, my Oracle 9i Database is installed and working properly on my Linux Red Hat server. I can connect to it through the network.

I have been working on the migration from Forms/Reports 6i to 9i, migrating Forms/Reports under Oracle 9i iDS (Windows XP Pro). Thinks were moving along nicely. When running my WebReports from WebForms, the first time around, I would get errors like:

REP-51018:

followed by

REP-50004:

These are Reports Services Errors under Oracle 9i iDS. I also got a REP-51018 when running my WebReports under Forms/Reports 10g. Under the Forms/Reports 10g, for some stange reason, the WebReports that work well under ORacle 9i iDS, the same WebReports do not show Parameter Forms Fields on the Parameter Forms, therefore not generating the correponding WebReports.

-----
Since, I was not getting anywhere with these problems, I decided to look for patches. I found Patches that tacked the REP-50004 and REP-50003 errors under Report Services, such as:

PatchSet 3 (3129219)

When I installed this patch under Oracle 9i iDS (without the prerequisites......) I would get an error like:

FRM-92050: Failed to connect to the server: /forms/90/l90servlet: -1

I searched metalink, I tried to follow the recommended procedures but got nowere again. The prerequisite Patches apply to Oracle 9i iAS, so I am confused as to what I should do now.

Reinstall from scratch Oracle 9i iDS / Try to apply a bunch of reprequisite patches I am not even sure apply to my case.

I also heard of hot fixes / hot patches like 2516165 for Report Services, but I am unsure of what to do next ??

PT

PS: At the end under Oralce 9i iDS, I could not even run my Forms anymore, I was getting ifweb90.exe Runtime errors.

1) Any ideas what is going on ?
2) What should I do next ?

Quote:

---

Originally posted by ptreves
Hi DaPi,

1) Any ideas what is going on ?
2) What should I do next ?

---

read the manuals and do it properly

So ptreves, if I can summarise:
- you don't know why you got TNS-12546
- you don't know what you did to fix it

Quote:

---

Originally posted by DaPi
So ptreves, if I can summarise:
- you don't know why you got TNS-12546
- you don't know what you did to fix it

---

dapi the listener stuff was from months ago - it got restarted for some reason

Quote:

---

Originally posted by davey23uk
. . . the listener stuff was from months ago . . .

---

Here we deal in eternal truths! (and I bet Tulsaboyw would like an answer.)

Hello,

Concerning the Listener problem, that came from a bad Oracle 9i installation. I guess the original installation was made without the proper Java components installed on my Linux Box. I was trying to start-up and run the listener on a Bad Installation.

Concerning the more recent problems with Oracle 9i iDS,
actually, I reinstalled my entire Oracle 9i iDS environment and applied the following PatchSet 1 (2729569 specifically for Oracle 9i iDS. I addition I applied a Reports Hot Fix (2516165).

I did not resolve the issue with REP-51018 / REP-50004 but it seems to resolve several other secondary issues I was facing.

Regards,

PT

PS: You can close this thread !!!!!
PS2: I tough that this forum could be my consultants !!!!