Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Experienced SQL Professional Migrating to Oracle 8i

Re: Experienced SQL Professional Migrating to Oracle 8i

From: James Belton <jbelton_at_freenetname.co.uk>
Date: Tue, 14 Mar 2000 16:49:25 -0000
Message-ID: <8alqin$4i7$1@gxsn.com>


David,

Check out a book by Steven Feuerstien (a big, big oracle guru!) called
'Guide to Oracle 8i features'. You can find a reference to it at my web site
at http://www.jamesbelton.co.uk/html/oracle_books.html

I'll try and answer some of your questions though.....

Enterprise Manager is a great tool for administering your DB's. It should install when you install oracle (it has several components such as storeage manager, schema manager) though it may ask you to install a repository...... a course might be the answer, though, it's too big to cover here! It's a great tool and once you've used it, you won't be able to do without it.

TNSNAMES.ORA should run from the $ORACLE_HOME/network/admin directory, though depending on the tools you are using, this can vary. You should have one entry per database connection, so you shouldn't need to keep changing it unless you are changing your connect string or using a different version of the listener file.
Net8 is the protocol Oracle uses to communicate between server and client. It uses the listener and the tnsnames.ora files to find hosts and clients. You should have one listener per server and the listener should have a reference to all the DB's on the server. This basically tells the server to
'listen' out for connections to the databases. There's a file in your
$ORACLE_HOME/network/admin folder called listener.ora and this is where you set this stuff up.

Oracle is a bit complicated to start with..... I'd suggest you look at the Oracle DBA courses from Oracle Education though, as these give a really good start, even if you already have lots of other DB experience.

Hope this helps you out

Regards

James Received on Tue Mar 14 2000 - 10:49:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US