Cannot running export database using bash script


 
Thread Tools Search this Thread
Operating Systems Linux Cannot running export database using bash script
# 1  
Old 03-22-2007
Cannot running export database using bash script

Hi all,
I'm new in linux. When I try to run a bash script, it doesn't execute and i receive the following error message
20070321:220002|ERROR|[14921]|exportDatabase.bash|Another EXPORT process (pid=2799) is still running.

If i kill this pid, i receive "No such process".
This process was running well before until i run the export manually yesterday within putty and close the session before the export was completed.

Any help?

Regards
# 2  
Old 03-22-2007
Hi,
Could You post the bash script ?
# 3  
Old 03-22-2007
The bash script is like this

exp telma/telma_live file=/data5/telma_dumps/daily/exp_telma02_13032007.dmp log=/data5/telma_dumps/exp_13032007.log owner=TEL rows=y compress=y consistent=y grants=n statistics=none direct=y

I think the bash script is running well before.

Regards
# 4  
Old 03-22-2007
Well, i would check the log fisrt (exp_13032007.log) and eventually ask the dba to find and kill the export session (inside oracle itself) you ran manually
But it will be just fine if You could just schedule a database restart (i guess! im not a dba but most of the time it works Smilie )
# 5  
Old 03-22-2007
I mean there was no error if i run the export manually but the problem is about the bash script. If I run

$./exportDatabase.bash

the script doesn't execute.

Regards
# 6  
Old 03-23-2007
try this
Code:
sh ./exportDatabase.bash

and post the content of this /data5/telma_dumps/exp_13032007.log or just do chmod +x on exportDatabase.bash
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

BASH script to export var to env

Hi all I am trying to create a script that takes a password input then writes that to a tmp file and puts that tmp file path in my env as a var. It does everything but export the my env and I am unsure why. I am using Ubuntu 12.4 #!/bin/bash read -s -p "Enter Password: " gfpassword... (5 Replies)
Discussion started by: koikoi
5 Replies

2. Shell Programming and Scripting

Export variable to another script running in background

i have a script inside which i have generated a background job which will run another script. How do i export the variables from parent script to the child script which wil run in the background . a.sh:- export tmpdir="/usr/tmp" nohup b.sh& b.sh:- echo $tmpdir But... (1 Reply)
Discussion started by: millan
1 Replies

3. Shell Programming and Scripting

Export data from database in Excel sheet with the help of Shell script and automated the report

Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig. (1 Reply)
Discussion started by: neeraj617
1 Replies

4. Programming

Creating a bash script that create/open database

Hi. I have two text files(tables) which include some information and I want to make some query codes using them. First of all, I want to create bash script that read this two tables, create/open database and insert data from files into database. #!/bin/bash while read line; do ... (1 Reply)
Discussion started by: rlaxodus
1 Replies

5. Shell Programming and Scripting

Running script automatically when threshold limit met in one of the field in oracle database

Hi Guys, Need you help in one point! I am working on one shell script which takes following steps : 1. Taking one query result from oracle database 2. Exporting that result to Xls file 3. Mailing that file to my own mail ID Now, I want to give a threshold limit to one of the column... (0 Replies)
Discussion started by: Agupte
0 Replies

6. UNIX for Advanced & Expert Users

Bash script with export variables

Hi all guys, how you can read in thread title, I'm deploying a bash script in which I have to export some variables inside it. But (I think you know) the export command works only inside the script and so, on exit command, the variables aren't set like I set inside the script. Consequently in... (8 Replies)
Discussion started by: idro
8 Replies

7. Shell Programming and Scripting

problem running shell script (for oracle export) in crontab

Hello Gurus, I've been tasked with solving a problem at my new job and I'm stumped. We've got a script that dynamically builds an oracle export parameter files and then runs export from the shell. it runs fine when using the shell, but will NOT run (fails in one spot everytime) when entered... (1 Reply)
Discussion started by: jsheehan223
1 Replies

8. Solaris

Getting error as Database locked while running a script

While i am trying to run a script in which it calls an executable(binary code)processes a file using the data in database. But while running the script the following error is occured. "permission to access this database was denied <err-0025-0191>re /ds1/nrms_r.db9 while looking up... (0 Replies)
Discussion started by: vamshikrishnab
0 Replies

9. Shell Programming and Scripting

unix script to export data from csv file to oracle database

Hello people, Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies

10. Shell Programming and Scripting

export table from oracle database

i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it. thanks as usuall :rolleyes: (1 Reply)
Discussion started by: inquirer
1 Replies
Login or Register to Ask a Question