03-24-2014
After installing the binaries (the Oracle RDBMS software), you'll need to create the database.
This User Gave Thanks to radoulov For This Post:
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Happy Holidays everybody.
I'm trying to install oracle 8i personal on my desktop, but I don't know how to do it at the command prompt. Heck, i don't even know how to access my cdrom drive from the command prompt. Could somebody give me a hint to get me started. I would tried to do it with Xwindows... (2 Replies)
Discussion started by: tmanpakdee
2 Replies
2. Red Hat
If anybody can help would be greatly appreciated...
I get the same error with Oracle 9i & 10g when installing on Red Hat Fedora 4, it's java related...
Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/OraInstall2007-03-16_01-09PM/jre/lib/i386/libawt.so: connat restore segment... (0 Replies)
Discussion started by: Joncamp
0 Replies
3. Solaris
Hello.
I was trying to installe oracle 10g on solaris t0 x86 and got few exception? Could you please suggest, what might be going wrong?
$ ls -l
total 32
drwxr-xr-x 9 oracle dba 512 Nov 21 03:50 doc
drwxr-xr-x 5 oracle dba 512 Nov 21 03:50 install
drwxr-xr-x 2... (5 Replies)
Discussion started by: panchpan
5 Replies
4. UNIX for Advanced & Expert Users
Hello!
I'm using Linux Gentoo 2.6.22-gentoo-r9.
Before I used Red Had I had no issues with the installation.
But I don't like Red Hat and trying to install Oracle on Gentoo.
See following:
rpm --nodeps -vv -i oracle-xe-10.2.0.1-1.0.i386.rpm
...
You must run '/etc/init.d/oracle-xe... (5 Replies)
Discussion started by: mirusnet
5 Replies
5. Solaris
Thanks all for your help. Now here is another problem i have, i have been trying to install oracle 10g on solaris but i keep getting this error message
"there is not enough memory on the volume you specify to copy the starter database files the oracle universal installer discover that you have... (8 Replies)
Discussion started by: mutiat
8 Replies
6. Solaris
Hi,
i am trying to install Oracle 10g Companion Products on a Solaris 5.9 server.
At the end of the installation the configuration assistant fails and it's unable to start the HTTP Server.
Below is the error
opmnctl: starting opmn and all managed processes...
Failed to get IP for ... (0 Replies)
Discussion started by: saharookiedba
0 Replies
7. Red Hat
Hello All,
I'm having below errors while installing oracle on Redhat 5.7 64 bit, terminated installation as preliminary check failed.
-bash-3.2$ !cd
cd ../../../database/
-bash-3.2$ xclock
Error: Can't open display:
-bash-3.2$ xdpyinfo
xdpyinfo: unable to open display "".
-bash-3.2$... (6 Replies)
Discussion started by: lovesaikrishna
6 Replies
8. Red Hat
Hi,
I am a common user on a linux cluster that has openJDK installed. For a particular software, the vendor asks for Oracle version of java installed.
How can I install the oracle version from my home space where I don't need admin privileges to install?
thanks! (2 Replies)
Discussion started by: pc2001
2 Replies
9. UNIX for Beginners Questions & Answers
Hi,
I'm a junior programmer. This is my first post here, please excuse me if that's not the correct place :)
For days now I've been trying to install Oracle DB 12c R2 on Ubuntu 18.04. I'm at my wits' end. The software itself installs fine and a Listener can be started but I can't start... (15 Replies)
Discussion started by: Marika
15 Replies
LEARN ABOUT PHP
oci_set_module_name
OCI_SET_MODULE_NAME(3) OCI_SET_MODULE_NAME(3)
oci_set_module_name - Sets the module name
SYNOPSIS
bool oci_set_module_name (resource $connection, string $module_name)
DESCRIPTION
Sets the module name for Oracle tracing.
The module name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement
is executed.
The name can subsequently be queried from database administration views such as V$SESSION. It can be used for tracing and monitoring such
as with V$SQLAREA and DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE.
The value may be retained across persistent connections.
PARAMETERS
o $connection
-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $module_name
- User chosen string up to 48 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
NOTES
Note
Oracle version requirement
This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards.
Tip
Performance
With older versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack-
age. This is less efficient than using oci_set_client_info(3).
Caution
Roundtrip Gotcha
Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is
enabled.
EXAMPLES
Example #1
Setting the module name
<?php
$c = oci_connect('hr', 'welcome', 'localhost/XE');
// Record the module
oci_set_module_name($c, 'Home Page');
// Code that causes a roundtrip, for example a query:
$s = oci_parse($c, 'select * from dual');
oci_execute($s);
oci_fetch_all($s, $res);
sleep(30);
?>
// While the script is running, the administrator can see the
// modules in use:
sqlplus system/welcome
SQL> select module from v$session;
SEE ALSO
oci_set_action(3), oci_set_client_info(3), oci_set_client_identifier(3).
PHP Documentation Group OCI_SET_MODULE_NAME(3)