Assume you already logged Into an Oracle Database, Now You Want to Log Into Another Database.The Following Are Suggestion for you:
- Connect to a local Oracle Database: Method: Connect UserName / Password
- Connect to a remote oracle database: Method: connect username / password @ net_service_name [net service name]: A simple name for a service that resovle to a connect descriptor Its format likes "SID_OracleHost" Depends on your needs, net service name.. Can Be Stored In A Variety of Places, Including: (1) Local Configure File, Tnsnames.ora, on each client (2) Directory Server (3) Oracle Names Server (4) External Naming Service, Such As Nis or CDS for Oracle9i , you can simply connect to the host database using Oracle Enterprise Manager Console, the net service name is stored in tnsnames.ora aotumatically. And you only can remove the net service name by modifying tnsnames.ora manually.
