Connecting To Oracle Database - Revision history

Zcrayfish: Added page to Database category

2023-09-04T19:20:01Z

Added page to Database category

← Older revision		Revision as of 19:20, 4 September 2023
Line 48:		Line 48:
	sqlplus 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))' @myscript.sql		sqlplus 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))' @myscript.sql
	</pre>		</pre>

			[[Category:Database]]

Pojntfx: Treat container as pet and mount current directory

2020-11-24T10:53:51Z

Treat container as pet and mount current directory

← Older revision		Revision as of 10:53, 24 November 2020
Line 1:		Line 1:
	Connecting to a Oracle database directly does not seem to be possible due to the driver being compiled for GNU libc and it being proprietary. It is possible to connect to a database using Docker however. The image is proprietary as well, so a <code>docker login</code> is required and the "Proceed to Checkout" on https://hub.docker.com/_/oracle-instant-client has to be went through.		Connecting to a Oracle database directly does not seem to be possible due to the driver being compiled for GNU libc and it being proprietary. It is possible to connect to one database using Docker however. The image is proprietary as well, so a <code>docker login</code> is required and the "Proceed to Checkout" on https://hub.docker.com/_/oracle-instant-client has to be went through.

	== ~~Connecting with <code>okli</code>~~ ==		== Create the environment ==

	~~<code>[https://github.com/man-group/okcli okcli]</code> is a libre CLI to access a Oracle database. You can connect using it with~~ the ~~following command~~:		First, create the container and mount the current directory:

	<pre>		<pre>
	docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sh -c "yum update -y && yum install -y python3-pip util-linux vim && pip3 install okcli && ~~okcli 'myusername~~/~~mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'~~"		docker run --name okcli -v ${PWD}:/data -d -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sh -c "yum update -y && yum install -y python3-pip util-linux vim && pip3 install okcli && tail -f /dev/null"
	</pre>		</pre>

	~~== Connecting with SQL Plus ==~~		You may check if the installation has finished by running:

	[https://en.wikipedia.org/wiki/SQL_Plus SQL Plus] is the proprietary CLI to access a Oracle database. You can connect using it ~~with~~ the following command:		<pre>
			docker logs -f okcli
			</pre>

			Now, whenever you need to connect to a database, run the following:

			<pre>
			docker restart okcli && docker exec -it okcli sh -c "cd /data && sh"
			</pre>

			== Option 1: Connecting with with <code>okcli</code> ==

			<code>[https://github.com/man-group/okcli okcli]</code> is a libre CLI to access a Oracle database. You can connect using it by now entering the following command in the prompt from above:

			<pre>
			okcli 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'
			</pre>

			You can run a script in the directory you've mounted above like so:

			<pre>
			okcli 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))' -@ myscript.sql
			</pre>

			== Option 2: Connecting with with SQL Plus ==

			[https://en.wikipedia.org/wiki/SQL_Plus SQL Plus] is the proprietary CLI to access a Oracle database. You can connect using it by now entering the following command in the prompt from above:

			<pre>
			sqlplus 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'
			</pre>

			You can run a script in the directory you've mounted above like so:

	<pre>		<pre>
	~~docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1~~ sqlplus 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'		sqlplus 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))' @myscript.sql
	</pre>		</pre>

Pojntfx: Also add Vim to allow for `ed` editing mode

2020-11-03T09:30:59Z

Also add Vim to allow for `ed` editing mode

← Older revision		Revision as of 09:30, 3 November 2020
Line 6:		Line 6:

	<pre>		<pre>
	docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sh -c "yum install -y python3-pip util-linux && pip3 install okcli && okcli 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'"		docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sh -c "yum update -y && yum install -y python3-pip util-linux vim && pip3 install okcli && okcli 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'"
	</pre>		</pre>

Pojntfx: Also add a note on util-linux requirement

2020-10-27T09:59:53Z

Also add a note on util-linux requirement

← Older revision		Revision as of 09:59, 27 October 2020
Line 6:		Line 6:

	<pre>		<pre>
	docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sh -c "yum install -y python3-pip && pip3 install okcli && okcli 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'"		docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sh -c "yum install -y python3-pip util-linux && pip3 install okcli && okcli 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'"
	</pre>		</pre>

Pojntfx: Use correct tags for commands

2020-10-20T12:11:35Z

Use correct tags for commands

← Older revision		Revision as of 12:11, 20 October 2020
Line 6:		Line 6:

	<pre>		<pre>
	~~<source lang="bash">~~
	docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sh -c "yum install -y python3-pip && pip3 install okcli && okcli 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'"		docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sh -c "yum install -y python3-pip && pip3 install okcli && okcli 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'"
	~~</source>~~
	</pre>		</pre>

Line 16:		Line 14:

	<pre>		<pre>
	~~<source lang="bash">~~
	docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sqlplus 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'		docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sqlplus 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'
	~~</source>~~
	</pre>		</pre>

Pojntfx: Clarify libc issue

2020-10-20T12:08:37Z

Clarify libc issue

← Older revision		Revision as of 12:08, 20 October 2020
Line 1:		Line 1:
	Connecting to a Oracle database does not seem to be possible due to the driver being compiled for GNU libc and it being proprietary. It is possible to connect to a database using Docker however. The image is proprietary, so a <code>docker login</code> is required and the "Proceed to Checkout" on https://hub.docker.com/_/oracle-instant-client has to be went through.		Connecting to a Oracle database directly does not seem to be possible due to the driver being compiled for GNU libc and it being proprietary. It is possible to connect to a database using Docker however. The image is proprietary as well, so a <code>docker login</code> is required and the "Proceed to Checkout" on https://hub.docker.com/_/oracle-instant-client has to be went through.

	== Connecting with <code>okli</code> ==		== Connecting with <code>okli</code> ==

Pojntfx: Add Oracle database connection instructions

2020-10-20T12:07:31Z

Add Oracle database connection instructions

New page

Connecting to a Oracle database does not seem to be possible due to the driver being compiled for GNU libc and it being proprietary. It is possible to connect to a database using Docker however. The image is proprietary, so a <code>docker login</code> is required and the "Proceed to Checkout" on https://hub.docker.com/_/oracle-instant-client has to be went through.

== Connecting with <code>okli</code> ==

<code>[https://github.com/man-group/okcli okcli]</code> is a libre CLI to access a Oracle database. You can connect using it with the following command:

<pre>
<source lang="bash">
docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sh -c "yum install -y python3-pip && pip3 install okcli && okcli 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'"
</source>
</pre>

== Connecting with SQL Plus ==

[https://en.wikipedia.org/wiki/SQL_Plus SQL Plus] is the proprietary CLI to access a Oracle database. You can connect using it with the following command:

<pre>
<source lang="bash">
docker run -it -e LC_CTYPE=en_US.UTF-8 store/oracle/database-instantclient:12.2.0.1 sqlplus 'myusername/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=141.62.75.20)(Port=1521))(CONNECT_DATA=(SID=DB1)))'
</source>
</pre>