topic Re: Oracle basic questions in Operating System - HP-UX

Oracle basic questions

Mark2010_1 — Tue, 04 Jul 2006 09:01:46 GMT

Hi,

I am beginner with Oracle and would like to know if some one have some resources regarding:

- Log files of Oracle on HP-UX to be checked (preventive and corrective maintenance)
to ensure healthy operating

- Description of tables and views (how to check and make some select queries)

- Any synthesis documentation

BR

Re: Oracle basic questions

Peter Godron — Tue, 04 Jul 2006 09:31:15 GMT

Hi,
installing the Enterprise manager will give you a nice web-based tool to check the status of the database.

For logfiles you could look at the alert.log file in the bdump directory.

You could install iSQLPLUS which gives to query access via the web.

Re: Oracle basic questions

Andrey Tumanov — Tue, 04 Jul 2006 10:09:45 GMT

Try this:

http://www.freeprogrammingresources.com/oracle.html

Here you can get a lot of stuff on Oracle.

Andrey

Re: Oracle basic questions

Steven E. Protter — Tue, 04 Jul 2006 10:13:39 GMT

Shalom,

Oracle is a fun and wonderful world.

You need to know a few things.

Is the database up.

I would suggest a sqlplus script for that.

On the OS side, you want the filesystem of your oracle redo logs and archive logs to be checked so it does not fill up.

http://technet.oracle.com
http://metalink.oracle.com # support site.

SEP

Re: Oracle basic questions

Rick Garland — Tue, 04 Jul 2006 20:09:42 GMT

An open question that can have multiple answers depending on the configuration.

A log file that can be useful is what is called the 'alert log'. Typically found in the bdump directory. The actual name will vary - often has the instance name included "alert.log

The metalink site is a good one. A couple of others I like,

http://www.lazydba.com
http://www.tech-tips.com

Re: Oracle basic questions

Frank de Vries — Wed, 05 Jul 2006 01:03:21 GMT

As mentioned above the alert.log is
your main log to check.
For internal queries these are the main
once , a report you can run
in sqlplus (so no need to install
other tools )

(to take advantage of the advanced features
of this script rapport you best create
a repository table to store historical
info for trend analysis)
If you are interested in these repository
tables let me know.

See script/rapport attached:)

Keep it simple :)

Re: Oracle basic questions

Mark2010_1 — Fri, 07 Jul 2006 04:49:49 GMT

Hi Guys,

Sorry for the delay, I was out of office. Thanks for the information.

You are really nice.

BR