08-02-2011
I doubt that the problem is in the script itself, as you mentioned it has been running for a long time, so assuming no one has changed it, the problem is actually in the database, considering also the "RMAN-01007", which has a various causes, like the DB instance being opened at the same time from another place / application.
Sorry for not being able to help more, just general guidelines and thoughts, I'm out of the office, so no access to Oracle.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I recently started as an intern and my manager wanted to see how well I would handle Korn Bourne shell scripting without any prior experience, I have prior programming experience but I keep running into syntax errors with AWK. Please take a look at my simple code and tell me what stupid mistake... (6 Replies)
Discussion started by: yongho
6 Replies
2. Shell Programming and Scripting
All,
I have a shell script which parses the /var/adm/messages file for errors every 15 minutes as a cron job. The script runs at 01, 16, 31, and 46 minutes every hour. The problem is if the error is encountered any time during the beginning of hour I can get paged three times. I would like to... (2 Replies)
Discussion started by: bubba112557
2 Replies
3. Shell Programming and Scripting
hey watsup guys
i am new in the shell script world. so i need help fom you guys, i have written these two codes and they both give the same errors( expr : syntax error).
Code 1 :
#! /bin/sh
# count1 appends an increment to a file 200 times
# note that a file called numbers must be... (5 Replies)
Discussion started by: surubi_abada
5 Replies
4. Shell Programming and Scripting
All,
Does it matter what perl verios your running when you get syntax errors?
on version 5.6.1 the code works fine, but on 5.8.0 the code gets errors?
#!/usr/bin/perl
#use strict;
#use warnings;
my $mess = 'messages';
my $mess1 = 'messages.1';
my $mess2 = 'messages.2';
my... (13 Replies)
Discussion started by: bigben1220
13 Replies
5. Shell Programming and Scripting
Hi,
I am a newbie to PERL and working on a script. When running it I get a lot of compilation errors.
The actual command in the program (which is within a case structure) is given below
# This gives the actual count of inquires from a log file (It works fine when I type this on the... (2 Replies)
Discussion started by: nurani
2 Replies
6. Shell Programming and Scripting
this is the script:
ps -ef|grep "x_jobstat 10 v001" > jobstatv001.txt
ps -ef |grep "x_jobserver 10 v001" >> jobstatv001.txt
#Sample text - each line preceded by 4 spaces
# root 133064 102986 0 08:49:28 pts/6 0:00 grep x_jobstat 10 v001
# root 137550 1 0 Nov 08 - 0:28... (6 Replies)
Discussion started by: kwalkner
6 Replies
7. Shell Programming and Scripting
So I have a script that does a greater than or less than with a variable. My problem is that when I checked the script from the command line I was getting this error..
I am not really familiar with shell scripting. I am trying to get this script to work with conky so that it will do the... (8 Replies)
Discussion started by: krisdeniseriley
8 Replies
8. Shell Programming and Scripting
I have a shell script which select total count from a table and use its value in a if condition like below
connect_string="username/password@tnsname"
tot=`sqlplus -s $connect_string << EOF
set echo off
set feedback off
set head off
select count(*) from test_table;
EOF
`
if
then
echo... (2 Replies)
Discussion started by: vel4ever
2 Replies
9. Shell Programming and Scripting
Original script written on CentOS 6.3 with GNU bash 4.1.2
Destination system is Solaris 9 with GNU bash 2.05 (not changeable by me)
I have a script written on the linux side but now we need to provide a version to another site that "doesn't like linux". I've been going through changing the ] or... (13 Replies)
Discussion started by: oly_r
13 Replies
10. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
This script will analyse the channels.txt e registrations.txt and it will allow to mage the channels and the... (9 Replies)
Discussion started by: Demas
9 Replies
LEARN ABOUT PHP
oci_set_edition
OCI_SET_EDITION(3) OCI_SET_EDITION(3)
oci_set_edition - Sets the database edition
SYNOPSIS
bool oci_set_edition (string $edition)
DESCRIPTION
Sets the database "edition" of objects to be used by a subsequent connections.
Oracle Editions allow concurrent versions of applications to run using the same schema and object names. This is useful for upgrading live
systems.
Call oci_set_edition(3) before calling oci_connect(3), oci_pconnect(3) or oci_new_connect(3).
If an edition is set that is not valid in the database, connection will fail even if oci_set_edition(3) returns success.
When using persistent connections, if a connection with the requested edition setting already exists, it is reused. Otherwise, a different
persistent connection is created
PARAMETERS
o $edition
- Oracle Database edition name previously created with the SQL " CREATE EDITION" command.
NOTES
Note
Oracle version requirement
This function is available from Oracle 11 gR2 onwards.
Caution
Persistent connections
To avoid inconsistencies and unexpected errors, do not use ALTER SESSION SET EDITION to change the edition on persistent connec-
tions.
Caution
DRCP Connection Pooling
To avoid inconsistencies and unexpected errors when using editions and DRCP with Oracle 11.2.0.1, keep a one-to-one correspondence
between the oci8.connection_class and the edition name used by applications. Each pooled server of a given connection class should
only be used with one edition. This restriction has been removed with Oracle 11.2.0.2.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Two scripts can use different versions of myfunc() at the same time
<?php
// File 1
echo "Version 1 of application
";
oci_set_edition('ORA$BASE');
$c = oci_connect('hr', 'welcome', 'localhost/XE');
$s = oci_parse($c, "begin :r := myfunc(); end;");
oci_bind_by_name($s, ":r", $r, 20);
oci_execute($s);
echo "The result is $r
";
?>
<?php
// File 2
echo "Version 2 of application
";
oci_set_edition('E1');
$c = oci_connect('hr', 'welcome', 'localhost/XE');
$s = oci_parse($c, "begin :r := myfunc(); end;");
oci_bind_by_name($s, ":r", $r, 20);
oci_execute($s);
echo "The result is $r
";
?>
PHP Documentation Group OCI_SET_EDITION(3)