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

Hello Mark,

I assume it is a single instance Database by the name of your instance. I would try "alter user sys identified by MyPassword123;".

*Kind regards / Cordialmente / Saludos cordiales / Sincères amitiés / Mit freundlichen Grüßen / Cordiali saluti,*

Franky Weber Faust
Oracle DBA
Skype: franky.faust

2017-07-05 10:46 GMT-03:00 Mark J. Bobak <mark_at_bobak.net>:

> 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
>

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