My Oracle Support Banner

How To Install XBRL Extension To Oracle XML DB In Multitenant DB (Doc ID 2965437.1)

Last updated on OCTOBER 06, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.17.0.0.0 and later
Information in this document applies to any platform.

Goal

Install XBRL Extension to Oracle XMLDB in a Multitenant DB, version 19c.

Following the available steps, in combination with ORACLE_PDB_SID to connect to the desired PDB, results in "ORA-01017: invalid username/password; logon denied"

 

export ORACLE_SID=SID_EXAMPLE
export ORACLE_PDB_SID=PDB_EXAMPLE
cd %/190000/rdbms/xbrl_xdb/XBRLScripts

sqlplus / as sysdba

CREATE SMALLFILE TABLESPACE "XBRL_TS" DATAFILE '%/datafiles/xbrl_ts01.dbf' SIZE 100M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.

@xbrlinstall.sql password xbrlsys XBRL_TS TEMP TRUE

ERROR:
ORA-01017: invalid username/password; logon denied

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.