I am trying to import .exp file to oracle database. I have written a script for the same, but i am able to run it manually with out any errors , but it failing from cronjob(Even though i am using absolute path every where) Follwoing is the command i am trying to execute from shell.
/opt/ORACLE/product/bin/imp test/test@testdb full=y ignore=y buffer=1000 log=/data01/import_all.log file=/data01/test.exp
I am new to bash scripting (not programming in general).
I am writing a bash script that will run a Python script I have written.
I want to be able to do the following:
Pass parameters to the bash script via the cronjob (so I can have two cron jobs) one to be run with parameter 'foobar', and the other 'foo'
switch based on the parameter passed to the bash script (by switching, I mean an if/else based on the paramter passed to the bash script).
How i will use sqlplus in shell script? Can any one provide sample code which explain following:
1. Connect to oracle DB
2. Exceute select * from tablename
3. Release connection to the DB
4. Append output in file everytime when query executes.
I have a file with ".tgff" format that a piece of it, is as belowthis file is fordescribing a benchmark in hardware design)
Code:
# AMD ElanSC520-133 MHz
@PROC 0 {
[code]...
I'm a new user for oracle,tried to install oracle 10g on redhat linux 5 but gettinh the same error message.response/ runInstaller[oracle2@localhost database_10201]$ sh runInstaller _runInstaller: line 54:/tmp/database_10201/install/.oui: Permission denied_Doany one plz help me how to give full set of permisions to an user in linux to access a folder??
View 2 Replies View Relatedhow can i connect remotly to Oracle Database using shellscript?.is oracle client is require for connect to oracle db remotly?
View 2 Replies View RelatedI'm using Inkscape, and I'm trying to import an EPS file to use it as a vector and eventually save it as an SVG.
This link here mentions several methods:
[URL]
But the responses aren't rated since it's a forum, so I thought I'd ask here to find the best answer. I'd prefer not to have to use some website to convert the file to a PDF first.
Either way, when I import an EPS into Inkscape, or use the website to convert it to a PDF, in both cases the resulting file loses all colour and gradients, and the EPS file gets cut off on the right side.
It looks like ps2pdf is clipping the file incorrectly, and Inkscape is eliminating the colour.
I have these version installed in Ubuntu Lucid Linux:
Inskape 0.47.0-2ubuntu2
Ghostscript 8.71.dfsg.1-0ubuntu5.3
My requirement is that I wanted a shell script which should read the alert.log(oracle) and should send the alert to my email if any error encountered on daily basis. I have a script which does the same job but at the same time it creates a new alert.log whenever any error occur. But I don't want the new alert log I wanted to read the same alert log daily and if any new error come should alert as email.
View 3 Replies View RelatedI setup linux script to delete my backups older than few days:
RBRDAN=`date �date=�3 days ago� +%w`
rm /u02/oracle/backup/rman/$RBRDAN/*
But, I got error:
[code]...
I am writing shell script for executing oracle procedure. Shell script need to take 3 parameters from one data file rest of the parameters need to pass in command line it self. Total 7 parameters are need to pass for shell script.1st,3rd,5th parameters need to take from dat file and rest of 4 parameters from command line.
Below is one oracle procedure:
EXEC CIM_MGMT_INSTALL.addFlow('$1','1.0','$1','Settings','$2','ECCD2',NULL,1);
$1is 1st and 3rd both places need to pass same parameter.$1,$2 need to take from data file as earlier says.
This is about ubuntu 10.04
I can import projects to my cvs repository only when the repository set to group owner cvs. Which is fine to me.
But I found the project folder/files that I imported into the repository have group name other than cvs (in fact, that's my username). And that prevents others to check out my code.
I had copied oracle setup in the root. Now want to delete it. I tried the following commands, but couldn't succeed:
rm -R oracle-xe-univ-10.2.0.1-1.0.i386.rpm
rm: cannot remove `oracle-xe-univ-10.2.0.1-1.0.i386.rpm': No such file or directory
While this file there only in file system.
I have been trying to write a simple snip of bash shell code to import from 1 to 100 records into a Bash array.
I have a CSV file that is structured like:
record1,item1,item2,item3,item4
record2,item1,item2,item3,item4
record3,item1,item2,item3,item4
record4,item1,item2,item3,item4
And would like to get this data into corresponding arrays as such:
$record1[item1-4]
$record2[item1-4]
$record3[item1-4]
$record4[item1-4]
How can I read .gz file direct on shell/terminal without decompressing the file?
satimis
I need a shell script that will add the users name and date to a file when the user has modified the file, these files are within a group and only accessible to this group. But we need a way for people in the group to know who and when the file was last modified.
View 1 Replies View Relatedi am trying to convert a binary file in to ASCII using shell script. this file contains multiple types of data like string, number, bcd, etc.
View 5 Replies View RelatedI am supposed to take some small files, and print them to a specific printer, such that the small files are concatenated into one file. The file name has to be included in the file that gets printed.
Should I be looking to concatenate the files into one file with the file names included, and then print them?
something like: -printfunction -printername < file*
I have a file with ".tgff" format that a piece of it, is as below (this file is for describing a benchmark in hardware design):
Code:
# AMD ElanSC520-133 MHz
@PROC 0 {
[code]....
I know crontab -e sets a cronjob in /var/spool/cron but how do I set a cronjob to run from /etc/crontab? Is there a command used for this or would I have to manually edit a certain file?
View 2 Replies View RelatedI've AMD64 system with Ubuntu 11.04 installed. It's been rough ride for me to install oracle-xe-universal. I've already spent more than 2 days on this. Still unsuccessful.
1) First I downloaded the packages libaio_0.3.104-1_i386.deb and oracle-xe-universal_10.2.0.1-1.1_i386.deb
2) Then I ran
sudo apt-get install bc (ran fine)
sudo dpkg -i --force-architecture libaio_0.3.104-1_i386.deb (ran fine)
sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
(gave me dependency error for libc6 (>= 2.3.2), I modified the control file to remove dependency and rebuilt the package) (now worked fine) Oracle xe is now installed. Then I tried to start the DB it started but it's HTTP client never started. So I decided to uninstall the oracle-xe=universal. None of the sudo apt-get remove oracle-xe-universal command's didn't worked for me. So i went for manual uninstallation directions as per oracle link.
I ran the following command-
--Manually uninstalling Oracle 10g--
sudo rm -rf /usr/lib/oracle /etc/oratab /etc/init.d/oracle-xe /etc/sysconfig/oracle-xe /usr/share/doc/oracle_xe /usr/share/doc/oracle_xe_client
Then I again ran the following command to install oracle-xe
sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.0_i386.deb
See below what I got as the output-
rocky@ubuntu:~/git/mygit/edas2/libaio$ sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
dpkg: warning: overriding problem because --force enabled:
package architecture (i386) does not match system (amd64)
[code]....
Even in applications menu I don't see the if oracle has been installed. So i conclude first time installation was ok but somehow http client didn't worked. After manual uninstallation, second installation didn't even loaded/installed the oracle-xe in init.d directory.
I need to run the files everyday at 11.00 pm (Monday to Friday).
How would I put on cronjob? I have files ready.
we have requirement like we need to run the sql script, which needs to be executed for every 45 days.
View 1 Replies View RelatedI'm working on a bash script that will be run regularly via a cronjob. As there is no easy way for the user to see if it's running in the background, I'd like a have some kind of pop up window what say's something like "Process started" and "Process finished" when it's complete. Ive read though some similar threads and came across xmessage. It kind of does what I want, with the exception of:-Id like the message Process started to stay up for the whole process, but it looks like the script wont continue until the xmessage window is closed. I cant get any xmessages to appear when the script is run from a cronjob. It only appears if I run the script manually from a terminal window. Which is no good for me. If anyone has any suggestions that would be great and just to add, it's doesn't have to be xmessage, any text box would do. I'm working with Redhat 4 and 5, if that makes a difference. Chuck Norris destroyed the periodic table, because he only recognises the element of surprise.
View 2 Replies View RelatedI have called an script in cronjob named get_mac.sh as follows:
#!/bin/sh
MAC=`ifconfig eth0 |sed -n 1p|awk '{print $5}'|awk -F : '{print $1$2$3$4$5$6}'`
ARG_FILE="/etc/asterisk/scripts/server.params"
[code]....
Currently we have to comment out an rsync task every now and then. Is there a way to have a PHP script on the server so we can simply browse to it to uncomment the rsync task and another one to comment it out again ?
The rsync job is the only job in crontab so even if it means deleting / re-creating the job wouldn't be a problem. I just want to avoid connecting via SSH and VPN every time I am asked to disable it
Cron setup for execute at 4:30 pm on 2nd monday of each month.
50 16 8-14 * mon /home/user/script.sh
It seems to be ignoring the date range 8-14?
how I can receive emails about a cronjob execution or where to go to read about that? I am using CentOS 5.4.
View 2 Replies View RelatedI wrote this little script and it runs very well, however when I setup a cronjob it only runs if I am logged in. I would like to have this script running even when I am not logged in. At the moment it runs but only when I am logged in. I logged as denis and in terminal (su root) and edited crontab as shown below, what do I need to change or setup to have this script run when no-one is logged in the computer. I run Fedora 12 (64 bit)
backup script:
cd /home/denis/Documents
tar -czvPf /home/denis/Backups/docsbackups_$(date +%Y%b%d_%HH%MM).tar.gz /home/denis/Documents
# above line will produce file with name in this format "docsbackups_date&time.tar.gz" in the /home/denis/Backups folder
[Code].....
I am a PHP developer.I have always used XAAMP(in Windows7) for development purpose. I am driven to turn to Linux now . I have installed Ubuntu10.04-rev189(Wubi) in Windows7 recently. I have a PHP script which require the following tasks to be performed.
1. Give permissions "777" to the following files and folders:_cache media images /configs.php mages/config_photo_preview.jpg
2. Set up cron jobs on your site like this: /usr/local/bin/php -q /your-site-root-dir/cron/index.php I need to get an environment like XAAMP and perform the above mentioned tasks.
i wanted to ask you for help in setting up a cronjob, that restarts a game server.By now I made a script that kills the screen of the server and then restarts it.
View 2 Replies View Related