Home » RDBMS Server » Server Administration » Not able to connect using SID (Linux)
Not able to connect using SID [message #669769] Fri, 11 May 2018 00:40 Go to next message
MeghaB
Messages: 22
Registered: April 2018
Junior Member
I am having two database in same server. I am able to connect to one database inside the server but not possible from outside, the other database i am not able to connect inside server but its able to connect from outside without specifying SID.(through IDE). I want to connect to the second database using SID, if i didnt mention SID i am able to connect but if i mention not able to connect.

let me now what s the issue.
Re: Not able to connect using SID [message #669770 is a reply to message #669769] Fri, 11 May 2018 00:46 Go to previous messageGo to next message
John Watson
Messages: 7777
Registered: January 2010
Location: Global Village
Senior Member
The issue is that you have provided no information about the configuration, what you are doing, what the errors are, nothing.
Re: Not able to connect using SID [message #669771 is a reply to message #669770] Fri, 11 May 2018 01:03 Go to previous messageGo to next message
MeghaB
Messages: 22
Registered: April 2018
Junior Member
If i am providing the service name to connect to the database its connecting through IDE(sql developer) But instead of service name if i am providing SID its showing "invalid username/password". 2 Users are there, Sys and x_sys.. Inside server able to connect to sys, but when tried to connect to x_sys its showing "invalid username/password"
Re: Not able to connect using SID [message #669772 is a reply to message #669771] Fri, 11 May 2018 01:08 Go to previous messageGo to next message
John Watson
Messages: 7777
Registered: January 2010
Location: Global Village
Senior Member
This looks suspiciously like trolling: being deliberately stupid, in an attempt to make people angry. I shall be generous, and assume that this is not deliberate.

You need to show what you are doing, and what happens. I have no idea what you are providing, to whom, or the result. Use SQL*Plus, and copy/paste the whole session here. Be sure to format the paste with [code] tags, as described here How to use code tags and make your code easier to read
Re: Not able to connect using SID [message #669773 is a reply to message #669772] Fri, 11 May 2018 01:27 Go to previous messageGo to next message
MeghaB
Messages: 22
Registered: April 2018
Junior Member
please find the screenshot attached which will be much more clear i guess. One is by using servicename and one by using SID
Re: Not able to connect using SID [message #669774 is a reply to message #669773] Fri, 11 May 2018 01:28 Go to previous messageGo to next message
MeghaB
Messages: 22
Registered: April 2018
Junior Member
Using SID
  • Attachment: using SID.PNG
    (Size: 69.94KB, Downloaded 571 times)
Re: Not able to connect using SID [message #669775 is a reply to message #669772] Fri, 11 May 2018 02:18 Go to previous messageGo to next message
MeghaB
Messages: 22
Registered: April 2018
Junior Member
Still i didnt answer your question properly?
Re: Not able to connect using SID [message #669776 is a reply to message #669773] Fri, 11 May 2018 02:19 Go to previous messageGo to next message
John Watson
Messages: 7777
Registered: January 2010
Location: Global Village
Senior Member
THis has to be trolling. No-one can actually be so stupid as to say that he is connecting with service name or SID, and then show screen shots where the service name and the sid have not been specified, and neither the hostname.

Goodbye.

[Updated on: Fri, 11 May 2018 02:20]

Report message to a moderator

Re: Not able to connect using SID [message #669777 is a reply to message #669776] Fri, 11 May 2018 02:24 Go to previous message
MeghaB
Messages: 22
Registered: April 2018
Junior Member
i have specified everything and then tried to connect. After that i have erased those. If i am trying to connect with sqlplus username/password@SID i am getting the same error "invalid username/password. logon denied" What else information is missing? and without specifying SID i am able to connect.
Previous Topic: ORA-01017 after restore to a test server
Next Topic: Upgrading Oracle Grid Infrastructure from 12cR1 to 12cR2
Goto Forum:
  


Current Time: Sat Feb 23 14:10:38 CST 2019