No question at this time
DBA Top 10
1 A. Kavsek 8400
2 B. Vroman 5900
3 M. Cadot 5400
4 P. Wisse 4800
5 T. Boles 3700
6 J. Schnackenberg 2100
7 . Lauri 1500
8 R. Pattyn 700
9 T. P 600
9 J. PĂ©ran 600
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48407
Total active users1518
Act. users last 24h4
Act. users last hour1
Registered user hits last week254
Registered user hits last month927
Go up

Oracle easy connect
Next thread: Golden Gate Replication
Prev thread: ORA-00600 Error in Oracle 12.1 database

Message Score Author Date
Hi, Does someone has experience with Oracle eas...... Lauri Jul 18, 2019, 09:48
Yes, I like the ezconnect syntax. It is straigh...... Philip Wisse Jul 18, 2019, 10:14
Hi, Thanks. Yes, I understand what it is. But,...... Lauri Jul 18, 2019, 10:49
Lauri, > Furthermore what needs to be configure...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Jul 18, 2019, 17:23
Hi, > But, why should I use it instead of tnsna...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Ales Kavsek Jul 19, 2019, 13:01
@Ales: I tend to have the same choices than you.... Lauri Jul 22, 2019, 15:06

Follow up by mail Click here


Subject: Oracle easy connect
Author: Lauri, Netherlands
Date: Jul 18, 2019, 09:48, 32 days ago
Os info: All
Oracle info: Oracle 12c and onward
Error info: na
Message: Hi,

Does someone has experience with Oracle easy connect (EZCONNECT)?
I undertand that it is a naming method that eliminates the need for service name lookups in tsnames.ora.
But why should I choose for EZCONNECT instead of using tsnames.ora?
Furthermore what needs to be configured at databaee level (I guess I listener level) to make use of Oracle easy connect?

Kind Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle easy connect
Author: Philip Wisse, Netherlands
Date: Jul 18, 2019, 10:14, 32 days ago
Message: Yes,

I like the ezconnect syntax. It is straightforward.

https://www.orafaq.com/wiki/EZCONNECT

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Oracle easy connect
Author: Lauri, Netherlands
Date: Jul 18, 2019, 10:49, 32 days ago
Message: Hi,

Thanks. Yes, I understand what it is.
But, why should I use it instead of tnsnames.ora?
Why do you like it for instance?
The way around, when should I not use it.
Personally, I like more tnsnames.ora because it "masks" the conencting information.

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-Oracle easy connect
Author: Philip Wisse, Netherlands
Date: Jul 18, 2019, 17:23, 32 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Lauri,

> Furthermore what needs to be configured at databaee level (I guess I listener level) to make use of Oracle easy connect?

Ezconnect is just a client side syntax.
You can use it as an alternative to other methods.

At the serverside nothing special, nothing different.

> But, why should I use it instead of tnsnames.ora?

It makes testing easier, like tnsping.
Also I use it for database links.

> The way around, when should I not use it.

When you want to test the tnsnames.ora file.

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-Oracle easy connect
Author: Ales Kavsek, Slovenia
Date: Jul 19, 2019, 13:01, 31 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi,

> But, why should I use it instead of tnsnames.ora?

When you want to avoid tnsnames.ora for example. Sometimes end users don't have write access for tnsnames.ora (often developers), just use easy connect in the code to connect to some server that's not in the tnsnames.ora file.

> Why do you like it for instance?

Convenience!? Mostly while scripting (python), but in general I prefer tnsnames.ora because of the abstraction (I don't like to have hostnames/ip's/service names present in the production code or in the application config files).

> The way around, when should I not use it.

If you want:
- abstraction (de-couple technicalities of connection from the source code). With easy connect it's easy to end up with hostnames, ip's, service names scattered all over the code base, this could become a real nightmare during migrations,
- when you need to use advanced parameters (load balancing, failover) that can't be part of easy connect syntax. Tnsnames.ora (or full TNS code in the connect string) is your only friend.

Regards,
Ales

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Oracle easy connect
Author: Lauri, Netherlands
Date: Jul 22, 2019, 15:06, 28 days ago
Message: @Ales: I tend to have the same choices than you.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here