jdbc:oracle:thin:@${IP}:${PORT}/${SID}
jdbc:oracle:thin:@${IP}:${PORT}:${SID}
SQL> select name,open_mode from v$pdbs; NAME OPEN_MODE ------------------------------ ---------- PDB$SEED READ ONLY TESTPDB1 READ WRITE TESTPDB2 READ WRITE
SQL> select name,open_mode from v$pdbs; NAME OPEN_MODE ------------------------------ ---------- PDB$SEED READ ONLY TESTPDB1 MOUNTED TESTPDB2 MOUNTED
SQL> alter pluggable database all open;
alter pluggable database all close immediate; or alter pluggable database <PDB名> close immediate;
SQL> EXEC DBMS_XDB_CONFIG.SETHTTPSPORT(5500);
SQL> SELECT DBMS_XDB_CONFIG.GETHTTPSPORT() FROM DUAL; DBMS_XDB_CONFIG.GETHTTPSPORT() ------------------------------ 5500
SQL> EXEC DBMS_XDB_CONFIG.SETHTTPPORT(8080)
grant EM_EXPRESS_ALL to system; grant EM_EXPRESS_BASIC to system;
select distinct job_id from job_queue order by job_id