Oracle Process has removed from AIX5.2

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Kill all process of Oracle user

Hi folks, I want to kill all process of oracle user and won't kill shell, should i try this? Please confirm. 1st way pgrep -u oracle | sudo xargs kill -9 2nd way killall -u oracle

2. AIX

SIGHUP killing Oracle Listener Process

I have a cold backup script which backs up my database and then restarts the oracle listener and database at around 01:30 I can see at this time that my database and listener are indeed running. However at around 02:17 my listener process receives a SIGHUP 1 signal from the AIX OS ( version 5.3 )...

3. AIX

oracle process appears to die

periodically my oracle 11.2.0.1 listener process 'tnslsnr' seems to crash and disappear ( I am using an AIX 6.1 unix platform ). When this happens I am able to restart my listener ok. However when this happens there is is no stop recorded in my listener log (as there normally would be - hence why I...

4. Shell Programming and Scripting

Oracle Process Memory calculation

Hello, I am using Rehat Oracle Enterprise server. Every time almost 150 process running on my server. #ps -ef | grep oracle | wc -l Now i want to calculate how much memory spend by each process or all process together.

5. AIX

How to upgrade AIX5.3TL6-07 to AIX5.3TL8-04?

Hello All, After creating lpp_source/spot from AIX 5.3TL6-07 DVD on the NIM(AIX6.1), I went online and download the fix pack for reaching TL8-04. (it was less than 200Mgegs total) then I did define a newer lpp_source530TL8-04 via a copy from the older lpp_source530TL6-07 (I diduse a command...

6. AIX

Idle Oracle Process has removed automatically in AIX5.2

7. AIX

Oracle 10G best practices on Power6 AIX5.3

Can anyone point me to any best practices for partitioning, resource prerequisites, and implementation of Oracle 10G release 2 with RAC on 2 power6 550's running AIX5.3 as a cluster?

8. UNIX for Dummies Questions & Answers

How to find the port number of the oracle process

Hi Unix Gurus, Can we find out the port number used by the oracle process is running.I tried to search the forum but coudnt find. Can anyone help me out with the command

9. UNIX for Advanced & Expert Users

oracle process query !

This query is For HP-UX 11i server. I have certain oracle process that are running on my system as below :- rotmgr 3986 1 0 07:49:33 ? 0:00 oracleedjlive (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) rotmgr 26356 1 0 08:14:32 ? 0:00 oracleedjlive...

10. UNIX for Dummies Questions & Answers

killing parallel oracle process

Hi guys: I have a an oracle job which uses 10 parallel hints and would like to killit when it hangs. I want to kill all the processes that have been spawned. what I do right now is get the pid of the scheduler process which initiated theis job and the do a ps -ef| grep 'pid' and trace through...

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)

AIX