Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg: Error while connecting to a remote database as SYS user.

Konda_NagaprakashJun 17 2013 — edited Jun 17 2013

Hello all,


When i try to connect to a database as SYS user i'm getting the error as

ora-01017 invalid username/password logon denied

But it is logging from the local system where the oracle is installed.

I created the password file and checked the contents in v$pwfile_users.

The result is " no rows selected".

so when i try to grant sysdba to sys user

grant sysdba to sys;

i'm getting error as,

ORA-01994: GRANT failed: password file missing or disabled

Please help me in resolving this.

Regards,

Konda

This post has been answered by DK2010 on Jun 17 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2013
Added on Jun 17 2013
10 comments
375 views