LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 05-10-2003, 07:02 AM   #1
juby
Member
 
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 ..it 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, 02:15 PM   #2
hamster
Member
 
Registered: Apr 2003
Location: Waterford, Ireland
Distribution: Mandrivia 2006.1, Ubuntu 7.10
Posts: 188

Rep: Reputation: 30
juby,

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)

orcl:/home/oracle/product/9.0.1:Y


In your shell, try:
export ORACLE_SID=ORCL

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, 05:39 PM   #3
nakkaya
LQ Guru
 
Registered: Jan 2003
Location: Turkey&USA
Distribution: Emacs and linux is its device driver(Slackware,redhat)
Posts: 1,398

Rep: Reputation: 45
http://www.eweek.com/article2/0,3959,293,00.asp here is a good benchmark on databases
 
  


Reply


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 01:06 AM
xhost + as user oracle not working, need to see oracle install GUI enzo250gto Linux - Software 2 02-11-2007 11:27 AM
oracle 8i pudhiyavan Linux - Software 1 01-25-2005 05:06 AM
Oracle 9i client with Oracle 8i server ganninu Programming 1 02-19-2004 04:35 PM
Oracle 8i sathu Linux - Software 4 10-04-2002 01:23 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:12 PM.

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