Jump to content
greg.duncan

Oracle Database Connection Setup

Recommended Posts

greg.duncan

I am trying out Bartender 11.0.1.3045 to see if it will work with our Oracle database.
I click on the icon for "Database Connection Setup".

On this popup click on the "New Record Set" icon in bottom left corner.
Select Oracle. Next.

In the Server field I put the IP address for my database server.

Check "Specify user name and password" and enter my login account and password.

 

Where do I specify the database name?

 

With just the basic info and no database name the "Test Connection" gives "ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA".

 

Tried just the tnsnames.ora entry for database in Server field but when I "Test Connection" get "ORA-12154: TNS:could not resolve the connect identifier specified".
 

 

  • Like 49

Share this post


Link to post
Share on other sites
greg.duncan

Installed the R2 version. I was on version R1.

In database setup when I select Oracle as the type of database,

in server field enter my ip address for database server, specify a user

name and password for database authentication.

Getting error:

ORA-12504: TNSlistener was not given the SERVICE_NAME in CONNECT_DATA.

 

Where do I put the tnsnames.ora entry to tell it which database I am connecting?

 

Thanks.

Share this post


Link to post
Share on other sites
Ian C - BarTender ninja @ Seagull

I've not used Oracle databases myself, so am no expert, but wouldn't you also need to specify the name of the database server and not just the computer name/IP?  For example: 195.168.1.123\myDBServer

Share this post


Link to post
Share on other sites
greg.duncan

I have tried just the server ip in Server field and different combinations of database name in the Server field with the server ip address but get

ORA-12154: TNS:could not resolve the connect identifier specified.

each time.  So my syntax is not correct.

 

Thanks.

Share this post


Link to post
Share on other sites
konstantin1

I have tried just the server ip in Server field and different combinations of database name in the Server field with the server ip address but get

ORA-12154: TNS:could not resolve the connect identifier specified.

each time.  So my syntax is not correct.

 

Thanks.

 

I had the same problem with Bartender 2016 R2 and Oracle 11g. After a very painful search i found out that you should put on the "Server" text the info like: <IP>/<sid> e.g 192.168.10.3/orcl where this IP is your server`s IP and sid is your Oracle instance name you would like to connect.

Share this post


Link to post
Share on other sites
greg.duncan

Tried with my server ip a slash and then my database SID:   x.x.x.x/SID

Get a pop up box   labeled "Error Connecting", ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

 

I can then take what I put in the server field and use with TNSPING command and it shows connection to server and SID is OK.

Share this post


Link to post
Share on other sites
Ian C - BarTender ninja @ Seagull

Yes you can contact tech-support, even if you're only using the Trial edition currently.

Share this post


Link to post
Share on other sites

×