Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 05-10-2003, 08:02 AM   #1
Registered: Dec 2002
Location: Bangalore, India
Distribution: Ubuntu 5.*
Posts: 241

Rep: Reputation: 30
Oracle 9i probs

I have installed oracle 9i on m y machine.. but when i use dbstart says can tfind init file .. i also have mysql on my machine .. do u think mysql is good enuf as oracle.. ?
Old 05-10-2003, 03:15 PM   #2
Registered: Apr 2003
Location: Waterford, Ireland
Distribution: Mandrivia 2006.1, Ubuntu 7.10
Posts: 188

Rep: Reputation: 30

using oracle9i.... did you create a default "starter" when you first set up oracle? Usually I thought a default init.ora file is created for that database.

The init file holds location info for the db tablespace files etc.

Let's assume your db is called orcl
Before startting your db, ensure that you have your db described in /etc/oratab: (assuming default path and version 9.0.1)


In your shell, try:

then dbstart

or try:

sqlplus /nolog

SQL> connect / as sysdba

If it starts up, try:
select sysdate from dual;
to see if comes back with the date.

mysql is pretty good but if you want stored procedures and functions maybe you could try PostgreSQL7.3.2 (like Oracle). but mysql is planning to implement this support soon.
Old 05-10-2003, 06:39 PM   #3
LQ Guru
Registered: Jan 2003
Location: Turkey&USA
Distribution: Emacs and linux is its device driver(Slackware,redhat)
Posts: 1,398

Rep: Reputation: 45,3959,293,00.asp here is a good benchmark on databases


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference between Oracle Server and Oracle Database ganninu Programming 3 02-27-2007 02:06 AM
xhost + as user oracle not working, need to see oracle install GUI enzo250gto Linux - Software 2 02-11-2007 12:27 PM
oracle 8i pudhiyavan Linux - Software 1 01-25-2005 06:06 AM
Oracle 9i client with Oracle 8i server ganninu Programming 1 02-19-2004 05:35 PM
Oracle 8i sathu Linux - Software 4 10-04-2002 02:23 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:59 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration