Is it a chmod 775 that is needed on the orapwfile? . I've had this
recently.
On 5 July 2017 at 15:10, Powell, Mark <mark.powell2@xxxxxxx> wrote:
If you perform ls -l orapwMT_DB what are the file ownership and
permissions?
Mark Powell
Database Administration
(313) 592-5148
------------------------------
*From:* oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Mark J. Bobak <mark@xxxxxxxxx>
*Sent:* Wednesday, July 5, 2017 9:46:20 AM
*To:* ORACLE-L
*Subject:* ORA-01017 on login to database as SYS as SYSDBA remotely
Hi all,
Help! This is driving me nuts! I'm reasonably sure I'm overlooking
something simple....
Oracle 12.1.0.2 SE2 on Oracle Linux 7.2 x86-64
I can't login as 'sys@my_db as sysdba' remotely.
Here's what I see:
[oracle@mappr2 ~]$ . oraenv
ORACLE_SID = [MY_DB] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@mappr2 ~]$ orapwd file=?/dbs/orapw@ force=y
password=MyPassword123 ignorecase=no
[oracle@mappr2 ~]$ ls -l $ORACLE_HOME/dbs/orapwMY_DB
-rw-r----- 1 oracle oinstall 7680 Jul 3 19:24
/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwMY_DB
[oracle@mappr2 ~]$ . oraenv
ORACLE_SID = [MY_DB] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@mappr2 ~]$ sqlplus sys/MyPassword123@MY_DB as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Jul 3 19:25:31 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Enter user-name: / as sysdba
Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option
SQL> select * from v$pwfile_users;
no rows selected
SQL> show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
remote_login_passwordfile string EXCLUSIVE
Also, since I'm seeing the unable to obtain file status' error, I tried
tracing sqlplus with 'strace -ftt', but when I grepped the output for
'open' call and then for 'orapw' I don't even see any attempt to open the
password file?
Anyhow, I've got an SR open w/ Oracle, but if anyone has any suggestions,
I'm all ears.
Thanks,
-Mark