• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

Java codes and Oracle SID

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
spoj
Asked:
spoj
1 Solution
 
jimmackCommented:
Well, I've no idea (yet ;-)) what and SID is, but you can call your command line using:

Runtime.getRuntime().exec("oradim -sid ...");
0
 
girionisCommented:
 Here is a script: http://www.jlcomp.demon.co.uk/settsid.html Use jimmack's suggestion toi make it work.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now