Oracle newbie

[Sybrand Bakker]

On Thu, 5 Dec 2002 09:31:51 -0600, "Aaron M. Lowe"
<sweetnlowe@telocity.com> wrote:

>Hello,
>
>I'm a SQL DBA who has had experience with SQL Server 6.5, 7 and 2000.
>However in addition to SQL, I just got added to my responsibilities to
>manage an installation of Oracle 8.1.7 with at least two databases. I have
>no experience doing anything with Oracle. Any suggestions on books,
>courses, training material, etc that could help me?
>
>Thanks,
>
>Aaron Lowe
>

The Oracle Concepts Manual, online at [url]http://tahiti.oracle.com[/url] as a
first read, starting now.


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

[Karsten Farrell]

Aaron M. Lowe wrote:

> Hello,
>
> I'm a SQL DBA who has had experience with SQL Server 6.5, 7 and 2000.
> However in addition to SQL, I just got added to my responsibilities to
> manage an installation of Oracle 8.1.7 with at least two databases. I have
> no experience doing anything with Oracle. Any suggestions on books,
> courses, training material, etc that could help me?
>
> Thanks,
>
> Aaron Lowe
>
>

How much money do you want to spend? Oracle training is great ... but
very pricey. Some 3rd party vendors offer the same kinds of classes for
less money. For a moderate amount of money, go to your local bookstore
and get Tom Kyte's One-on-One book (even has some stuff for the sql
server guru). There are also many other Oracle books available (there's
a series of Oracle 101 books that are introductory in nature). If you
don't have a local bookstore, you can check Amazon.com. For free, you
can read all the Oracle-written documentation at [url]http://tahiti.oracle.com[/url].

[Paul Brewer]

"Aaron M. Lowe" <sweetnlowe@telocity.com> wrote in message
news:asnu67$933$1@newsx.cc.uic.edu...

> Hello,
>
> I'm a SQL DBA who has had experience with SQL Server 6.5, 7 and 2000.
> However in addition to SQL, I just got added to my responsibilities to
> manage an installation of Oracle 8.1.7 with at least two databases. I

have

> no experience doing anything with Oracle. Any suggestions on books,
> courses, training material, etc that could help me?
>
> Thanks,
>
> Aaron Lowe
>

Good luck, and welcome!

In addition to the excellent recommendations made already, you might care to
consider Oracle: The Complete Reference (Loney, et al).

A sensible approach, IMHO, might be to temporarily 'unlearn' your SQL Server
knowledge when dealing with Oracle, and to temporarily 'unlearn' your Oracle
knowledge when dealing with SQL Server.
Imagine yourself to be a new starter in either case.
Architecture and appropriate techniques diverge so much between the two.

Regards,
Paul

Senior Oracle DBA, and last resort (very junior) SQL Server DBA - only when
they can't find anybody else.

[Joel Garry]

"Aaron M. Lowe" <sweetnlowe@telocity.com> wrote in message news:<asnu67$933$1@newsx.cc.uic.edu>...

> Hello,
>
> I'm a SQL DBA who has had experience with SQL Server 6.5, 7 and 2000.
> However in addition to SQL, I just got added to my responsibilities to
> manage an installation of Oracle 8.1.7 with at least two databases. I have
> no experience doing anything with Oracle. Any suggestions on books,
> courses, training material, etc that could help me?

Here's some good suggestions:

[url]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&newwindow=1&selm=art0dc%243tc%241%248300dec7%40n ews.demon.co.uk[/url]

>
> Thanks,
>
> Aaron Lowe

jg
--
@home is bogus. "I agree that the market is much more efficient than
bureaucracies. But all of us who have preached the University of
Chicago/Austrian School free market dogma have egg on our faces. In my
own case, mea maxima culpa. Now, the regulatory and criminal justice
system must be fortified and unleashed." - Don Bauder

[db_happy]

Hello

I install Oracle8 Enterprise Edition Release 8.0.4 for Windows NT and
I choose Typical in Starter Database.As I understand ORACLE create a
sample database for me (If that is wrong please inform me).Also the
installation create some services.Probably my starter database is
OracleServiceORCL and OracleStartORCL which they running.Also running
OracleTNSListener80 and OracleWebAssistant.

