Connecting to Oracle using SQL Plus

The following are the steps needs to connect to an Oracle database using SQL Plus

  1. Open command prompt - Windows > Run > cmd.exe
  2. Traverse to the path where oracle client is installed. In my case it is C:\Oracle\Ora11g_32\Client11g\bin
  3. Run the command sqlplus username/password@server

Comments

Post a Comment

Popular posts from this blog

Configuring DB2 Connect Server

The following is the process to configure DB2 Connect Server to communicate with DB2 Server, Connect to DB2 CLI (or) use DB2 Configuration Assistant using the DB2 Connect User credenitals used when installing the product. Configure TCPIP node between DB2 Connect Server and the DB2 Database server using the statement below, "CATALOG TCPIP NODE REMOTE SERVER " Catalog the database via an alias name on to the TCPIP node created in step 2 using the statement below, "CATALOG DATABASE AT NODE "
Read more

Concatenate files using MS-DOS

One or more files can be concatenated and saved to a single file using the very helpful copy command available in MS-DOS. The usage of it as follows, copy <multiple file names separated by the plus(+) operator> <resulting file name > Ex: copy File1.txt+File2.txt File3.txt copy *.* File3.txt
Read more