Oracle Database Discussions

Hi

DB - 10gr2 on Vista
Oracle Forms - Forms Builder [32 Bit] Version 10.1.2.0.2 (Production)


I have a problem with TNS Listener service and have following concerns

1. In the following Oracle related services in what sequence they start up on reboot (if set to automatic)
- OracleJobSchedulerORCL
- OrcleMTSRecoveryService
- OracleoraDb10g_home1TNSListener
- OracleServiceORCL
- OracleOraDb10g_home1iSQL*Plus
- OrcaleDBConsoleorcl

(Are there any more services which I missed) Version - 10gR2

2. For following out put where it gets the parameters (HOST=.. PORT=1521....)
Why HOST= part is missing

    C:\Users\Shabar>lsnrctl start

    LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 20-DEC-2009 22:02
    :19

    Copyright (c) 1991, 2006, Oracle.  All rights reserved.

    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production
    Log messages written to C:\DevSuiteHome_1\network\log\listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Shabar-PC)(PORT=1521))
    )

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    TNS-12537: TNS:connection closed
    TNS-12560: TNS:protocol adapter error
      TNS-00507: Connection closed
       32-bit Windows Error: 109: Unknown error

    C:\Users\Shabar>

{code}


3. I have installed both Db and Forms Builder [32 Bit] Version 10.1.2.0.2 (Production). But DB path lintener.log [C:\oracle10gR2\product\10.2.0\db_1\network\admin\listener.ora] is not updated. Any reason?

Following is the Form builder path litener.log output part to particular occasion (this is updating)

TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production on 26-DEC-2009 14:27:24

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Log messages written to C:\DevSuiteHome_1\network\log\listener.log
Trace information written to C:\DevSuiteHome_1\network\trace\listener.trc
Trace level is currently 0

Started with pid=2224
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Shabar-PC)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

4. In tnsname.ora file I find two port numbers.(1521 and 1522) Is that correct? If so any specific reason?

{Code}
l
    # tnsnames.ora Network Configuration File: C:\oracle10gR2\product\10.2.0\db_1\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    LISTENER_ORCL =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Shabar-PC)(PORT = 1522))


    ORCL =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = Shabar-PC)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl)
        )
      )

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

Your advice is appreciated



Cheers

Shabar