Hi guys, before I get told that this needs to go via the normal support route... yes! I have already raised it with ETM Support but I am on a dead-line and I am currently not able to archive. I would really appreciate if someone could give me a hint as to what I am doing wrong..
I have a new Oracle XE 11.2 installation and I have successfully setup my tnsnames.ora and listener.ora files so I can tnsping
- (xe) my db instance
- EXTPROC_CONNECTION_DATA
- ORACLR_CONNECTION_DATA
I am using the PVSSOraExt.dll file since Oracle XE does not include the Java API
Now the win_install.bat script fails in two places and I suspect that this is what is generating a number of error messages relating to looping chains of synonyms... I have highlighted the problem areas in my RDB_setup.log below;
Any help is greatly appreciated....
Check for configuration file "./RDB_config.sql" ...
RDB Config: Defining RDB setup parameters
=========================================
RDB Setup for PVSSRDB_USER@xe
TimeZone is: Europe/London
Running script RDB_Schema_User.sql (new user)
=============================================
Connected.
Killing sessions
================
Elapsed: 00:00:00.01
Elapsed: 00:00:00.00
Deleting old tablespaces in new archive range
=============================================
Checking archive range between 100000 and 199999
SYSTEM 1 99999999
PVSSRDB_USER 100000 999999
Elapsed: 00:00:00.01
Info: Archive range is not unique.
Elapsed: 00:00:00.01
Checking archives of PVSSRDB_USER between 100000 and 199999
Elapsed: 00:00:00.01
Tablespace TS_PVSSRDB_USER dropped
CREATE TABLESPACE TS_PVSSRDB_USER LOGGING
DATAFILE 'C:\\oraclexe\\app\\oracle\\oradata\\XE\\TS_PVSSRDB_USER.dbf' SIZE 10M REUSE
AUTOEXTEND ON NEXT 10M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANA
GEMENT AUTO
CREATE USER PVSSRDB_USER IDENTIFIED BY ***** DEFAULT TABLESPACE TS_PVSSRDB_USER
Elapsed: 00:00:04.01
Granting privileges and permissions
===================================
R_APP_PVSSRDB already exists.
dbms_java.grant_permission(java_user,'SYS:java.io.FilePermission','','execute');
*
ERROR at line 7:
ORA-06550: line 7, column 5:
PLS-00201: identifier 'DBMS_JAVA.GRANT_PERMISSION' must be declared
ORA-06550: line 7, column 5:
PL/SQL: Statement ignored
ORA-06550: line 8, column 5:
PLS-00201: identifier 'DBMS_JAVA.GRANT_PERMISSION' must be declared
ORA-06550: line 8, column 5:
PL/SQL: Statement ignored
ORA-06550: line 9, column 5:
PLS-00201: identifier 'DBMS_JAVA.GRANT_PERMISSION' must be declared
ORA-06550: line 9, column 5:
PL/SQL: Statement ignored
ORA-06550: line 10, column 5:
PLS-00201: identifier 'DBMS_JAVA.GRANT_PERMISSION' must be declared
ORA-06550: line 10, column 5:
PL/SQL: Statement ignored
ORA-06550: line 11, column 5:
PLS-00201: identifier 'DBMS_JAVA.GRANT_PERMISSION' must be declared
ORA-06550: line 11, column 5:
PL/SQL: Statement ignored
ORA-06550: line 12, column 5:
PLS-00201: identifier 'DBMS_JAVA.GRANT_PERMISSION' must be declared
ORA-06550: line 12, column 5:
PL/SQL: Statement ignored
ORA-06550: line 14, column 5:
PLS-00201: identifier 'DBMS_JAVA.GRANT_PERMISSION' must be declared
ORA-065
Running script RDB_CreateAppUser.sql
====================================
Elapsed: 00:00:00.42
Connected.
Running script RDB_Archive_Tables.sql
====================================
Creating table SYSTEMS
======================
Creating table DPT
==================
Creating table DP
=================
Creating table DPE
==================
Creating table ELEMENTS
=======================
Running script RDB_PARAMTABLES
==============================
Creating tables and sequences
=============================
Creating trigger TRG_PATH_HISTORY
=================================
Creating views
==============
Inserting repository
====================
Creating user data types and LANGSTRING-package
===============================================
No errors.
Running script RDB_ArcTemplates (standard archive templates)
============================================================
Running script RDB_OCCIyes.sql
==============================
AL/EV_LV*-tables do not exist yet and will be created.
Lastval-Declaration-Tables created.
Packages
========
Creating dummy package header for compilation
Creating package ArcUtils
=========================
No errors.
Creating library PVSSEXTENSION
==============================
Creating package ARC_XPI
========================
No errors.
Creating package Valarch
========================
No errors.
Creating package ARCHIVECONTROL
===============================
No errors.
Creating package rdbHelpers
===========================
No errors.
Creating package StdTestRDB
===========================
No errors.
Submitting monitor jobs (activated: yes) and creating oracle directory objects
Running script RDB_ARCSITE.SQL
==============================
Inserting Data Into Table ARC_SITE and Defining File-Path xe@SVMCGBVDEVAP06
Anlage dynamisch ALERT: -2
Anlage dynamisch EVENT: -2
left join alerthistoryvalues hv on(h.ts = hv.ts and h.detail = hv.detail and h.element_id = hv.element_id))
*
ERROR at line 50:
ORA-01775: looping chain of synonyms
Running script RDB_AppUser.sql
==============================
Creating synonyms for the Application-User
==========================================
Granting object rights to role R_APP_PVSSRDB
============================================
grant select on ALERTHISTORYDBLINK to R_APP_PVSSRDB
*
ERROR at line 1:
ORA-01775: looping chain of synonyms
grant select on VALERTSCREEN to R_APP_PVSSRDB
*
ERROR at line 1:
ORA-01775: looping chain of synonyms
Creating package AC_INIT
========================
Running script XPI_USER
=======================
Connected.
Init Archive Data: 0
Running script CS_SETUP
=======================
Connected.
Running script CS_TABLES (Creating Tables)
==========================================
Creating package CS
===================
No errors.
Running script CS_CONTENTS
==========================
Running script CS_PRIVS.SQL
===========================
Creating Meta-Job
Running script CS_MONITORING
============================
Running script RDB_PublicUser.sql
=================================
create or replace public synonym ALERTHISTORYDBLINK for PVSSRDB_USER.ALERTHISTORYDBLINK
create or replace public synonym ARCHIVECONTROL for PVSSRDB_USER.ARCHIVECONTROL
create or replace public synonym ARCUTILS for PVSSRDB_USER.ARCUTILS
create or replace public synonym ARC_ARCHIVE for PVSSRDB_USER.ARC_ARCHIVE
create or replace public synonym ARC_CONFIG for PVSSRDB_USER.ARC_CONFIG
create or replace public synonym ARC_GROUP for PVSSRDB_USER.ARC_GROUP
create or replace public synonym ARC_GROUP_DEL for PVSSRDB_USER.ARC_GROUP_DEL
create or replace public synonym ARC_GRP_ARR for PVSSRDB_USER.ARC_GRP_ARR
create or replace public synonym ARC_HISTORYPATH for PVSSRDB_USER.ARC_HISTORYPATH
create or replace public synonym ARC_HISTTABLES for PVSSRDB_USER.ARC_HISTTABLES
create or replace public synonym ARC_LOG for PVSSRDB_USER.ARC_LOG
create or replace public synonym ARC_SITE for PVSSRDB_USER.ARC_SITE
create or replace public synonym ARC_STATEMENT for PVSSRDB_USER.ARC_STATEMENT
create or replace public synonym ARC_TEMPLATE for PVSSRDB_USER.ARC_TEMPLATE
create or replace public synonym ARC_XPI for PVSSRDB_USER.ARC_XPI
create or replace public synonym CS for PVSSRDB_USER.CS
create or replace public synonym CSCALCULATION for PVSSRDB_USER.CSCALCULATION
create or replace public synonym CSFUNCTION for PVSSRDB_USER.CSFUNCTION
create or replace public synonym CSINTERVAL for PVSSRDB_USER.CSINTERVAL
create or replace public synonym CSSTEP for PVSSRDB_USER.CSSTEP
create or replace public synonym CSTIMELOG for PVSSRDB_USER.CSTIMELOG
create or replace public synonym CSUNIT for PVSSRDB_USER.CSUNIT
create or replace public synonym DP for PVSSRDB_USER.DP
create or replace public synonym DPE for PVSSRDB_USER.DPE
create or replace public synonym DPT for PVSSRDB_USER.DPT
create or replace public synonym ELEMENTS for PVSSRDB_USER.ELEMENTS
create or replace public synonym JAVA_LOG for PVSSRDB_USER.JAVA_LOG
create or replace public synonym LANGSTRING for PVSSRDB_USER.LANGSTRING
create or replace public synonym LS for PVSSRDB_USER.LS
create or replace public synonym RDBHELPERS for PVSSRDB_USER.RDBHELPERS
create or replace public synonym STDTESTOUTPUT for PVSSRDB_USER.STDTESTOUTPUT
create or replace public synonym STDTESTRDB for PVSSRDB_USER.STDTESTRDB
create or replace public synonym SYSTEMS for PVSSRDB_USER.SYSTEMS
create or replace public synonym VALARCH for PVSSRDB_USER.VALARCH
create or replace public synonym VALERTSCREEN for PVSSRDB_USER.VALERTSCREEN
0
Checking Setup
==============
setup - main config entries: OK
setup - creating group and archive + switching: FAILED! 4/0
setup - created sites per instance: OK
setup - active monitor jobs: OK
setup - packages and package bodies: OK
setup - sequences: OK
setup - history groups: OK
setup - dynamic history tables per group: FAILED! 2/0
setup - standard lastval tables per group: OK
setup - standard tables: OK
setup - enabled standard triggers: OK
setup - user defined types: OK
setup - views per group: FAILED! 5/0
setup - user or OS authentication for backup and recovery: OK
setup - time zone exists: OK
setup - valid time zone: OK
setup - connection to extern source: OK
setup - standard CS tables: OK
setup - CS packages and functions: OK
setup - CS monitoring views: OK
setup - log entries 'I'nformation: FAILED! 12-15/10-15
setup - log entries 'W'arnings: OK
setup - log entries 'E'rrors: FAILED! 0/2
Oracle win_install.bat problem
Search