OraFAQ Forum: Server Administration » Not able to connect using SID

Home » RDBMS Server » Server Administration » Not able to connect using SID (Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not able to connect using SID [message #669769]

Fri, 11 May 2018 00:40

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.

Report message to a moderator

Re: Not able to connect using SID [message #669770 is a reply to message #669769]

Fri, 11 May 2018 00:46

John Watson
Messages: 8960
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.

Report message to a moderator

Re: Not able to connect using SID [message #669771 is a reply to message #669770]

Fri, 11 May 2018 01:03

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"

Report message to a moderator

Re: Not able to connect using SID [message #669772 is a reply to message #669771]

Fri, 11 May 2018 01:08

John Watson
Messages: 8960
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

Report message to a moderator

Re: Not able to connect using SID [message #669773 is a reply to message #669772]

Fri, 11 May 2018 01:27

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

Attachment: using Servicename.PNG
(Size: 67.81KB, Downloaded 2389 times)

Report message to a moderator

Re: Not able to connect using SID [message #669774 is a reply to message #669773]

Fri, 11 May 2018 01:28

MeghaB
Messages: 22
Registered: April 2018

Junior Member

Using SID

Attachment: using SID.PNG
(Size: 69.94KB, Downloaded 2356 times)

Report message to a moderator

Re: Not able to connect using SID [message #669775 is a reply to message #669772]

Fri, 11 May 2018 02:18

MeghaB
Messages: 22
Registered: April 2018

Junior Member

Still i didnt answer your question properly?

Report message to a moderator

Re: Not able to connect using SID [message #669776 is a reply to message #669773]

Fri, 11 May 2018 02:19

John Watson
Messages: 8960
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

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.

Report message to a moderator

Previous Topic:	ORA-01017 after restore to a test server
Next Topic:	Upgrading Oracle Grid Infrastructure from 12cR1 to 12cR2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 11:44:09 CST 2024