Connecting to Oracle Database in SQL plus

In SQLPlus, log into your database and then run the command with the following syntax:


sql> connect username/password@ipaddress:port/sid

So in if you had a XE database over local network at 10.0.0.143, find out the port number and SID (usually XE for Express Edition). Then you would connect as:

  sql> connect sys/secretpassword@10.0.0.143:1551/XE