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!

ORA-65096 installing Oracle 12cR1 Example Schemas

Dude!Oct 13 2013 — edited Feb 14 2014

Hi,

Database: 12cR1, 12.0.1.0, x64

System: Oracle Linux 6.4, x64

I installed a simple starter database during the installation of Oracle Database 12cR1 with the PDBORCL option selected (default) and would like to install the Oracle Example data, such as users HR schema, etc. according to http://docs.oracle.com/cd/E16655_01/server.121/e15979/installation.htm#I4367

@?/demo/schema/human_resources/hr_main.sql

CREATE USER hr IDENTIFIED BY hr

            *

ERROR at line 1:

ORA-65096: invalid common user or role name

Perhaps the scripts were not designed for container and plug-able databases. I did the following:

alter pluggable database pdborcl open;

alter session set container=PDBORCL;

@?/demo/schema/human_resources/hr_main.sql

User altered.

Grant succeeded.

Grant succeeded.

Connected.

GRANT execute ON sys.dbms_stats TO hr

                                   *

ERROR at line 1:

ORA-01917: user or role 'HR' does not exist

I could probably create a normal database, but I wonder if there is any other option without having to modify the setup scripts.

Thanks!

This post has been answered by polosoft.com on Feb 14 2014
Jump to Answer

Comments

Vadim Tropashko-Oracle
Answer

There was a trivial case sensitivity bug that prevented parser from recognizing pl/sql source. For example,

CREATE OR REPLACE PACKAGE TEST_PACK as

procedure test (

   p_arg1 in varchar2 default 'AbcD',

   p_arg2 in number   default null);

end;

/

would be recognized (no matter what extension file had), while

CREATE OR REPLACE package ...

---------------------------------^^^^^^^^

won't be. This is fixed, of course, for RC1.

Marked as Answer by 906783 · Sep 27 2020
906783

Version 4.1.0.19.07

Bug still there

.pck file, opening line is

/*

$Log:   ...............

*/

Not formatted as per pl/sql file.

No coloured keywords.

Vadim Tropashko-Oracle

SQL & PL/SQL  source recognition works the following way:


1. If file extension is listed, then file is opened with associated editor. However this is broken in 4.1 (fix scheduled for 4.1.1 patch).

2. The first 5000 characters of the file content are scanned, and parsed. If the first several words are recognized as legitimate PL/SQL then the file is opened with PL/SQL editor. As this doesn't work in your case, how big is the comment? Is it longer than 50 lines? If the comment is short, can you please post the beginning of your file up to the line "create or replace package X" so that I can check where recognition failed?

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 14 2014
Added on Oct 13 2013
9 comments
36,290 views