Home » RDBMS Server » Networking and Gateways » Oracle Connectivity Puzzle
Oracle Connectivity Puzzle [message #303724] Sun, 02 March 2008 07:07 Go to next message
kelvs
Messages: 15
Registered: December 2006
Junior Member
Guys,

I need help on this:

I've been asked to configure a "medium-rare" oracle setup. I've been able to setup the data and log files but I can't get the listener to run with a service

Here are the settings:

NAME                           VALUE
------------------------------ ------------------------------
db_domain                      aranetahome.net
instance_name
local_listener
db_name                        testdb2


echo $ORACLE_SID gives 9itestdb2

tried to configure the listener using static mode

LISTENER=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.101)(PORT=5000))

SID_LIST_LISTENER=
        (SID_LIST=
                (SID_DESC=
                        (GLOBAL_DBNAME=testdb2.aranetahome.net)
                        (ORACLE_HOME=/oracle/apps/product/9i)
                        (SID_NAME=9itestdb2)))

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.101)(PORT=5000)))
Services Summary...
Service "testdb2.aranetahome.net" has 1 instance(s).
  Instance "9itestdb2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


I can't seem to get the service registered. Am I missing something here?

I haven't built the tnsnames.ora as well as sqlnet.ora, tried running netmgr but says that this machine's java is not registered with GLIB gees so guess, i have to do things manually.
Re: Oracle Connectivity Puzzle [message #303782 is a reply to message #303724] Sun, 02 March 2008 18:54 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
So what problem are you having?
kelvs wrote on Sun, 02 March 2008 08:07

I can't seem to get the service registered.

Do you mean to get the service to register automatically, if so check Registering Information with a Nondefault Listener.

BTW...can you successfully launch Net Configuration Assistant (netca) ?
Re: Oracle Connectivity Puzzle [message #303791 is a reply to message #303782] Sun, 02 March 2008 21:18 Go to previous messageGo to next message
kelvs
Messages: 15
Registered: December 2006
Junior Member
hi ebrain

ebrian wrote on Mon, 03 March 2008 08:54
So what problem are you having?

ok, here's what i plan to do
1. get the listener up (on a different port other than 1521) and running with service
2. have it configured as shared server

kelvs wrote on Sun, 02 March 2008 08:07

I can't seem to get the service registered.

Do you mean to get the service to register automatically, if so check Registering Information with a Nondefault Listener.

BTW...can you successfully launch Net Configuration Assistant (netca) ?


Service won't register with the listener, i followed the instructions written in the book. am i missing something?

that's one big no no here because of a compiler problem in linux. So I have to do things manually.

Re: Oracle Connectivity Puzzle [message #303792 is a reply to message #303724] Sun, 02 March 2008 21:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Service won't register with the listener, i followed the instructions written in the book. am i missing something?

>that's one big no no here because of a compiler problem in linux. So I have to do things manually.

You keep reporting about problems, but you have steadfastly NEVER produced reproducible evidence of EXACTLY what you are doing & ACTUALLY how Oracle responds.

Is CUT & PASTE broken or do you need remedial training in using CUT & PASTE.

Since many, many others have made it work, therefore I conclude PEBKAC.

[Updated on: Sun, 02 March 2008 21:36] by Moderator

Report message to a moderator

Re: Oracle Connectivity Puzzle [message #303806 is a reply to message #303792] Sun, 02 March 2008 22:47 Go to previous messageGo to next message
kelvs
Messages: 15
Registered: December 2006
Junior Member
anacedent wrote on Mon, 03 March 2008 11:35
>Service won't register with the listener, i followed the instructions written in the book. am i missing something?

>that's one big no no here because of a compiler problem in linux. So I have to do things manually.

You keep reporting about problems, but you have steadfastly NEVER produced reproducible evidence of EXACTLY what you are doing & ACTUALLY how Oracle responds.

Is CUT & PASTE broken or do you need remedial training in using CUT & PASTE.




now i know, sorry for offending your sir. don't worry, I'll try my best to report everything here when I get back to that line.

Quote:

Since many, many others have made it work, therefore I conclude PEBKAC.


thanks for that, it's a big help Smile
Re: Oracle Connectivity Puzzle [message #303820 is a reply to message #303724] Sun, 02 March 2008 23:34 Go to previous messageGo to next message
kelvs
Messages: 15
Registered: December 2006
Junior Member
ok, for the sake of others who wish to know what happened, I'll post what I did

1. I created the listener.ora file located inside $ORACLE_HOME/rdbms/admin directory

vi listener.ora

LISTENER=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.101)(PORT=5000))

2. I started the listener by issuing (if there's a mistake here, kindly point it out. thanks)
lsnrctl stop
lsnrctl reload
lsnrctl start

and the result is, the listener is running on port 5000 but there are no services associated

3. I appended these statements on the listener.ora
vi listener.ora

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=testdb2.aranetahome.net)
(ORACLE_HOME=/oracle/apps/product/9i)
(SID_NAME=9itestdb2)))

so here's the result

LISTENER=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.101)(PORT=5000))

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=testdb2.aranetahome.net)
(ORACLE_HOME=/oracle/apps/product/9i)
(SID_NAME=9itestdb2)))

4. I tried executing step 2 above and it indicated that there's

TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00303: syntax error in NV string
Listener failed to start. See the error message(s) above...

