Re: Install Probs UNIX/8.0.5

Hi Rick,

first you should give your /oda02 directory to the dba group as well (chown oracle:dba /ora02). This will fix your problem with the directory.

Without the directory I assume there was no database built. So you canīt startup an instance.

After fixing the above directory problem you should create a new database using the oracle installer with create new database objects. You will be asked if this will be an ofa installation and for the three ofa mount-points. OFA is the Oracle Flexible Architecture which is highly recommended for transparent and readable installations. You can create your own OFA mount points anywhere in your filesystems and give them to the installer. The OFA directory structure will be build on the drives by the installer. Remember OFA is only a directory structure. No myst.

The connect hanging is because sql*net will try to find any database in your network which fullfills the @mySID Name. To do this it will first look in all available tnsnames.ora files and then search your network/wan for some well-known oracle name servers (onames). This is network/cpu bound and therefore you will get a timeout after some 30seconds. The connect internal connects you to the local Database identified by the ORACLE_SID environment variable. This could be an idle instance which you then startup using the "startup" command.

svrmgrl> connect internal
svrmgrl> connected to an idel instance.
svrmgrl> startup
svrmgrl> .....

Now you can type your normal statements.

Donīt forget to configure and start your listener and the tnsnames.ora.

For details please read the manuals.

Hope this helps
Andy

Rick schrieb:

> Hi,
> new to Oracle admin and having several problems
> 1) When i try to install with the option of creating new dataabase objects
> it fails ssaying it cant write to the /ora02 directory i created. It is
> owned by the oracle user with r/w/x permissions. any body know wha'ts up
>
> 2) I ran the install without creating Db objects but I cant really tell if
> the database is starting, I dont think is is but the alert_mySID.log file
> show that startup went fine but i cant find the process. next to the log
> file, mySID_ora_736.trc says on the last line after listing Unix process
> pid' value it says 'OPIRIP: Uncaught error 1034. Error stack: ORA-01034'
>
> 3)When i try in servermanager (command line) if I try 'CONNECT @mySID' after
> entering the password the CPU goes to 100% and seems to hang. But if i say
> 'CONNECT internal' it return connected but every command returns ORACLE not
> available
>
> 4) lastly what is an OFA directory, can it just be a random directory on my
> hard drive or does it have to be on other media and does it require special
> formatting
>
> sorry 4 newbie blabber, thanks in advance
>
> rick
Received on Mon Dec 13 1999 - 07:57:15 CST