02-08-2011
Hi,
I've not used the express edition so forgive me if this is total rubbish.
What happens when you go into SQL: sqlplus / as sysdba
and run the startup command?
Are there any errors in the alert log?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Ok here is my problem i do not know the command to load a driver for my network card in Ted hat linux 6.0 could sombody give me a hand. and if there is anyone that has a list of commands for red hat that would be great also (2 Replies)
Discussion started by: bbutler3295
2 Replies
2. UNIX for Advanced & Expert Users
I just bought a new pc and my unix software is installed on my old computer. I want to take the hard disk outta my old pc and then install it on my new pc so my new pc has 2 hard drives.
now, after my pc new has 2 hard drives, one being unix the other being windows xp, i want to be able to... (7 Replies)
Discussion started by: TRUEST
7 Replies
3. Red Hat
I use redhat linux enterprise 4 ,
I setup and enable the xdmp already.
I want to use XMing in window XP to connect to x server in this red hat linux and start the x-window .
But I fail as it is no response from red hatl inux and time out ...
Please advice what I need to do in the linux OS ??? (1 Reply)
Discussion started by: chuikingman
1 Replies
4. Red Hat
Hi ,
Am trying to install oracle 10g client on Red Hat Linux in an IBM PPC machine.
when i try to install during linking am getting the below error
My software details :
Oracle Version : 10.2.0
Red Hat Version : 5.5
Server Hardware : PPC 64
Error from the logs :
/usr/bin/make -f... (7 Replies)
Discussion started by: mugunthanvh
7 Replies
5. Red Hat
Hi,
I use red hat linux ES 5.5 32 bit .
There is x win(startx) installed.
I wan to use XP at another computer and connect the x-win(startx) through IP network .
Which software/freeware I can use ???
Please advice ..
Is it free ??? (0 Replies)
Discussion started by: chuikingman
0 Replies
6. Red Hat
ISSUE: The system is unable to register with Redhat network (RHN).
SYSTEM DETAILS: RHEL6 (2.6.32-131.2.1.el6.x86_64). The firewall is turned off. I have network connectivity. There is no GUI. All work is done from the command line.
The following files are installed:... (4 Replies)
Discussion started by: SmithJ
4 Replies
7. Red Hat
Hello everybody, the reason why im posting this thread is because i've installed an oracle test database on RHEL 5, on a localhost (Since it is for test)... the thing is, after i have installed the DB it works just fine, but after i re start it, i get the following errors when i want to go into the... (5 Replies)
Discussion started by: blacksteel1988
5 Replies
8. UNIX for Dummies Questions & Answers
how to know if i use "Red Hat Enterprise Linux" or "Red Hat Desktop" ? (2 Replies)
Discussion started by: ahmedamer12
2 Replies
9. Red Hat
Hi Friends,
Can someone help me with below issue , thanks.
Subject : Unable to configure "Reliance NetConnect" on RHEL 5
Here some helpful information :
# lsusb
Bus 001 Device 001: ID 0000:0000
Bus 001 Device 002: ID 8087:0020
Bus 001 Device 003: ID 192f:0416
Bus 002 Device... (0 Replies)
Discussion started by: arunraj192
0 Replies
10. Fedora
I just started a new semester and I started my UNIX class yesterday. I've already decided to use python along with my learning process but what I really want to use with it is Kali as my UNIX/Linux platform to learn off of since I already wanted to learn Cyber Sec. anyways. I just wanted to know if... (12 Replies)
Discussion started by: ApacheOmega
12 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)