5. After checking the lines to see if there was either a misspelled word or a missing closing parenthesis, I tried to format the SID_LIST_LISTENER part so

vi listener.ora

LISTENER=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.101)(PORT=5000))

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=testdb2.aranetahome.net)
(ORACLE_HOME=/oracle/apps/product/9i)
(SID_NAME=9itestdb2)))

6. I tried running step 2 above and the result was:
the listener is running on port 5000 BUT

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.101)(PORT=5000)))
Services Summary...
Service "testdb2.aranetahome.net" has 1 instance(s).
Instance "9itestdb2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

************************
the reason why I've pasted the settings above (on my first post) using the command

SELECT NAME, VALUE FROM V$SPPARAMETER;

NAME VALUE
------------------------------ ------------------------------
db_domain aranetahome.net
instance_name
local_listener
db_name testdb2

- is because I am wasting a lot of my time fixing things that were messed up rather than preparing for my exam, that's WHY i posted here to seek advice.

i was thinking, maybe since the db_name and the SID are different, it might contribute to the problem.

hope i've delivered things clearly
Re: Oracle Connectivity Puzzle [message #303919 is a reply to message #303820] Mon, 03 March 2008 05:21 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Why is your ORACLE_SID set to 9itestdb2 ? Try to set your ORACLE_SID to testdb2, then re-configure your listener.ora file to:

LISTENER=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)(HOST=192.168.150.101)(PORT=5000)))


SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=testdb2.aranetahome.net)
      (ORACLE_HOME=/oracle/apps/product/9i)
      (SID_NAME=testdb2)))
Re: Oracle Connectivity Puzzle [message #303995 is a reply to message #303919] Mon, 03 March 2008 11:16 Go to previous messageGo to next message
kelvs
Messages: 15
Registered: December 2006
Junior Member
ebrian wrote on Mon, 03 March 2008 19:21
Why is your ORACLE_SID set to 9itestdb2 ? Try to set your ORACLE_SID to testdb2, then re-configure your listener.ora file to:

LISTENER=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)(HOST=192.168.150.101)(PORT=5000)))


SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=testdb2.aranetahome.net)
      (ORACLE_HOME=/oracle/apps/product/9i)
      (SID_NAME=testdb2)))




hi ebrian,

actually, it's also a big question for me because the instance was already created when it was passed on to me. Here's what I did (for the sake of moving on ...) I created another instance here are the parameters

ORACLE_SID=orion
db_name=orion

followed the instructions above

executed step no 2 and here's the output

*****************************************************************
[kelvin@aranetahome ~]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 04-MAR-2008 01:05:12

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

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.105)(PORT=5000))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 04-MAR-2008 01:01:24
Uptime 0 days 0 hr. 3 min. 48 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/apps/product/9i/network/admin/listener.ora
Listener Log File /oracle/apps/product/9i/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.105)(PORT=5000)))
Services Summary...
Service "orion.aranetahome.net" has 1 instance(s).
Instance "orion", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

*****************************************************************
so again, we're back to the same problem, now, i waited for 3 mins then executed lsnrctl status. the result is:

*****************************************************************
Service "orion.aranetahome.net" has 1 instance(s).
Instance "orion", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
*****************************************************************
still unknown, however, i tried to connect

*****************************************************************
[kelvin@aranetahome ~]$ sqlplus kelvin@orion

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 4 01:04:23 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL>

*****************************************************************

it got connected! (even if the service is UNKNOWN), i tried executing lsnrctl service

*****************************************************************
[kelvin@aranetahome ~]$ lsnrctl service

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 04-MAR-2008 01:04:43

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

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.105)(PORT=5000))
Services Summary...
Service "orion.aranetahome.net" has 1 instance(s).
Instance "orion", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0
LOCAL SERVER
The command completed successfully

*****************************************************************

I can see the connection has been established ... This is getting weird than I expected.
Re: Oracle Connectivity Puzzle [message #304005 is a reply to message #303995] Mon, 03 March 2008 11:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
OK, now we are getting somewhere.

You seemed to be concerned that the status is showing 'UNKNOWN'. That is nothing to be concerned about. It's due to the fact that you have statically defined the service in the listener.ora file and it's not set to dynamically register. This is basically the listener's way of saying that the listener does not know the status of the database.
Re: Oracle Connectivity Puzzle [message #304118 is a reply to message #304005] Tue, 04 March 2008 02:31 Go to previous message
kelvs
Messages: 15
Registered: December 2006
Junior Member
ebrian wrote on Tue, 04 March 2008 01:55
OK, now we are getting somewhere.

You seemed to be concerned that the status is showing 'UNKNOWN'. That is nothing to be concerned about. It's due to the fact that you have statically defined the service in the listener.ora file and it's not set to dynamically register. This is basically the listener's way of saying that the listener does not know the status of the database.


actually, it's not only the status am worried about but the whole connectivity because I've also tried connecting to the first instance (the one with the mismatched SID and db name) but it didn't work out. For me, getting the listener up and running with be the first step, second is to get the services registered, third - to have clients connected to the instance via service name, fourth is to have the server configured to a shared server mode.

I'll keep you updated once I've done the last stage. thanks ebrian
Previous Topic: Problems connecting to 8i
Next Topic: Configuring listener manually
Goto Forum:
  


Current Time: Fri Mar 29 06:04:14 CDT 2024