Tech Rescue

Oracle

How to connect to a remote Oracle database

Here is how to connect to a remote Oracle database using SQLPlus:

sqlplus user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=protocol)(HOST=host)(PORT=port))(CONNECT_DATA=(SID=sid)))

Please note that the words in Italics represent variables:

user – user name for the remote database

pass – password for the remote database

protocol – protocol used to connect to remote database, usually TCP

host – IP address or hostname of the remote host

port – remote port listening for database connections

sid – remote SID to connect to

Here’s an example:

sqlplus siry_m/loves_hector@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.110.70.199)(PORT=1521))(CONNECT_DATA=(SID=xe)))

Sources:

http://dba.stackexchange.com/questions/13075/how-to-use-sqlplus-to-connect-to-an-oracle-database-located-on-another-host-with

Read next

Install Kong OSS DB-less mode in Ubuntu Mate Impish 21.10 in Raspberry PI 4

1. Pull docker images. sudo docker pull arm64v8/kong 2. Run Kong in DB-less mode. sudo docker run -d --name kong \ -e "KONG_DATABASE=off" \ -e "KONG_PROXY_ACCESS_LOG=/dev/stdout" \ -e "KONG_ADMIN_ACCESS_LOG=/dev/stdout" \ -e "KONG_PROXY_ERROR_LOG=/dev/stderr" \ -e "KONG_ADMIN_ERROR_

Install DecK for Kong in Ubuntu 20.04 (focal)

1. Download the TAR file: curl -sL https://github.com/kong/deck/releases/download/v1.11.0/deck_1.11.0_linux_amd64.tar.gz -o deck.tar.gz 2. Extract the TAR file: tar -xf deck.tar.gz -C /tmp 3. Copy the files to the right place: sudo

Authorize a user to authenticate with SSH key

NOTE: I am assuming that sshd is already up and running on your Skynet server. If not, run systemctl status sshd, if down you can run systemctl start sshd and systemctl enable sshd to start the service and allow it to run at system startup. For the purposes of this