Re: After Creating New Dtabase...

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 21 Jun 2004 21:13:39 -0700
Message-ID: <ea01504d.0406212013.20f0d779@posting.google.com>

Dear Sir,
As per your requirement I am sending all details.

---

C:\Documents and Settings\Administrator>lsnrctl services

LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 01-JAN-2000 00:19:51 (c) Copyright 1998 Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=systel1.shanta.local)(PORT=1521))) Services Summary...
  FirstDB has 3 service handler(s)     DISPATCHER established:0 refused:0 current:0 max:1022 state:ready

      D000 <machine: SYSTEL1, pid: 1932>


      (ADDRESS=(PROTOCOL=tcp)(HOST=systel1.Shanta.local)(PORT=3496))

  SecondDB                has 3 service handler(s)
    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D000 <machine: SYSTEL1, pid: 4076>


      (ADDRESS=(PROTOCOL=tcp)(HOST=systel1.Shanta.local)(PORT=3394))

  FirstDB               has 3 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D001 <machine: SYSTEL1, pid: 1720>


      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=systel1.Shanta.local)(PORT=3498))(PRESENTATION=oracle.aurora.server.SGiopServer)(SESSION=RAW))

      Presentation: oracle.aurora.server.SGiopServer
  SecondDB                has 3 service handler(s)
    DEDICATED SERVER established:0 refused:0
      LOCAL SERVER
    DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
      D001 <machine: SYSTEL1, pid: 4080>


      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=systel1.Shanta.local)(PORT=3395))(PRESENTATION=oracle.aurora.server.SGiopServer)(SESSION=RAW))

      Presentation: oracle.aurora.server.SGiopServer

The command completed successfully

---

TNSNAMES.ORA Details

FirstDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = systel1.shanta.local)(PORT =
1521))

    )
    (CONNECT_DATA =
(SERVICE_NAME = FirstDB)

    )
  )

SecondDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = systel1.shanta.local)(PORT =
1521))

    )
    (CONNECT_DATA =
(SERVICE_NAME = SecondDB)

    )
  )

---

LISTENER.ORA Details

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = systel1.shanta.local)(PORT = 1521))
  )

---

Regards
Arijit Chatterjee Received on Mon Jun 21 2004 - 23:13:39 CDT