DB / Oracle

Log into Oracle using (Easy Connect) EZConnect

Sunil PadmanabhanLeave a comment

You can use Third Party Tools like Toad or Navicat which have excellent GUI to get you logged into Oracle

But if you want to go the traditional way; find below instructions

  • Open Command Prompt
  • Type:  sqlplus sys/password@<hostname>/<global service name> as sysdba
  • Typing the password in this manner is never recommended; instead use below option
  • Type: sqlplus sys@”<hostname>/<global service name>” as sysdba
  • It will then prompt to enter password
  • An alternate way is to log into SQL initially without a user
  • sqlplus / nolog
  • Now under SQL Prompt; type connect sys@”<hostname>/<global service name>” as sysdba
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s