Re: Strange Error In SQL*Plus
Date: Tue, 17 Jan 2017 20:10:36 +0000
Message-ID: <BN3PR0101MB10769A360587506A7B838043DD7C0_at_BN3PR0101MB1076.prod.exchangelabs.com>
Maybe this has already been suggested but could the difference be OS group membership?
Steve
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Scott Canaan <srcdco_at_rit.edu> Sent: Wednesday, 18 January 2017 7:04:59 AM To: Scott Canaan; ORACLE-L
Subject: RE: Strange Error In SQL*Plus
Here are the results from a brand new VM that works:
$ export ORACLE_HOME=/oracle/app/product/12.1.0.2
$ export ORACLE_SID=CMAPPROD
$ $ORACLE_HOME/bin/sqlplus
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 17 15:00:58 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> And one from the VM that doesn't work:
$ export ORACLE_HOME=/oracle/app/product/12.1.0.2
$ export ORACLE_SID=RHATPROD
$ sqlplus
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 17 15:01:48 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
Supposedly, they are both created identical. Neither have a database on them yet. Nothing has been setup other than the two exports I did just prior to running SQL*Plus. Clearly something is different, but I can't figure out what it might be or where to look.
Scott Canaan '88 (srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>)
(585) 475-7886 - work (585) 339-8659 - cell"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Scott Canaan
Sent: Tuesday, January 17, 2017 2:58 PM
To: xt.and.r_at_gmail.com; Hans Forbrich
Cc: ORACLE-L
Subject: RE: Strange Error In SQL*Plus
There isn't one yet. There's no database yet. I'm trying to create one.
Scott Canaan '88 (srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>)
(585) 475-7886 - work (585) 339-8659 - cell"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sayan Malakshinov
Sent: Tuesday, January 17, 2017 2:56 PM
To: Hans Forbrich
Cc: ORACLE-L
Subject: Re: Strange Error In SQL*Plus
Scott,
I'd also check password file
This email is intended solely for the use of the addressee and may contain information that is confidential, proprietary, or both. If you receive this email in error please immediately notify the sender and delete the email.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 17 2017 - 21:10:36 CET