- Installing Oracle
I use the Win10 64-bit, the official website downloads 64 Oracle 12c, two files.
Unzip the first file after installation, but install to half error, prompting missing files. Later found that the original two files to be extracted separately, extracted according to the directory merged together.
Install again, install to 88% and the jammed won't move. I thought the installation failed again, shut down, but found can use, so use it.
- Create user
Oracle database is divided into CDB and PDB, the relationship between them, want to know can check relevant information, not detailed here.
To put it simply, CDB is a database container, and the PDB is a pluggable database.
Default login is CDB, only common users can be created.
Common users must #开头 in C # #或C #.
Show Con_name;--View ContainerSelectName, CDB fromv$Database;Create UserC # #kettle Identifed byKettle;--Create common UserAlterSeesionSetContainer=PDBORCL;--ToggleSelectCon_id,dbid,name,open_mode fromV$pdbs;AlterPluggableDatabasePdborclOpen;AlterSessionSetContainer=pdborcl;show Con_name;Create UserKettle identifed byKettle;--Create a normal user userAlterSessionSetContainer=cdb$root;lsnrctl Status--dos command line execution--Modify the files in the installation directory--D:\app\Oracle\product\12.1.0\dbhome_3\NETWORK\ADMIN\tnsnames.oraPdborcl=(DESCRIPTION=(Address_list=(ADDRESS=(PROTOCOL=TCP) (HOST= 127.0.0.1) (PORT= 1522)) ) (Connect_data=(service_name=PDBORCL)) ) tnsping PDBORCL--dos command line executionSqlplus Kettle/Kettle@pdborcl --DOS command line login succeeded
- Configure Kettle
when JDBC connects to the CDB database, the URL is compatible with the following 2 modes:"JDBC:ORACLE:THIN:@192.168.75.131:1521:ORACLE12C"
"JDBC:ORACLE:THIN:@192.168.75.131:1521/ORACLE12C"
When JDBC connects to the PDB database, the URL must be in the "jdbc:oracle:thin:@192.168.75.131:1521/oracle12c" format,
If you use the traditional format " jdbc: oracle:thin:@192.168.75.131:1521:oRACle12c" The error will be reported:
java. SQL. Sqlexception:listenerrefused the connection with the following error:
ORA-12505, Tns:listener does notcurrently know of SID given in Connect descriptor
Kettle If you connect to Oracle using native (JDBC), the default is the first method, which is not connected
Therefore, we use the Jndi method to connect:
Open the following file in the Keetle installation directory and enter the following:
D:\Program files\data-integration\simple-jndi\jdbc.properties
kettle/type=javax.sql.DataSource Kettle/driver=oracle.jdbc.driver.OracleDriver Kettle/url=jdbc : Oracle:thin: @localhost:1521/pdborclkettle/user=kettlekettle/password=kettle
Configure Keetle after saving files
Finally click Test.
If there is any problem, can give me a message.
Kettle Connecting Oracle 12c