oem express 19c

admin

1. [oracle@vm1 ~]$ sqlplus / as sysdba
   
2. 
   
3. SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 14 10:41:48 2023
   
4. Version 19.12.0.0.0
   
5. 
   
6. Copyright (c) 1982, 2021, Oracle.  All rights reserved.
   
7. 
   
8. Connected to an idle instance.
   
9. 
   
10. SYS@ora19> startup
    
11. ORACLE instance started.
    
12. 
    
13. Total System Global Area 2516581448 bytes
    
14. Fixed Size                    9141320 bytes
    
15. Variable Size                  536870912 bytes
    
16. Database Buffers         1962934272 bytes
    
17. Redo Buffers                    7634944 bytes
    
18. Database mounted.
    
19. Database opened.
    
20. SYS@ora19> show pdbs;
    
21. 
    
22.     CON_ID CON_NAME                          OPEN MODE  RESTRICTED
    
23. ---------- ------------------------------ ---------- ----------
    
24.          2 PDB$SEED                          READ ONLY  NO
    
25.          3 PDB1                           READ WRITE NO
    
26. SYS@ora19> select DBMS_XDB_CONFIG.GETHTTPPORT() from dual;
    
27. 
    
28. DBMS_XDB_CONFIG.GETHTTPPORT()
    
29. -----------------------------
    
30.                             0
    
31. 
    
32. SYS@ora19> show con_name;
    
33. 
    
34. CON_NAME
    
35. ------------------------------
    
36. CDB$ROOT
    
37. SYS@ora19> select DBMS_XDB_CONFIG.GETHTTPSPORT() from dual;
    
38. 
    
39. DBMS_XDB_CONFIG.GETHTTPSPORT()
    
40. ------------------------------
    
41.                              0
    

复制代码

1. SYS@ora19> alter session set container=pdb1;
   
2. 
   
3. Session altered.
   
4. 
   
5. SYS@ora19> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5501);
   
6. 
   
7. PL/SQL procedure successfully completed.
   

复制代码