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@xxxxxxx<mailto:srcdco@xxxxxxx>)
(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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Scott Canaan
Sent: Tuesday, January 17, 2017 2:58 PM
To: xt.and.r@xxxxxxxxx; 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@xxxxxxx<mailto:srcdco@xxxxxxx>)
(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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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