Database Networking (MOSC)

MOSC Banner

Difference between SID and SERVICE_ID in tnsnames.ora

edited Jul 1, 2016 3:40AM in Database Networking (MOSC) 1 commentAnswered ✓

I'm seeking for a technically exact explanation about the difference between SID and SERVICE_ID in the TNSNAMES.ORA alias assignment.

And, moreover, at which one can the domain extension be used and when?

Example:

EXAMPLE=

(DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver) (PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = ORCL )

    )

  )

vs.

EXAMPLE=

(DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver) (PORT = 1521))

    )

    (CONNECT_DATA =

      (SID = ORCL )

    )

  )

Sometimes I see (SERVER = DEDICATED) also in CONNECT_DATA. In opposite to what does that stand?

I already learnt that, if the GLOBAL DATABASE NAME  (GLOBAL_NAME) is set on the server, one has to use

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center