Re: Linux / Oracle compatibility list

michael v' wrote:
> As suggested in www.dizwell.com I installed White Box Linux and Oracle
> 10g on my PC.
> The walk trough for both installations is great.
>
> Question is, what now?
> How do I create a database and what are the steps to do the first SQL
> queries.

Oh dear. I knew someone was going to ask that! I have been intending to write articles on the "next" bit for a long time... I won't ask you to wait until I do!!

What you actually want to do now is

1. Create a Listener
2. Set up a tnsnames.ora and sqlnet.ora
3. Create a database

To do (a) and (b), you need to invoke the Net Configuration Assistant. At a command prompt, as the Oracle user, type "netca" (without the quotes, of course). Hopefully, you'll be able to whiz through that tool taking the first three options in turn, and it will all make sense to you.

If you get stuck, then you might find the answer under the question "Q. So with the patching completed, can I create my clustered database yet?" in http://www.dizwell.com/html/index9.html helpful.

To do step (c), you invoke the Database Configuration Assistant by typing "dbca" at the command prompt. Again, under the question "OK. So my GSD process is running, and I have a Listener. Can I create my database yet?", at http://www.dizwell.com/html/index9.html, you will find a discussion about using dbca. That article is tailored towards creating a clustered database, of course, but you should recognise most of the screens and my comments about what to insert on each one of them would still be mostly valid.

Once you've a database created, you should be able to type

sqlplus "/ as sysdba"

...to connect as SYS. What I always then do is type this:

SQL> @?/rdbms/admin/utlsampl

That runs a script which creates Scott and his EMP table. It also dumps you back at the command prompt. So, you then follow it up with:

sqlplus scott/tiger

SQL> select * from emp;

And away you go. If you get stuck, mail me like it says on the first page of the site. Or post back here...

And away I go to write that up into a proper article...

Regards
HJR
> Thank you,
> Michael
>
> "Dave" <x_at_x.com> wrote in message news:<jcHld.14373$up1.14246_at_text.news.blueyonder.co.uk>...
>

>>"michael v'" <voichekm_at_yahoo.com> wrote in message 
>>news:162aa345.0411140245.26ba5acc_at_posting.google.com...
>>
>>>Hi,
>>>
>>>I want to install Linux and Oracle on my PC.
>>>Not sure what Linux (redhat/mandrake/.) nor the version.
>>>Is there any kind of compatibility issue that I should know about?
>>>Do not want to buy Linux and Oracle and then find out that they do not
>>>work together.
>>>
>>>Thank you,
>>>Michael
>>
>>look on metalink for the compaitbility matrix - or in the install guide 
>>which is free from tahiti.oracle.com