Connect to Oracle Instance through SQL Plus Without Using a TNS File

This blog post will show you how to run the HRMS12.sql script from Oracle on a computer with no TNS.ORA file:

• Download the HRMS12.sql file from Metalink and save it somewhere easy to navigate to on your computer (i.e., c:\scripts).
  
  
• Navigate to a command prompt on a computer that already has SQLPLUS installed.
  
  
• Enter SQLPLUS as the command and wait for the Enter user-name prompt.
  
  
• Enter the following string (no spaces, filling in the appropriate variables shown in the example with your environment info):
  
  user/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=yourinstance.address.com)(PORT=YourPortNumber))(CONNECT_DATE=(SID=YOURSID)))
  
  
• Enter the following information at the SQL prompt when you receive the Connected to confirmation message:
  
  @c:\scripts\HRMS12.sql