Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sqlplus /@SID throws ORA-01017: invalid username/password; logon denied

2932053Apr 28 2016 — edited Apr 29 2016

Hi ,

I am having 2 databases in a same server. i have both the db entries added in tnsnames.ora . I am not able to connect to a database by using sqlplus /@SID (where SID is name of db which is same as that of in tnsnames.ora) . The OS user is Oracle. I am able to login normally sqlplus /  , but i am not able to login as oracle that is sqlplus /@SID. I am able to do this in almost all the dbs mentioned in tnsnames.ora, but only for one db i am getting this error.

DB version is 11.2.0.4

OS : Red Hat Enterprise Linux Server release 6.7 (Santiago)

Below is the error log:

$ sqlplus /@EUQAUX

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 28 11:43:56 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:

ORA-01017: invalid username/password; logon denied

This post has been answered by 3223386 on Apr 28 2016
Jump to Answer

Comments

Kris Rice-Oracle

Right now the license doesn't have anything to allow redistribution of sqlcl.  I will check with legal about possibilities of adding such a clause.  So the short answer is right now the customer would have to download the files.  The license is on the download page

Oracle SQL Developer License Terms

-kris

thatJeffSmith-Oracle

You may not:

- remove or modify any program markings or any notice of our proprietary rights;

- make the programs available in any manner to any third party, other than as specified above;

- use the programs for any purpose other than as provided above;

- assign this agreement or give or transfer the programs or an interest in them to another individual or entity;

- cause or permit reverse engineering (unless required by law for interoperability), disassembly or decompilation of the programs;

- disclose results of any program benchmark tests without our prior consent.

the specified above part is

We grant you a nonexclusive, nontransferable limited license to use the programs solely for your business operations and any third party training as part of such business operations.

Contact your Oracle account representative, they can give you a better answer than I, but as I understand it, the answer to your question is 'no'.

User_SAFN8

Jeff Smith Sqldev Pm-Oracle wrote:

Contact your Oracle account representative, they can give you a better answer than I, but as I understand it, the answer to your question is 'no'.

The Oracle product manager (‘Senior Principal Product Manager’) is not sure about the licensing terms of the software he is working with ? (I understand you don't want to say publicly anything "definitive", but I'm also sure you got the point.)

Alex-D

@"839293"

This may come as a surprise to you, but product managers don't do "everything" at the big companies like Oracle.

Regards

The answer is 'no' - you can't do that.

Better?

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 27 2016
Added on Apr 28 2016
18 comments
16,146 views