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>;