Oracle Database Connection Setup
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".
-
Make sure you have R2 installed: http://www.seagullscientific.com/support/service-releases-legacy-versions/2016/
0 -
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.
0 -
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
0 -
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.
0 -
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.
0 -
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.
0 -
I suggest you get in touch with tech-support to help you work through the issue: http://www.seagullscientific.com/support/technical-support/
0 -
I suggest you get in touch with tech-support to help you work through the issue: http://www.seagullscientific.com/support/technical-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..
0 -
Yes you can contact tech-support, even if you're only using the Trial edition currently.
0
請登入寫評論。
評論
9 條評論