Hey
@daybon,
Sounds like you need to alter the connection string parameters.
Im going off memory here, but i remember reading a couple of years ago about differences between the connection string when you are using SERVICE NAME rather than SID.
So! Obviously i dont know what setup you have and whether youre trying to connect using SERVICE NAME rather than SID, but Im guessing you have either the wrong parameters in your connection string (if connecting via SID) or the wrong connection string itself. Im typing this on my phone, but if i remember correctly, the default Oracle connection string in the JDBC config is for the SID option.
So if i were trying to fix this on my laptop, id confirm whether SID or SERVICE NAME and if SID, Id confirm the parm values with the DBAs and if using SERVICE NAME, id create a second Oracle connection string in the JDBC preferences matching the published layout for trying to connect using JDBC using SERVICE NAME.
Cheers,
Rich
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
