oracle 12c certification

Open Https://localhost:5500/em, Login failed with two accounts (Sys;change_on_install) and (System;manager)Resolved in the following ways:(1) Enter Sqlplus Sys/change_on_install as SYSDBA on the Windows command line(2) Modify the SYS account password: ALTER user SYS identified by "New password";(3) Note that the last semicolon of the second step is not missing(4) Try again, login successfulThe SYS password is not modified during Oracle

opened.Sql> select Name,open_mode from V$pdbs;NAME Open_mode------------------------------ ----------Pdb$seed READ onlyPDBYCR MountedPDB2 READ WRITEImplemented PDB2 self-booting, you can start different PDB by modifying the SQL statement in the trigger script or implement the self-boot of all PDB, the script is as follows:CREATE TRIGGER OPEN_PDB_PDB2After STARTUPOn DATABASEBEGINEXECUTE IMMEDIATE ' alter pluggable database PDB2 open ';END Open_all_pdbs;/Observe the alert log with the following m

Create a temporary table spaceCreate temporary tablespace test_tempTempfile ' D:\app\orcl\oradata\temproryTestUserSpace\test_temp1.dbf 'Size 10m autoextendOn next 10m maxsize 50m extent management local;Create a data table spaceCreate tablespace test_data LoggingDataFile ' D:\app\orcl\oradata\temproryTestUserSpace\test_data1.dbf 'Size 10m autoextend on next 10m maxsize 50m extent management local;Create User Settings user passwordCreate User C # #XSCJ identified by XSCJ defaultTablespace Test_da

>SelectCon_id,dbid,name,open_mode fromV$pdbs; con_id DBID NAME Open_mode---------- ---------- ------------------------------ ----------2 1258043702pdb$seed READ only3 3749525766PDB1 READ only4 2192587015P4 READ only5 255759235pdb_test Mountedsql>Alter pluggable database pdb_test open; SQL>SelectCon_id,dbid,name,open_mode fromV$pdbs; con_id DBID NAME Open_mode---------- ---------- ------------------------------ ----------2 1258043702pdb$seed READ only3 3749525766PDB1 READ only4 2192587015P4 READ

Sql>SelectName,open_mode fromv$pdbs;name Open_mode------------------------------ ----------pdb$seed READ ONLYPDB1 MOUNTEDPDB2 mountedsq L>Alter pluggable database all open; Pluggable database altered. SQL>SelectName,open_mode fromv$pdbs;name Open_mode------------------------------ ----------pdb$seed Read ONLYPDB1 read WRITEPDB2 read W Ritesql>Alter pluggable database all close; Pluggable database altered. SQL>SelectName,open_mode fromv$pdbs;name Open_mode------------------------------ ----------

Label: Package Javaapplication2; Import Java.sql.Connection; Import Java.sql.DriverManager; Import Java.sql.ResultSet; Import Java.sql.SQLException; Import Java.sql.Statement; Public class JavaApplication2 {public static void main (String[]args) throws ClassNotFoundException,SQLException {class.forname ("Oracle.jdbc.driver.OracleDriver"); String url= "Jdbc:oracle:thin:@//10.98.0.62:1521/wdpis"; Connection conn=drivermanager.getconnection (URL, "qu", "query"); Statement stmt=conn.createstatement

\hosts file 127.0.0.1 is blocked.2. Also IP address do not use DHCP to obtain IP automatically, you need to specify an IP address. This problem occurs as long as you find the cause, and then let the monitoring start normally can solve the problem.3. Firewall does not shut down caused4. Check that the other network configuration is correct.The installation is complete, according to the prompt browser access (The browser may be reported missing flash plugin to install one on the line)User name is

Tags: database backup Oracle Solution Course lecturer: Xiao Liu Teacher Course Category: Oracle Suitable for people: advanced Number of lessons: 15 hours Update level: Complete Type of Service: Class C (General Service class course) Using the technology: Oracle Projects involved: Oracle