Then i try to connect with Oracle Enterprise Manager with username
internal and password oracle (i found this information in the
Internet).In the left upper pane none of the choices show me nothing.

How can i show my database in Oracle Enterprise Manager?
Can this done via SQL (I am interested more in connection howto no in
common SQL queries - but a full example it is OK for me)

[Stephen_CA]

[email]database@freemail.gr[/email] (db_happy) wrote in message news:<b625e551.0307160202.c7d6981@posting.google.c om>...

> Hello
>
> I install Oracle8 Enterprise Edition Release 8.0.4 for Windows NT and
> I choose Typical in Starter Database.As I understand ORACLE create a
> sample database for me (If that is wrong please inform me).Also the
> installation create some services.Probably my starter database is
> OracleServiceORCL and OracleStartORCL which they running.Also running
> OracleTNSListener80 and OracleWebAssistant.
>
> Then i try to connect with Oracle Enterprise Manager with username
> internal and password oracle (i found this information in the
> Internet).In the left upper pane none of the choices show me nothing.
>
> How can i show my database in Oracle Enterprise Manager?
> Can this done via SQL (I am interested more in connection howto no in
> common SQL queries - but a full example it is OK for me)

To see the sample database log in as SCOTT/TIGER

[OakRogbak_erPine@yahoo.com Kill the 2 trees in email address to reply]

newbie,
On NT, check your services. Any oracle database will be listed in the
format OracleServiceTest (for a database named test)

If you have any there, you can try login in with the following
usernames & passwords
SCOTT TIGER
SYSTEM MANAGER
SYS CHANGE_ON_INSTALL

If you do not have a database, you can use the Database Assistant to
create one for you. If you are able to login to an existing database
with the above passwords, changed them to something else if the
database contains any real/sensitive data. There might be some other
usernames that will need passwords changed as well)

To see your database in Enterprise Manager, after logging in
(Standalone mode) then choose from the top navigation buttons
NAVIGATION--Add database to tree, then you can try to add it manually
by providing the info, or have it found in the tnsnames.ora file.
-Roger

[email]database@freemail.gr[/email] (db_happy) wrote in message news:<b625e551.0307160202.c7d6981@posting.google.c om>...

> Hello
>
> I install Oracle8 Enterprise Edition Release 8.0.4 for Windows NT and
> I choose Typical in Starter Database.As I understand ORACLE create a
> sample database for me (If that is wrong please inform me).Also the
> installation create some services.Probably my starter database is
> OracleServiceORCL and OracleStartORCL which they running.Also running
> OracleTNSListener80 and OracleWebAssistant.
>
> Then i try to connect with Oracle Enterprise Manager with username
> internal and password oracle (i found this information in the
> Internet).In the left upper pane none of the choices show me nothing.
>
> How can i show my database in Oracle Enterprise Manager?
> Can this done via SQL (I am interested more in connection howto no in
> common SQL queries - but a full example it is OK for me)

[Daniel Morgan]

db_happy wrote:

> Hello
>
> I install Oracle8 Enterprise Edition Release 8.0.4 for Windows NT and
> I choose Typical in Starter Database.As I understand ORACLE create a
> sample database for me (If that is wrong please inform me).Also the
> installation create some services.Probably my starter database is
> OracleServiceORCL and OracleStartORCL which they running.Also running
> OracleTNSListener80 and OracleWebAssistant.
>
> Then i try to connect with Oracle Enterprise Manager with username
> internal and password oracle (i found this information in the
> Internet).In the left upper pane none of the choices show me nothing.
>
> How can i show my database in Oracle Enterprise Manager?
> Can this done via SQL (I am interested more in connection howto no in
> common SQL queries - but a full example it is OK for me)

I don't say this to dampen your enthusiasm and hope you continue to study
Oracle ... but 8.0.4 is so obsolete it will likely be impossible to find
books for it and support, even here in this group, will be difficult.

I would suggest that you go to [url]http://store.oracle.com[/url] and purchase the
CD pack for 8.1.7.4 or, if hardware permits, 9.2.0.

If will be a far happier experience.
--
Daniel Morgan
[url]http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp[/url]
[email]damorgan@x.washington.edu[/email]
(replace 'x' with a 'u' to reply)