Connect to a remote Oracle database on Mac

Basic Steps for connecting to a remote Oracle database on Mac 1. Open the terminal and enter ssh to see [plain] chenmatoMacBook-Pro :~ Nono $ ssh usage: 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 [plain] chenmatoMacBook-Pro :~ Nono $ ssh root@10.1.1.1 root@10.1.1.1's password: User Name @ IP Address: User name for the remote host, which is not followed by the port number. 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 [plain] 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 [plain] [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 Production With the Partitioning, OLAP and Data Mining options SQL> 5. run the SQL statement to install niubility .... 6 [plain] SQL> select * from my_user where userName = 'test '; MARKID ---------- USERNAME your PASSWD your source membertype ---------- your PROVINCE your SAFEEMAIL your createip truename your certtype certcode ---------- your phone lastip your USERPHONE your USEREMAIL ..........