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

Last updated on JULY 20, 2024

Applies to:

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

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