Help Needed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • oasis
    New Member
    • Jan 2008
    • 4

    Help Needed

    HELP NEEDED : I have developed a testing system thats generates question paper. i want to display this paper to 20 different users in a Server/Client architecture.
    is there any built-in function in oracle that supports this kind of Situstion or how
    can i distungish between the different computer(IPS) in oracle .
  • Dave44
    New Member
    • Feb 2007
    • 153

    #2
    Originally posted by oasis
    HELP NEEDED : I have developed a testing system thats generates question paper. i want to display this paper to 20 different users in a Server/Client architecture.
    is there any built-in function in oracle that supports this kind of Situstion or how
    can i distungish between the different computer(IPS) in oracle .
    Im not sure i understand what you are asking... you need to be more specific. are the questions in a table? more info needed.

    Comment

    • subashsavji
      New Member
      • Jan 2008
      • 93

      #3
      Originally posted by oasis
      HELP NEEDED : I have developed a testing system thats generates question paper. i want to display this paper to 20 different users in a Server/Client architecture.
      is there any built-in function in oracle that supports this kind of Situstion or how
      can i distungish between the different computer(IPS) in oracle .
      whats your frontend tools and what you are trying. Plz. be more specific.

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        If you are trying to access the database from 20 different systems no problem. Oracle client must be installed in all those systems. You don't need IP of the systems . Just have to configure TNSNAMES.ORA file in the client system.

        Comment

        • oasis
          New Member
          • Jan 2008
          • 4

          #5
          Originally posted by debasisdas
          If you are trying to access the database from 20 different systems no problem. Oracle client must be installed in all those systems. You don't need IP of the systems . Just have to configure TNSNAMES.ORA file in the client system.

          Thanks :
          you got my point. i will try to do that. can you please tell me
          in more detail about how to configure
          TNSNAMES.ORA file in the client systems.

          Comment

          • debasisdas
            Recognized Expert Expert
            • Dec 2006
            • 8119

            #6
            TNSNAMES.ORA files includes entries like this
            [code=oracle]
            MES =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.15.3)(POR T = 1521))
            )
            (CONNECT_DATA =
            (SID = MES)
            )
            )
            BDCORA =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.12.16)(PO RT = 1521))
            )
            (CONNECT_DATA =
            (SERVICE_NAME = orcl1)
            )
            )

            MESTEST =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.14.155)(P ORT = 1521))
            )
            (CONNECT_DATA =
            (SERVICE_NAME = MESTEST)
            )
            )

            [/code]

            You need to make the changes as per your requirment by changing the database name and the Server IP.

            Comment

            Working...