07-22-2013
If you want to give permission to oracle to create files under some directory make an entry into ALL_DIRECTORIES with the user you want to run the PL/SQL or data pump etc.
6 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi ,
I have a filesystem on AIX 4.3.3 which i need to share with other clients who use Windows NT and Redhat linux 7.3.
I use samba to share this with Windows NT Clients.
Now i was to share this with Linux clients.
When i try to nfs mount this on Linux i get
"mount: failed, reason given by... (1 Reply)
Discussion started by: Sushesh
1 Replies
2. UNIX for Dummies Questions & Answers
Hello,
I'm trying to login to an Oracle databse without entering the user/passwd. The server resides on an AIX 5.1 system, and using LDAP. I'm entering the following command
>sqlplus / @ORACLE_SID
This should work but for some odd reason I get a login denied.
But if I enter the user id... (1 Reply)
Discussion started by: ctcuser
1 Replies
3. Solaris
I am using oracle 9i with sun solaris 8 on Sun E 250 server.earlier we are taking backup of oracle archive files on /orabackup directory.in which archive file are stored with ...arc.Z extension. now we have changed the archive backup directory.now when we are trying to delete earlier directory... (3 Replies)
Discussion started by: mahanalok
3 Replies
4. Web Development
Hello,
I've set all permissions for all on my Server folders:
chmod a+rwx ServerFolder
When I browse to localhost:8000 I receive the following error:
You don't have permission to access / on this server.
why ?
thanks (9 Replies)
Discussion started by: aneuryzma
9 Replies
5. Shell Programming and Scripting
i need to give permission to ORACLE SERVER to create a directory in a particular path.
How to do it?Oracle server is installed on SOLARIS (16 Replies)
Discussion started by: rafa_fed2
16 Replies
6. Shell Programming and Scripting
Starting sendmail throws this error:
I decided to see the permission on the files under /etc/mail and this is the output:
# ls -ltr
total 284
-rwxr-xr-x. 1 root root 1847 Jan 27 2014 virtusertable
-rwxr-xr-x. 1 root root 127 Jan 27 2014 trusted-users
-rwxr-xr-x. 1 root root 92... (3 Replies)
Discussion started by: mohtashims
3 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)