Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Running Oracle SqlPlus with Java in Kshells

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Running Oracle SqlPlus with Java in Kshells
Prev   Next
# 1  
Old 04-27-2009
Running Oracle SqlPlus with Java in Kshells
Hello,

This may not be the right place to ask for help for this problem but i might be because i'm using Java & SqlPlus in alot of Kshell scripts.

Just to give a high level picture, i'm basically using Java to control each SqlPlus execute command, by reading a flat file that contains the run values from previous steps and then in lets say the current step, check the values from previous steps to see for example if step3 = step1 + step2 ect.

The Java program will compare the previous step rules and then execute the SqlPlus, query to output from the SqlPlus and make a new Java entry.

But what is happening is in the Oracle Session Log it is creating and not deleting 10s upon 10s of seession entries and when i look at some of them they say they are Java executables.

So do you think this is a Java problem and if so is there a way to somehow delete the session immediately after the step runs so that the session thread disappears?

Thanks for any insights and even quesses at this point!

Fyi it's really only a problem now that system has been moved to a very heavily used instance and now everyone is seeing alot more sessions being created other than their own and not sure why the system is grinding to a halt.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Fedora

Fedora: Uninstall Java JDK 1.8 and install Oracle Java 1.7.15

Hi All, I have just downloaded fedora 27 iso and set it up in virtual box. I want to learn Hadoop so trying to install Apache hadoop. Before all those I have to install Oracle Java 1.7.15 (as mentioned in the Apache hadoop page). Can you please help me how to Uninstall currently installed... (6 Replies)
Discussion started by: TechGyaann
6 Replies

2. Shell Programming and Scripting

Running sqlplus for 5 DB in a shell

Hi all, on AIX 6.1 I want to run the following but for 5 DB. How should I do that ? Using FOR, WHILE ???? How ? export ORACLE_SID=DB1 sqlplus / as sysdba << EOF whenever sqlerror exit sql.sqlcode; whenever oserror exit FAILURE set define off set head off set feedback off set echo off... (1 Reply)
Discussion started by: big123456
1 Replies

3. Shell Programming and Scripting

Connect to Oracle using sqlplus

I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'. What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies

4. Shell Programming and Scripting

Connecting to Oracle DB using sqlplus

Hi, I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following: 1. Connect to oracle database hosted on a different server 2. fire a query on the oracle db 3. store the output in a variable 4. use this variable for further logic... (26 Replies)
Discussion started by: shrutihardas
26 Replies

5. UNIX for Dummies Questions & Answers

Connecting to Oracle DB using sqlplus

Hi, I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following: 1. Connect to oracle database hosted on a different server 2. fire a query on the oracle db 3. store the output in a variable 4. use this variable for further logic... (1 Reply)
Discussion started by: shrutihardas
1 Replies

6. Shell Programming and Scripting

Formatting Oracle sqlplus output

a job extracts orcle data into unix as flat file. a single record breaks into two record in unix flat file. This is the case only for 6 records out of 60 lack records. (its not single record in two line. but its single record into record. ie., \n come into picture) can you tell me what... (6 Replies)
Discussion started by: Gopal_Engg
6 Replies

7. UNIX and Linux Applications

How to access Oracle table using sqlplus

Hi, I want to use sqlplus from server1 sqlplus usr1/pass1@dns1 and I want to connect to an Oracle database from a server2. Unfortunately the database was created on the server1 and on server2. So when I use the command just like that...it connects to the database from the server2. ... (2 Replies)
Discussion started by: AngelMady
2 Replies

8. UNIX for Advanced & Expert Users

Executing SQLPLUS in UNIX Script from JAVA

Hi ALL, I would like to execute one SQL query(ORACLE) in UNIX shell script. For this I used sqlplus in script and tested locally. It worked fine. But my requiremnt is to execute the script from Java. In this case the UNIX part is working but sqlplus is not returning anything The JAVA code used... (0 Replies)
Discussion started by: anooptech
0 Replies

9. Shell Programming and Scripting

Running SQLPLUS from Shellscripting ...

Hi guys, I am facing issues while triggering sqlplus with "/" option I can connect to database with USER ID and password. but, if i just specify "/" option since it is "externally identiifed user" it doesn't work Any suggestions? mail me @ Removed. Regards, Giri (2 Replies)
Discussion started by: chittari
2 Replies
Login or Register to Ask a Question

LEARN ABOUT MOJAVE

jsadebugd

jsadebugd(1)						      General Commands Manual						      jsadebugd(1)

NAME

       jsadebugd - serviceability agent debug daemon

SYNOPSIS

       jsadebugd [pid] [server-id]
       jsadebugd executable core [server-id]

DESCRIPTION

       jsadebugd  attaches to a Java process or core file and acts as a debug server. Remote clients such as jstack, jmap, and jinfo can attach to
       the server using Java Remote Method Invocation (RMI). Before starting jsadebugd, rmiregistry must be started with:

	      rmiregistry -J-Xbootclasspath/p:$JAVA_HOME/lib/sajdi.jar

       where $JAVA_HOME is the J2SE SDK installation directory.  If rmiregistry was not started, jsadebugd will start an rmiregistry in a standard
       (1099) port internally. Debug server may be stopped by sending SIGINT (pressing Ctrl-C) to it.

       NOTE - This utility is unsupported and may or may not be available in future versions of the J2SE SDK.  jinfo is not currently available on
       Windows platforms or on the Linux Itanium platform.

PARAMETERS

       pid	      process id of the process to which the debug server should attach. The process must be a Java process. To get a list of Java
		      processes  running  on  a  machine,  jps	may be used.  At most one instance of the debug server may be attached to a single
		      process.

       executable     Java executable from which the core dump was produced.

       core	      core file to which the debug server should attach.

       server-id      optional unique id, needed if multiple debug servers are started on the same machine. This ID must be used by remote clients
		      to identify the particular debug server to attach. Within a single machine, this ID must be unique.

SEE ALSO

       jinfo(1) jmap(1) jps(1) jstack(1) rmiregistry(1)

								   13 June 2004 						      jsadebugd(1)