- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle basic questions
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-04-2006 02:01 AM
тАО07-04-2006 02:01 AM
Oracle basic questions
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-04-2006 02:31 AM
тАО07-04-2006 02:31 AM
Re: Oracle basic questions
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-04-2006 03:09 AM
тАО07-04-2006 03:09 AM
Re: Oracle basic questions
http://www.freeprogrammingresources.com/oracle.html
Here you can get a lot of stuff on Oracle.
Andrey
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-04-2006 03:13 AM
тАО07-04-2006 03:13 AM
Re: Oracle basic questions
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-04-2006 01:09 PM
тАО07-04-2006 01:09 PM
Re: Oracle basic questions
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
The metalink site is a good one. A couple of others I like,
http://www.lazydba.com
http://www.tech-tips.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-04-2006 06:03 PM
тАО07-04-2006 06:03 PM
Re: Oracle basic questions
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 :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2006 09:49 PM
тАО07-06-2006 09:49 PM
Re: Oracle basic questions
Sorry for the delay, I was out of office. Thanks for the information.
You are really nice.
BR