MY NOTES::::
How to know tns name, local host name?
ANS: In installed oracle folder, \server\network\ADMIN\tnsnames.ora
We Have HOST :Naresh , localhost
Port: 1521
Service Name: XE, or ORCL
JDBC Connections code:
Class Name: sun.jdbc.odbc.JdbcOdbcDriver
oracle.jdbc.driver.OracleDriver
Url : jdbc:odbc:testDataSource
jdbc:oracle:thin:@localhost:1521:XE
How to know tns name, local host name?
ANS: In installed oracle folder, \server\network\ADMIN\tnsnames.ora
We Have HOST :Naresh , localhost
Port: 1521
Service Name: XE, or ORCL
JDBC Connections code:
Class Name: sun.jdbc.odbc.JdbcOdbcDriver
oracle.jdbc.driver.OracleDriver
Url : jdbc:odbc:testDataSource
jdbc:oracle:thin:@localhost:1521:XE
No comments :
Post a Comment