Jump to content


Photo
- - - - -

Oracle Database Connection Setup

Database Setup Wizard

  • Please log in to reply
9 replies to this topic

#1 greg.duncan

greg.duncan

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 04 March 2016 - 10:32 AM

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".
 

 



#2 Ian C - BarTender ninja @ Seagull

Ian C - BarTender ninja @ Seagull

    Technical Services Specialist, EMEA

  • Administrators
  • 2,821 posts
  • LocationMadrid

Posted 19 March 2016 - 04:50 AM

Make sure you have R2 installed: http://www.seagullsc...-versions/2016/



#3 greg.duncan

greg.duncan

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 21 March 2016 - 12:35 PM

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.



#4 Ian C - BarTender ninja @ Seagull

Ian C - BarTender ninja @ Seagull

    Technical Services Specialist, EMEA

  • Administrators
  • 2,821 posts
  • LocationMadrid

Posted 28 March 2016 - 04:31 AM

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



#5 greg.duncan

greg.duncan

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 29 March 2016 - 05:32 AM

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.



#6 konstantin1

konstantin1

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 31 March 2016 - 07:14 AM

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.



#7 greg.duncan

greg.duncan

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 01 April 2016 - 11:48 AM

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.



#8 Ian C - BarTender ninja @ Seagull

Ian C - BarTender ninja @ Seagull

    Technical Services Specialist, EMEA

  • Administrators
  • 2,821 posts
  • LocationMadrid

Posted 02 April 2016 - 12:55 AM

I suggest you get in touch with tech-support to help you work through the issue: http://www.seagullsc...hnical-support/



#9 konstantin1

konstantin1

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 02 April 2016 - 09:31 AM

I suggest you get in touch with tech-support to help you work through the issue: http://www.seagullsc...hnical-support/

 

Can we ask the tech support since we try out the product ?

I myself have many problem connecting with Oracle and the provided info for such a product is less than satisfactory..



#10 Ian C - BarTender ninja @ Seagull

Ian C - BarTender ninja @ Seagull

    Technical Services Specialist, EMEA

  • Administrators
  • 2,821 posts
  • LocationMadrid

Posted 03 April 2016 - 10:09 AM

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






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users