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

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
>

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