Re: After Creating New Dtabase...

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 22 Jun 2004 03:48:35 -0700
Message-ID: <ea01504d.0406220248.32f18716@posting.google.com>

Dear Sir,
Whatever you told is absolutely right.At the time of installation I created a database called

"systel1" (I refered as FirstDB)

after that for new project I create

"heildb" (I refered as SecondDB)

But due to my company restriction I couldn't give you all the details.But now I got
the permission to give all the details.

---

---

TNSNAMES.ORA containg

---

---

SYSTEL1.SHANTA.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = systel1.shanta.local)(PORT =
1521))

    )
    (CONNECT_DATA =
(SERVICE_NAME = systel1)

    )
  )

HEILDB.SHANTA.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = systel1.shanta.local)(PORT =
1521))

    )
    (CONNECT_DATA =
(SERVICE_NAME = heildb)

    )
  )

---

---

LISTENER.ORA Containg

---

---

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

---

---

Output of lsnrctl services

---

---

C:\>lsnrctl services

LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 22-JUN-2004 15:55:53 (c) Copyright 1998 Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=systel1.shanta.local)(PORT=1521))) Services Summary...
  Systel1 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))

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


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

  Systel1               has 3 service handler(s)
    DEDICATED SERVER established:4 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
  heildb                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: 2672>


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

      Presentation: oracle.aurora.server.SGiopServer

The command completed successfully

C:\>

---

---

After setting SET ORACLE_SID=heildb 
==========================================================
==========================================================

C:\>SET ORACLE_SID=heildb

C:\>sqlplus "scott/tiger"

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jun 22 15:58:04 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> SELECT global_name FROM global_name;

GLOBAL_NAME

---

HEILDB.US.ORACLE.COM SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

C:\>sqlplus "scott/tiger_at_systel1"

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jun 22 15:58:55 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> SELECT global_name FROM global_name;

GLOBAL_NAME

---

SYSTEL1.US.ORACLE.COM SQL>

---

---

After setting SET ORACLE_SID=systel1
====================================================================
====================================================================

C:\>SET ORACLE_SID=systel1

C:\>sqlplus "scott/tiger"

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jun 22 16:00:55 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> SELECT global_name FROM global_name;

GLOBAL_NAME

---

SYSTEL1.US.ORACLE.COM SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

C:\>sqlplus "scott/tiger_at_heildb"

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jun 22 16:01:12 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor

Enter user-name: scott
Enter password:<tiger>

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> SELECT global_name FROM global_name;

GLOBAL_NAME

---

SYSTEL1.US.ORACLE.COM SQL> exit

---

---

These are all the details.Thanks for your kind attention. Regards
Arijit Chatterjee Received on Tue Jun 22 2004 - 05:48:35 CDT