Different kind of login

[rbrooker]

Hi,

where i work we have about 130 databases with not all of them in my tnsnames. i could add them all ( !! ) to be able to access them, but thats work.

what would be cool is ( similar to something small green and croaky ) if there was somewhere you could put in hostort:sid so that it would "create" a tns entry on the fly.

would save me many many keystrokes..

thanks.

 

[Dezsoe Kados]

I am using the "hostort/sid" syntax in the database field and it works for me.

 

[Marco Kalter]

Correct. This requires that you add EZCONNECT to the NAMES.DIRECTORY_PATH the sqlnet.ora file. For example:

NAMES.DIRECTORY_PATH=(TNSNAMES, EZCONNECT)

 

[rbrooker]

bingo boys... done.

this will make my life easier ( as long as i remember it is services and not sids that i need to enter )