Connect to a remote ORACLE database on Mac

Procedure

1. Open the terminal and enter ssh.

 
Chenmatomacbook-Pro :~ Nono $ sshusage: SSH [-1246 aacfgkkmnnqsttvvxxyy] [-B bind_address] [-C cipher_spec] [-d [bind_address:] port] [-e escape_char] [-F configfile] [-I pkcs11] [-I identity_file] [-L [bind_address:] Port: Host: hostport] [-l login_name] [-M mac_spec] [-O ctl_cmd] [-O option] [-P port] [-R [bind_address:] Port: Host: hostport] [-s ctl_path] [-w host: Port] [-W local_tun [: remote_tun] [user @] hostname [command]
 

2. Connect to the remote server

 
Chenmatomacbook-Pro :~ Nono $ SSH root@10.1.1.1root @ 10.1.1.1's password:
 

Username @ IP Address: the username of the remote host. The port number is not required after the IP address.

TIPS: the first link will prompt an RSA key or something. Just enter "yes" and press enter, and then enter the logon password.

3. log on to the database

Last login: Wed Apr 3 16:19:24 2013 from 10.1.1.1 [root @ mydbtest ~] # Su-Oracle [Oracle @ mydbtest ~] $
 

TIPS: su space-space.

4. log on to the database

 
[Oracle @ mydbtest ~] $ Sqlplus username/password SQL * Plus: Release 10.2.0.1.0-production on Wed Apr 3 16:36:37 2013 copyright (c) 1982,200 5, Oracle. all rights reserved. connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit productionwith the partitioning, OLAP and Data Mining optionssql>
 

5. Execute the SQL statement to prepare NiuBility ....

6

SQL> select * From my_user where username = 'test'; MARKID----------USERNAME--------------------------------------------------------------------------------PASSWD trusted source membertype ---------- trusted PROVINCE----------------------------------------SAFEEMAIL--------------------------------------------------------------------------------CREATEIP truename ------------------------------ export certtype certcode -------- your phone lastip extends your USERPHONE----------------------------------------USEREMAIL
 

..........

No format ..

This is the end

Download the visual interface client ..