Unable to configure Oracle sqlplus V12 properly. Need Help. Resources could'nt be found elsewhere .

10 More Discussions You Might Find Interesting

1. Web Development

Do anyone know how to configure document to point to home directory properly in apache?

Hi from Running web apps from your home folder I've more or less follow the guide, the reason why I'm expering 403 Forbidden is because the higher level directory will take precedance. $ ls -lrthd /home/phpmy/www/joomla/ drwxrwxr-x 2 phpmy phpmy 4.0K May 1 20:26...

2. UNIX for Dummies Questions & Answers

SQLPLUS not found

hi, I am new to unix and trying to connect to oracle from unix. I typed the below command and the error is sqlplus not found $ sqlplus -ksh: sqlplus: not found can someone please tell me what is missing? I see that oracle is available on this unix box in the path /opt/oracle as...

3. Shell Programming and Scripting

Can't get shell parameters to pass properly to sqlplus

Gurus, The issue I'm having is that my Shell won't accept SQL parameters properly...... Here's they way I'm running it.... applmgr@ga006hds => sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR' The process just hangs not submitting the SQL job... ...

4. Ubuntu

sqlplus: command not found

I installed Oracle 10.2.1.0 in Ubuntu 10.10..my installation was well,i could even open isqlplus( http://ubuntu.ubuntu-domain:5560/isqlplus/workspace.uix ) and execute some queries..But,back in terminal when i try to login to sqlplus i am getting error

5. Shell Programming and Scripting

sqlplus: not found

Hi All , At the end I have to post my problem thinking I'll be able to get a clue. I have done a shell script to access a table in our database to extract some logs . Script is working when executed manually ,but when I set it up in cronjob it is not working. I know thins should be a...

6. Shell Programming and Scripting

sqlplus : not found

Hi, Below is my script: #!/bin/sh sqlplus uname/pwd@instance <<EOF set wrap off set feedback off set pagesize 0 set verify off set trimspool on set linesize 5000 spool /arboru02/FX/scripts/customer_profile_def.txt select...

7. Shell Programming and Scripting

Multiple SQLPLUS background processes not working properly

Hi All, I am running 25 background process from a Unix shell script which calls a single Oracle procedure with different paramenters each time. These 25 process creates 25 different files. When i run these 25 Background SQLPLUS processes, few files are not created completly but if i run 25...

8. HP-UX

sqlplus: command not found

hi, i need bash shell script run on the crontab(Unix tru64). i have write my shell. it's using sqlplus command and connect to oracle db. execute cron job when i have error messege: "sqlplus: command not found" have you any suggestion?

9. UNIX for Dummies Questions & Answers

No screens found problem - and I cant use keybord properly to solve!!

Title explains it already. I need to solve the problem from log files. But backspace types ^H . I dont know how to delete character. How can I mend the keybord ?

10. UNIX for Dummies Questions & Answers

unable to access hpfs/ntfs properly

i can't access my ntfs partition from one of my linux devices and can only acess it read only on the other... the two linux systems are Fedora core 4 and Ubuntu Hoary hedghog5*... all three are on a 40Gig drive ofcourse the windows partition is the primary partition but Fedora doesn't recognize ...

LEARN ABOUT PHP

oci_set_action

OCI_SET_ACTION(3)														 OCI_SET_ACTION(3)

oci_set_action - Sets the action name

SYNOPSIS

       bool oci_set_action (resource  $connection, string  $action_name)

DESCRIPTION

	Sets the action name for Oracle tracing.

	The action name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement
       is executed.

	The action name can subsequently be queried from database administration views such as V$SESSION. It can be used for tracing and  monitor-
       ing 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 $action_name
		- User chosen string up to 32 bytes long.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Setting the action

	      <?php

	      $c = oci_connect('hr', 'welcome', 'localhost/XE');

	      // Record the action
	      oci_set_action($c, 'Friend Lookup');

	      // 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 actions
	      // being performed:

	      sqlplus system/welcome
	      SQL> select action from v$session;

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.

SEE ALSO

       oci_set_module_name(3), oci_set_client_info(3), oci_set_client_identifier(3).

PHP Documentation Group 													 OCI_SET_ACTION(3)

UNIX for Dummies Questions & Answers