| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: Please be kind to a newbie!
Hi John,
I like you am a newbie to Oracle. Have been a sybase DBA for ~5 years and very familiar with SUN. I had the same problem as you. I tried the typical install of version 8.1.7 for Solaris 2.8. Basically my finding was that the Oracle Database Configuration Assistant is f**ked.
What you should try is reinstall the oracle WITHOUT creating the Database. Then fire up Database Conf Ass after successful install of the Oracle software. DO not let it create the databases for you. When you have the option to create the database or save the info to scripts, save it to scripts.
Then have a look at the scripts.
What I ended up having to do was compare the pfile the Database Conf Ass was creating (probably $ORACLE_HOME/admin/$ORACLE_SID/pfile/init<SID>.ora) with the template init.ora file ($ORACLE_HOME/dbs/init.ora).
Make a copy of the init<SID>.ora file. Make a copy of init.ora file as init<SID>.ora. Copy in the new specific information from the original init<SID>.ora file into this new file.
Run the first script in the series (look in the file you saved the scripts to. The first is probably $ORACLE_HOME/<script_dir>/$ORACLE_SIDrun.sh.
It should work correctly. I have a call in with oracle to solve this problem, but after 2 weeks I couldn't get a good answer out of them, so I gave up.
Send me an email, to let me know how you made out.
In article <9992v8$skc$1_at_slb6.atl.mindspring.net>,
"John Gay" <jfg4_at_mindspring.com> writes:
> Thanks to all who have responded. Again I am new to both Solaris and Oracle
> and I feel that there is a little something that I am not doing.
>
> I am trying to install this on a Solaris box named - ra - I am not trying to
> do anything fancy here I just need to create a db instance called "issed"
> for some testing purposes.
>
> I have created the oracle user and he is a member of both the oinstall and
> dba group.
>
> The user has the path set to the Oracle install point ( /ora1/OraHome1) and
> to the bin directory (ora1/OraHome1/bin)
> and the following entries for the profile:
>
> ORACLE_HOME=/ora1/OraHome1
> export ORACLE_HOME
> DISPLAY=ra:0.0
> export DISPLAY
> ORACLE_SID=issed
> export ORACLE_SID
>
> I go through the install for the Enterprise edition accepting all the
> defaults. The install appears to be flawless untill it comes time for it to
> create the database it gets about 80% complete and then it pops up an error
> that says "ORA-01034:ORACLE not available".
>
> All the documentation says is that you should check the paths (which I have)
> and then verify that the Oracle server is running (which I do not know how
> to do). After this message I cancel the DB creation and let it finish. It
> says all is succesful sans the creation of the DB instance.
>
> I can run the Oracle Database Configuration Assistant and get the same
> results.
>
> The Net8 Assistant comes up and all looks well.
>
> Does anyone have any ideas????
>
> Thanks
>
> John
>
Received on Wed Mar 21 2001 - 08:52:10 CST
 |
 |