SQL Learning Links

Below are some of the links from where Oracle SQL language can be learned and practiced.

I will be updating this section when new material is found.



http://www.oracle.com/technetwork/issue-archive/index-1429427.html

http://www.oracle.com/technetwork/issue-archive/sql201-index-3029014.html

ODI Master Repository Creation Wizard JDBC Url Error

 Provided Format for JDBC Url:- jdbc:oracle:thin:@<host>:<port>:<sid>

Method 1:- jdbc:oracle:thin:@demo.us.oracle.com:1521:pdborcl

Error:-
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Method 2:- jdbc:oracle:thin:demo.us.oracle.com:1521:pdborcl

Error:-
java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Correct Method:-

jdbc:oracle:thin:@demo.us.oracle.com:1521/pdborcl


End Result:-




If Table space issue comes up then provide  below grant to user.

GRANT UNLIMITED TABLESPACE TO <USER>;