[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6904
  • Last Modified:

The listener supports no service

I have installed Oracle 10 G 10.1.0 on a computer where Oracle 9i (9.2) is already installet. I do not use Oracle 10G so much, only for testing.

Now I find that I cannot access Ora10.

When I run lsnrctl, and check Services I find the following message: The listener does supports no services.
When I give the command Start I get error:
Listener is already running.
TNS-12536: TNS: operation would block
TNS-12560: TNS: protocol adapter error
TNS-00506: operation would block
32-bit Windows Error: unknown error

If I give the command Stop it succeeds, but Start does not succeed. It tries to start, but no error messages.

I have the following ora-files:

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = guava)(PORT = 1522))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.1.0\db_2)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orc2.massmarketing.se)
      (ORACLE_HOME = D:\oracle\product\10.1.0\db_2)
      (SID_NAME = ORC2)
    )
  )

=======================

# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\db_2\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ORC2_DB.MASSMARKETING.SE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = guava)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orc2.massmarketing.se)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

============================

# sqlnet.ora Network Configuration File: D:\oracle\product\10.1.0\db_2\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

TRACE_LEVEL_CLIENT = USER

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

TRACE_DIRECTORY_CLIENT = d:\oracle

TRACE_FILE_CLIENT = tracepehe.log

NAMES.DEFAULT_DOMAIN = massmarketing.se


0
Perherman
Asked:
Perherman
  • 3
  • 3
1 Solution
 
sujit_kumarCommented:
This happens because ou are running Oracle 9i Listener already. You will face problems if both the listeners (for 10G and 9i) run simultaneously. Of-course you can run them on different ports. I would prefer you using 10G listener only. let this listener connect to both odf the databases. As 10G is higher version than 9i, so it will support both DBs.

Sujit
0
 
PerhermanAuthor Commented:
My 9i listener is defined as:

 LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = guava)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = D:\oracle\ora92)
      (SID_NAME = ORCL)
    )
  )

How do I "shut off" the Ii listener, and run only 10G? (I am afraid if I shut of the 9i listener I will get none of them to work...

Per-Olof
0
 
schwertnerCommented:
Simply stop the process for the 9i listener. And set the mode of this process to "Manual" - so it will not start by reboot.
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
PerhermanAuthor Commented:
I have a tried to stop th e 9i listner and put it to manual, but then other things stopped to work, so I will have to set a day when I have no other pressing issues to work with and do some trials. The best thing would probably be to have ora 9 and ora 10 on different computers.
0
 
PerhermanAuthor Commented:
I have tried a few different setups after stoping the 9i Listener.

When I changed the PATH in the System Environment Variables so that D:\Oracle\product\10.1.0\Client_2\bin comes first, and I keep the D:\oracle\ora92\bin then I get both the 10G and the 9.2 to work. But it is the TNSNAMES.ORA from ORA92 that works, not the TNSNAMES.ORA from 10_DB or 10_CLIENT! This seems strange, but at least i works!

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ORC2.MASSMARKETING.SE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = guava.massmarketing.se)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SID = orc2)
      (SERVER = DEDICATED)
    )
  )

AQUILA.MASSMARKETING.SE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = GUAVA)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = ORCL)
      (SERVER = DEDICATED)
    )
  )

EXTPROC_CONNECTION_DATA.MASSMARKETING.SE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

INST1_HTTP.MASSMARKETING.SE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = guava)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

0
 
schwertnerCommented:
You have to add the entry to the 9i database in your 10g listener (LISTENER.ORA file).
I showed you how to do this 10 days ago.
Use also NETCA of 10g to drop and to create listeners.

Again (this is very important) check if you have entry to 9i in 10g Listener LISTENER.ORA.
0
 
schwertnerCommented:
You can clicking on my profile to use my email also.
I am interested in your case. I have here some 10g experimental DB and can do experiments.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now