Search Results

Hi all experts,

I am new to script writing.
Do you have any idea that any web site provide online learning, exercises with answer for a newbie like me ??

I want to practice scripting.
Do you...

Finally, I got the problem solved. Thanks to all kindly suggestions and advice.
Cheers.

Now I changed the code to the following :

sqlldr loginName/password@//10.x.x.x:1521/ABC log=$JOBLOG control=$SQLLDR_CTL data=$INFILE errors=10000 direct=true rows=10000

It returns the following...

I tried to tnsping the database and it return the following :

ksh: tnsping: not found.

However, if I ping the database and it returns the following :

ping DATABASENAME
PING DATABASENAME:...

I am neither a DBA or sys admin...... :rolleyes::(

Hi,

How about the error saying this :

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

What can I do ?

Please use CODE tags (for data as well) as required by forum...

In AIX server's command prompt for example,
just run the script file as below:

CommandPrompt>./xxxxxxxxx.sh

---------- Post updated at 03:52 PM ---------- Previous update was at 03:50 PM...

Hi experts,

I have got the following errors when running my sqloader script :

Can anyone give me a hand ?
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

...

Hi Don, what do you mean by the follows ?
Do you mean to name the credential file with loginName and password as "xxxx.secret" ?
If so, I tried to name it as "login.secret", but it can still show...

It works. Thanks to Don.

Sorry, I may not understand it.

I re-coded it as follows but it returns errors:

goldfish is the loginName
passcode is the password



#!/bin/ksh
export...

Thanks.
I knew there is no security indeed.
BUT, it is our silly company policy that does not want the user name and password put in the same place in the same script.

Linux server and ksh shell...

I am writing a shell script for sql loader (just copy part of the code) :

For security reason, I have to put the below loginName and password into another separate file instead of in the same file...