Dou you possibly have a static listener configuration? If yes, please check if
the Oracle home in listener.ora is correct.
I think you should truss the listener process (including child processes) and
not sqlplus in order to capture the file access to orapw.
Regards,
Nenad
Twitter: @NenadNoveljic
Home page: http://nenadnoveljic.com/
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Mark J. Bobak
Sent: Mittwoch, 5. Juli 2017 15:46
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
____________________________________________________
Please consider the environment before printing this e-mail.
Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">p { font-family: Arial;font-size:9pt }</style>
</head>
<body>
<p>
<br>Important Notice</br>
<br>This message is intended only for the individual named. It may contain
confidential or privileged information. If you are not the named addressee you
should in particular not disseminate, distribute, modify or copy this e-mail.
Please notify the sender immediately by e-mail, if you have received this
message by mistake and delete it from your system.</br>
<br>E-mail transmission may not be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
processing of incoming e-mails cannot be guaranteed. All liability of the
Vontobel Group and its affiliates for any damages resulting from e-mail use is
excluded. You are advised that urgent and time sensitive messages should not be
sent by e-mail and if verification is required please request a printed
version.<br/>
</p>
</body>
</html>
