RE: ORA-01017 on login to database as SYS as SYSDBA remotely
Date: Wed, 5 Jul 2017 13:55:17 +0000
Message-ID: <15115_1499262930_595CEFD1_15115_2057_1_ECDEF0CC6716EC4596FCBC871F48292AB18A246A_at_ZRH-S231>
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: _at_NenadNoveljic
Home page: http://nenadnoveljic.com/
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark J. Bobak
Sent: Mittwoch, 5. Juli 2017 15:46
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_at_my_db as sysdba' remotely.
Here's what I see:
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:
Enter user-name: / as sysdba
Connected to:
SQL> select * from v$pwfile_users;
no rows selected
To: ORACLE-L
Subject: ORA-01017 on login to database as SYS as SYSDBA remotely
[oracle_at_mappr2 ~]$ . oraenv
ORACLE_SID = [MY_DB] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle_at_mappr2 ~]$ orapwd file=?/dbs/orapw_at_ force=y password=MyPassword123 ignorecase=no
[oracle_at_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_at_mappr2 ~]$ . oraenv
ORACLE_SID = [MY_DB] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle_at_mappr2 ~]$ sqlplus sys/MyPassword123_at_MY_DB as sysdba
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
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option
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>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 05 2017 - 15:55:17 CEST