Advertisement
Guest User

Untitled

a guest
Mar 1st, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. String IP = "Server99";
  2. String port = "1521";
  3. String DBNAME= "PGDB";
  4. String mcS_UserName="UserName";
  5. String mcS_Password="Password";
  6. String JDBC_DRIVER="oracle.jdbc.driver.OracleDriver";
  7. Connection conn;
  8. String DB_URL= "jdbc:oracle:thin:@"+IP+":"+port+":"+DBNAME;
  9. Class.forName(JDBC_DRIVER);
  10. conn = DriverManager.getConnection(DB_URL,mcS_UserName,mcS_Password);
  11.  
  12. ]$ tnsping Server099
  13.  
  14. TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 01-MAR-2016 14:02:54
  15.  
  16. Copyright (c) 1997, 2009, Oracle. All rights reserved.
  17.  
  18. Used parameter files:
  19. /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
  20.  
  21. Used EZCONNECT adapter to resolve the alias
  22. Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS= (PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.99)(PORT=1521)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement