Connect to Oracle DB with Linux Shell Script

In this post, we will see how to connect to Oracle DB in Linux Shell Script. There are some prerequisite for a Linux server to connect to Oracle DB. There should be oracle db driver installed on the Linux server from which you want to connect to Oracle DB. Check whether you can call/connect SQLPLUS from command line.
$ sqlplus
if you are not able to, check whether oracle path is set in .profile file. Lets assume, Oracle DB driver is installed on Server and Sqlplus path is set.

Now, there are some basic steps to connect to Oracle DB-
a) Connect to Oracle DB with UserID and Password
b) Execute the SQLs
c) Store the output in a file or send to standard output (terminal)

Error 39202 when logging into IBM DataStage

DataStage Client programs (Designer, Manager, Director) experience a connection failure, and the message displayed to the user is:

Failed to connect to host: xxxxx, project: UV
(Internal Error (39202))

Lock/Unlock Oracle Users

In spite of deleting an oracle user, we can LOCK it. In that way the user won’t be accessible. In future if we want we can UNLOCK it.

create a user named JACK which is LOCKED:
SQL> create user jack identified by jack account lock;
User created.

Get DB2 Version

Method #1. Connect to the database from the command line


 

Failure to connect to DataStage services tier: invalid host name

When you attempt to start one of the Datastage clients, the following message is displayed:

Failed to authenticate the current user against the selected

Domain: Server [servername] not found.

Checks & Solution :

You might be specifying an incorrect name for the computer that is hosting the services tier.

You can check whether the application server is running by attempting to connect to the application server using an Internet browser.

Connect Oracle Database as SYSDBA

Log into the database via sqlplus with sysdba priv’s with a single command. This can be setup with an alias, if you’d like.

#. Log into the server as the oracle user and ensure you have the effective group of the appropriate DBA group. Typical unix installations have the OS user as ‘oracle’ and the dba group as 'dba' (not to be confused with the ‘oinstall’ group).  

#. Check your account with the unix ‘id’ command. Make sure your environment variables are set to the appropriate database:

JDBC connection with Teradata

Today I am going to tell you how to connect to TeraData via JDBC, Here I have used a RazorSQL tool.  For JDBC connection with TeraData, you can find the JDBC drivers here. Teradata JDBC driver enables all Java applications to connect a Teradata database using a well-established industry standard Java Database Connectivity (JDBC) API interface.

A new database connection can be obtained in a standard JDBC way by using java.sql.DriverManager.getConnection method with a proper connection string to get a new instance of java.sql.Connection.

The simplest database connection string would be: