?
Solved

Java codes and Oracle SID

Posted on 2003-11-09
2
Medium Priority
?
388 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 15

Accepted Solution

by:
jimmack earned 1000 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

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.

Question has a verified solution.

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

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…
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 …
This video teaches viewers about errors in exception handling.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Suggested Courses
Course of the Month9 days, 2 hours left to enroll

764 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