Re: ORA-01017 on login to database as SYS as SYSDBA remotely

Yes you need execute on the PW file don't you?

On 5 July 2017 at 15:13, Mark J. Bobak <mark_at_bobak.net> wrote:

> Franky,
>
> When I change sys password, it's successful, no error.
>
> Nenad,
>
> Thanks for the suggestion, but ORACLE_HOME looks ok in SID_LIST_LISTENER
> in listener.ora.
>
> Mark,
>
> Output already procvided in original post. Looks ok.
>
> Thanks all,
>
> -Mark
>
> On Wed, Jul 5, 2017 at 10:10 AM, Powell, Mark <mark.powell2_at_dxc.com>
> 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_at_freelists.org <oracle-l-bounce_at_freelists.org> on
>> behalf of Mark J. Bobak <mark_at_bobak.net>
>> *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_at_my_db as sysdba' remotely.
>>
>> Here's what I see:
>> [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
>>
>> 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
>>
>
>

-- 
Howard A. Latham

--
http://www.freelists.org/webpage/oracle-l