Hi,
Following is the code that I am using, but as you mentioned my oracle db is in server1 and unix box is in server2. Other thing is if I hard code Oracle DB connection string to a variable as
DB_INFO = "user@pwd@server1", it works but not when read from external file
Code:
echo "Set up Oracle environment"
PATH=/usr/local/bin:$PATH ; export PATH
ORAENV_ASK=NO ; export ORAENV_ASK
ORACLE_SID=server1 ; export ORACLE_SID
. /usr/local/bin/oraenv
echo " Oracle_Home is $ORACLE_HOME"
PATH=$ORACLE_HOME/bin:$PATH ; export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib ; export LD_LIBRARY_PATH
#Get value from configuration file
DB_INFO=$(<../dev2_config.txt)
export $DB_INFO
Moderator's Comments:
Please use CODE tags when displaying sample input, output, and code segments.
Last edited by Don Cragun; 05-31-2015 at 11:56 PM..
Reason: Add CODE and ICODE tags.
Hi,
I would like to write a Korn shell script which will remove files older than a certain date. In my script, it will read a configuration file with the following entries:
# <directory> <filename wildcard>
#
/home/philip/log *.log
/home/philip/log1 delete-me*.log
The... (1 Reply)
Hi All,
We have requirement to read XML details from large Log File and save in new file name. I have enclosed the sample xml which has start tag <OUTBOUND_MESSAGE xmlns="http://www.abc.com"> and the end tag as </OUTBOUND_MESSAGE>
The log file contains many lines with other details which... (6 Replies)
Hello all,
Please let me know if anyone have the idea how to read the configuration file from the shell script?
Thanks in advance,
Nishanth (7 Replies)
Hi,
Could someone tell me how to stop SQLPLUS command from printing the connection details in the console.
Below is the lines i get in console when executing the sqlplus...
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 9 03:31:03 2011
Copyright (c) 1982, 2005, Oracle. All rights... (2 Replies)
How to find the entire configuration details of a solaris.
I need to know what partion were made, which OS is used and wat version is used etc...
Thanks to tell (4 Replies)
Hi,
How to find the cpu configuration details of Cores, Speed MHz, virtual processors for the following servers:
LINUX OS Servers:
Linux 2.6.9-89.0.3.ELsmp #1 SMP Sat Jun 13 07:05:54 EDT 2009 i686 i686 i386 GNU/Linux. (Cores, Speed, Processor)
Linux 2.6.18-164.el5 #1 SMP Tue Aug 18... (5 Replies)
Hi for all!
I need for my job one shell script very concrete about connection to oracle databases and writing to text file.
Well I tell you:
1.- I must read a file as parameter from linux interface:
> example.sh fileToRead
2.-I must read line to line in "fileToRead" and take a... (9 Replies)
hi all,
I have flat file in unix. By using sql loader i need to import the data from the flat file. I have created a control file, table with the below data structure and pasted the sample input file. I am not sure whether it is a right way to do it. can anyone provide the thought on this.
... (2 Replies)
Hi All,
unable to fetch the bios configuration information and service provider information in centos 5 using dmidecode command.
ServiceProvider=`dmidecode -s system-product-name |awk '{print $1}'`
BIOS_Configuration=`dmidecode | grep "BIOS Information" -A10 | grep -e... (4 Replies)
Discussion started by: sravani25
4 Replies
LEARN ABOUT SUNOS
export
asadmin-export(1AS) User Commands asadmin-export(1AS)NAME
asadmin-export, export - marks a variable name for automatic export to the environment of subsequent commands in multimode
SYNOPSIS
export [ name=value [ name=value]*]
Marks a variable name for automatic export to the environment of subsequent commands. All subsequent commands use the variable name values
as specified; unless you unset them or exit multimode. If only the variable name is specified, the current value of that variable name is
displayed. If the export command is used without any arguments, a list of all the exported variables and their values is displayed.
Exported shell environment variables set prior to invoking the asadmin utility are imported automatically and set as exported variables
within asadmin. Unexported environment variables cannot be read by the asadmin utility.
OPERANDS
name=value variable name and value for automatic export to the environment to be used by subsequent commands.
Example 1: Using export to list the environment variables
asadmin> export AS_ADMIN_HOST=bluestar AS_ADMIN_PORT=8000 AS_ADMIN_USER=admin AS_ADMIN_PASSWORD=password
asadmin> export AS_ADMIN_PREFIX=server1.jms-service
asadmin> export //to list the environment variables that are set
AS_ADMIN_HOST=bluestar
AS_ADMIN_PORT=8000
AS_ADMIN_USER=admin
AS_ADMIN_PASSWORD=********
AS_ADMIN_PREFIX=server1.jms-service
Where: the export command lists the environment variables that are set. In this case, the environment variables have been set to: the host
is bluestar, the port is 8000, the administrator user is admin with an associated password, and the prefix is server1.jms-service.
EXIT STATUS
0 command executed successfully
1 error in executing the command
asadmin-unset(1AS), asadmin-multimode(1AS)J2EE 1.4 SDK March 2004 asadmin-export(1AS)
05-31-2015
