Solved

Java codes and Oracle SID

Posted on 2003-11-09
2
382 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
Comment Utility
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
Comment Utility
 Here is a script: http://www.jlcomp.demon.co.uk/settsid.html Use jimmack's suggestion toi make it work.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…

762 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

6 Experts available now in Live!

Get 1:1 Help Now