1 Reply Latest reply: Apr 25, 2014 8:14 AM by sb92075 RSS

    keep on telling me port in use after old 10g listerner is being use.

    redologger-OC

      Hi Guys,

       

      planning to upgrade from 10.2.0.5 to 11.2.0.4 ( win server 2003 32bit)

      using DBUA (out-of - place) & within the same server box.

       

      Doc ID 870814.1 it says

      Previous versions of the listener are not supported for use with an Oracle Database 11g Release 2 (11.2) database. However, it is possible to use the new version of the listener with previous versions of Oracle Databases.

      If you are upgrading from 9i  then run Oracle Net Configuration Assistant before upgrading the Oracle database.

       

      This is a two-step option.

      You must first run Oracle Net Configuration Assistant from the old Oracle Home to remove the old listener.

      - Invoke the Netca

      - Choose the configuration you want to do ==> Choose Listener Configuration

      - Select what you want to do ==> Delete

      - Select the listener you want to delete .

       

      Then you must run Oracle Net Configuration Assistant again from the new Oracle Database 11g Release 2 (11.2) Home to create a new listener.

       

      - Invoke the Netca

      - Choose the configuration you want to do ==> Choose Listener Configuration

      - Select what you want to do ==> Add

      - Provide the detail that is required to configure the listener.

       

      You must remove the old listener before creating a new one. If you attempt to create a new listener from the new Oracle Home first, and use the same name and port as the old listener, then Oracle Net Configuration Assistant returns an error.

       

      so i have follow the steps as of above. But i keep having the error telling me -> the Net Configuration Assistant may fail and report "Use another port number"

       

      so i search -> Oracle Net Configuration Assistant Fails with Use another port number (Doc ID 1339912.1) it tells to ->

      casue: Firewall software is blocking the usage of the network ports

      solution: Allow TNS listener to be started,  by stopping the firewall from halting the process due to port restrictions.

       

      My question is, how can it be a firewall halting the process when first of all my 10g Listener can be sucessfully deleted and recreated again.

      I mean i am doing the testing.

       

      So now i need to re- create it using the 11g netca .

      i check , nothing is using the port 1521

       

      C:\Documents and Settings\Administrator>netstat -a -n

      Active Connections

        Proto  Local Address          Foreign Address        State
        TCP    0.0.0.0:135            0.0.0.0:0              LISTENING
        TCP    0.0.0.0:445            0.0.0.0:0              LISTENING
        TCP    0.0.0.0:1025           0.0.0.0:0              LISTENING
        TCP    192.168.10.1:139       0.0.0.0:0              LISTENING
        TCP    192.168.224.129:139    0.0.0.0:0              LISTENING
        UDP    0.0.0.0:445            *:*
        UDP    0.0.0.0:500            *:*
        UDP    0.0.0.0:1027           *:*
        UDP    0.0.0.0:4500           *:*
        UDP    127.0.0.1:123          *:*
        UDP    192.168.10.1:123       *:*
        UDP    192.168.10.1:137       *:*
        UDP    192.168.10.1:138       *:*
        UDP    192.168.224.129:123    *:*
        UDP    192.168.224.129:137    *:*
        UDP    192.168.224.129:138    *:*

       

      Anyone experience this can help me to understand ?  btw what is TNS listener ?