Billing and Revenue Management (MOSC)

MOSC Banner

Installing multi-schema on BRM 7.5 PS 17

edited Apr 18, 2017 5:04AM in Billing and Revenue Management (MOSC) 1 commentAnswered

Hello,

I am trying to set up multi-schema on BRM 7.5 PS 17. I am using two schemas for this: schema 1 and schema 2.

When running the mulit-schema config script -  pin_multidb.pl -i STEP 7  I get the following errors:

DATABASE LINK MD_PRIMARY does not exist

creating DATABASE LINK MD_PRIMARY...

PL/SQL procedure successfully completed.

SQL> SQL> 2 3 4 CREATE DATABASE LINK MD_PRIMARY

*

ERROR at line 1:

ORA-01031: insufficient privileges

And:

SQL> Creating Views on SMADEV

SQL> BEGIN create_views('PIN'); END;

*

ERROR at line 1:

ORA-06550: line 1, column 7:

PLS-00905: object BRM2.CREATE_VIEWS is invalid

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center