Solved

Java codes and Oracle SID

Posted on 2003-11-09
2
383 Views
Last Modified: 2010-03-31
Hi all,

Is it possible to create an Oracle SID using java codes. I was trying to install Oracle one time and saw that some of the scripts, i think, could be incorporated within java codes (like "create database ....") because they are just like normal sql lines (like "select * from ....").

The problem is that i must use the command prompt to create an sid (using "oradim -sid ..."). I wanted to know if it is possible to execute something like "oradim" from java codes. All i want to do is to create an automated installation of an application i made and an Oracle database having a specific SID.

Thanx very much.

spoj
0
Comment
Question by:spoj
2 Comments
 
LVL 15

Accepted Solution

by:
jimmack earned 250 total points
ID: 9712875
Well, I've no idea (yet ;-)) what and SID is, but you can call your command line using:

Runtime.getRuntime().exec("oradim -sid ...");
0
 
LVL 35

Expert Comment

by:girionis
ID: 9713343
 Here is a script: http://www.jlcomp.demon.co.uk/settsid.html Use jimmack's suggestion toi make it work.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
This video teaches viewers about errors in exception handling.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now