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!

ORA-01031: insufficient privileges -- Very annoying after All Grants etc.Please help

997915Apr 2 2015 — edited Apr 2 2015

Hello Experts - I'm using Oracle Free database 12C in my local machine.( Windows 7 64bit) and Database Version below

Issue 1:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0

PL/SQL Release 12.1.0.2.0 - Production 0

CORE 12.1.0.2.0 Production 0

TNS for 64-bit Windows: Version 12.1.0.2.0 - Production 0

NLSRTL Version 12.1.0.2.0 - Production 0

GRANT CONNECT, RESOURCE to HR

GRANT ALL PRIVILEGES TO HR

GRANT DBA TO HR

Still I'm getting ORA-01031: insufficient privileges while connecting to Database.

Issue 2:

Second Issue is PLUGGABLE database.Every time when system shutdown.After I connect to DB.I need to run the following commands in order to connect DB.Any Idea why it is behaving like that?

1: sqlplus / as sysdba

2: ALTER SESSION SET CONTAINER = pdborcl;

3: ALTER PLUGGABLE DATABASE open;

Please help me!

Thanks,

Sandy

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2015

Added on Apr 2 2015

#general-database-discussions

9 comments

4,535 views