03-18-2011
Thanks so much hergp!
Just to add to hergp's advice;
After you login to My Oracle Support, and select the 'Knowledge' Tab, be sure to select Sun Microsystems --> All Products
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hey all,
I've been trying to find a document. The document is a list of all supported hardware that Solaris 7 supports. If anyone knows where this can be found thx in advanced. I've tried looking through the docs.sun.com site and can't find what I am after.
It's just a list of hardware... (1 Reply)
Discussion started by: merlin
1 Replies
2. UNIX for Advanced & Expert Users
It has happended twice the past 3 months. The find command which is the standard part of unix accounting script "dodisk", which searches directories to find out how much disk space a user has used.
On a particular cluster of 6 servers, several file systems, the find command has twice used all... (2 Replies)
Discussion started by: scottman
2 Replies
3. Solaris
I have installed sudo on our development server (SPARC,Solaris 9) and trying to edit /etc/sudoers file using visudo. Referred the following sites and not able to find the way.
http://www.courtesan.com/sudo/man/sudoers.html
http://www.kempston.net/solaris/sudo.html
To start with sudo, my... (3 Replies)
Discussion started by: chrs0302
3 Replies
4. Shell Programming and Scripting
Hi,
i got stuck in creating a search job.
I have a text file which looks like this:
======================
Backup - OK -
Backup - OK -
Backup - ERROR -
Backup - WARNING -
======================
I want to search the text file for the string ERROR.
If this string is present in the... (10 Replies)
Discussion started by: lnino
10 Replies
5. UNIX for Dummies Questions & Answers
Ok, it may sound a bit stupid but I can't find the answer.. How do one put 2 here documents in a row? for instance, i want to do something like:
diff <<eof <<eof2 # doesn't work...
> a
> b
> eof
> a
> c
> eof2
its mostly to satisfy my curiosity!!
thanks,
Anthony (4 Replies)
Discussion started by: anthalamus
4 Replies
6. Shell Programming and Scripting
Can we use a here document inside a here document?
Something like this
ssh user@remotehost << REMOTE
sudo vserver vsernamename enter << VSERVER
perform actions on vserver.
VSERVER
REMOTE (6 Replies)
Discussion started by: mnanavati
6 Replies
7. Solaris
Hi, we have a Sun x4150 server connecting to Brocade switches. I need to get all WWN on the Sun server. Here is the result:
# fcinfo hba-port
No Adapters Found.
# prtconf -vp | grep -i wwn
# luxadm probe
ERROR: No Fibre Channel Adapters found.
# luxadm -e port
ERROR: No Fibre Channel... (2 Replies)
Discussion started by: aixlover
2 Replies
8. Solaris
Hi, Here is the issue: There are 4 disks on this Sun x4150 system under Solaris 10, but only 1 disk can be seen by the OS. I've tried commands disks and devfsadm but not working. It's an important production server, so 'reboot -r' is not a choice.
# format < /dev/null
Searching for... (6 Replies)
Discussion started by: aixlover
6 Replies
9. Shell Programming and Scripting
Hello @all
first of all in the best case this script has to work on every os (lnx/aix/sun).
It's very simple what it should do.
I have a standard path and I'll call it for this example /myhome/scripts
Within this path there are more files and folders and some of them are tagged with... (4 Replies)
Discussion started by: Miniqpa
4 Replies
10. Solaris
several newbie questions:
> how-to find serialnumber for Sun E2900
prtdiag -v does not show chassis serial number
> LOM is not connectable .
Are there any tools to get automatically Serial numbers for HW.
Thanks ! (7 Replies)
Discussion started by: magedfawzy
7 Replies
LEARN ABOUT PHP
oci_error
OCI_ERROR(3) OCI_ERROR(3)
oci_error - Returns the last error found
SYNOPSIS
array oci_error ([resource $resource])
DESCRIPTION
Returns the last error found.
The function should be called immediately after an error occurs. Errors are cleared by a successful statement.
PARAMETERS
o $resource
- For most errors, $resource is the resource handle that was passed to the failing function call. For connection errors with
oci_connect(3), oci_new_connect(3) or oci_pconnect(3) do not pass $resource.
RETURN VALUES
If no error is found, oci_error(3) returns FALSE. Otherwise, oci_error(3) returns the error information as an associative array.
oci_error(3) Array Description
+----------+--------------------------------------+---+
|Array key | | |
| | | |
| | Type | |
| | | |
| | Description | |
| | | |
+----------+--------------------------------------+---+
| | | |
| code | | |
| | | |
| | | |
| | integer | |
| | | |
| | The Oracle error number. | |
| | | |
| | | |
| message | | |
| | | |
| | | |
| | string | |
| | | |
| | The Oracle error text. | |
| | | |
| | | |
| offset | | |
| | | |
| | | |
| | integer | |
| | | |
| | The byte position of an error in | |
| | the SQL statement. If there was no | |
| | statement, this is 0 | |
| | | |
| | | |
| sqltext | | |
| | | |
| | | |
| | string | |
| | | |
| | The SQL statement text. If there | |
| | was no statement, this is an empty | |
| | string. | |
| | | |
+----------+--------------------------------------+---+
EXAMPLES
Example #1
Displaying the Oracle error message after a connection error
<?php
$conn = oci_connect("hr", "welcome", "localhost/XE");
if (!$conn) {
$e = oci_error(); // For oci_connect errors do not pass a handle
trigger_error(htmlentities($e['message']), E_USER_ERROR);
}
?>
Example #2
Displaying the Oracle error message after a parsing error
<?php
$stid = oci_parse($conn, "select ' from dual"); // note mismatched quote
if (!$stid) {
$e = oci_error($conn); // For oci_parse errors pass the connection handle
trigger_error(htmlentities($e['message']), E_USER_ERROR);
}
?>
Example #3
Displaying the Oracle error message, the problematic statement, and the position of the problem of an execution error
<?php
$stid = oci_parse($conn, "select does_not_exist from dual");
$r = oci_execute($stid);
if (!$r) {
$e = oci_error($stid); // For oci_execute errors pass the statement handle
print htmlentities($e['message']);
print "
<pre>
";
print htmlentities($e['sqltext']);
printf("
%".($e['offset']+1)."s", "^");
print "
</pre>
";
}
?>
PHP Documentation Group OCI_ERROR(3)