cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle basic questions

Mark2010_1
Frequent Advisor

Oracle basic questions

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
6 REPLIES
Peter Godron
Honored Contributor

Re: Oracle basic questions

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.
Andrey Tumanov
Frequent Advisor

Re: Oracle basic questions

Try this:

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

Here you can get a lot of stuff on Oracle.

Andrey
Steven E. Protter
Exalted Contributor

Re: Oracle basic questions

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Rick Garland
Honored Contributor

Re: Oracle basic questions

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
Frank de Vries
Respected Contributor

Re: Oracle basic questions

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 :)


Look before you leap
Mark2010_1
Frequent Advisor

Re: Oracle basic questions

Hi Guys,

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

You are really nice.

BR