db wOrLd

If you can't explain it simply, you don't understand it well enough. Albert Einstein

Thursday, April 03, 2008

Connection to Oracle without using tnsnames

You can use the following syntax to connect

sqlplus user/password@//host:[port]/service_name
sqlplus user/password@//host:[port]/service_name as sysdba

This syntax (known as EZCONNECT) is only available with sqlplus >= v10.2
Posted by Darek at 08:18
Labels: Oracle

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2011 (1)
    • ►  March (1)
  • ►  2010 (3)
    • ►  March (2)
    • ►  February (1)
  • ►  2009 (5)
    • ►  November (1)
    • ►  July (1)
    • ►  April (2)
    • ►  March (1)
  • ▼  2008 (8)
    • ►  December (2)
    • ►  November (1)
    • ►  September (1)
    • ►  June (1)
    • ▼  April (2)
      • Developing own program using Oracle XE and APEX
      • Connection to Oracle without using tnsnames
    • ►  January (1)
  • ►  2007 (39)
    • ►  December (4)
    • ►  November (7)
    • ►  October (5)
    • ►  September (4)
    • ►  August (2)
    • ►  July (9)
    • ►  May (1)
    • ►  February (3)
    • ►  January (4)
  • ►  2006 (38)
    • ►  December (5)
    • ►  November (3)
    • ►  October (1)
    • ►  August (2)
    • ►  July (4)
    • ►  June (10)
    • ►  May (8)
    • ►  April (5)

Link List

  • RSS feed (myPage)
  • db indexes - all about indexes
  • Oracle 10g Express Ed.
  • IBM DB2 Express-C
Add to Technorati Favorites

Labels

  • 10g (1)
  • 11g (6)
  • apex (10)
  • CMS (1)
  • Data Mining (1)
  • database (1)
  • DB2 (1)
  • Drupal (1)
  • e-r diagram (2)
  • Grid (1)
  • Linux (2)
  • Oracle (18)
  • Oracle VM (1)
  • RAC (3)
  • security (1)
  • spatial (1)
  • sql (2)
  • tools (2)
  • VirtualBox (1)
  • VMware (1)
  • xe (8)
Awesome Inc. theme. Powered by Blogger.