The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Operating Systems > SUN Solaris
solaris-oracle solaris-oracle
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


SUN Solaris The Solaris Operating System, usually known simply as Solaris, is a free Unix-based operating system introduced by Sun Microsystems .

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Oracle Installation on Solaris panchpan SUN Solaris 5 10-23-2007 04:16 AM
Oracle on Solaris amon Shell Programming and Scripting 1 04-26-2006 09:55 AM
oracle on solaris sveera UNIX for Advanced & Expert Users 2 06-03-2005 11:50 AM
Oracle on Solaris sveera SUN Solaris 6 04-18-2005 03:41 PM
Oracle on solaris. niasdad UNIX Desktop for Dummies Questions & Answers 2 11-06-2002 12:40 PM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 06-03-2008
rags_s11 rags_s11 is offline
Registered User
  
 

Join Date: May 2008
Posts: 11
solaris-oracle
Hi,
what are all best performance practices we can set in solaris box for oracle database 10.2.0.2

Thanks.
  #2 (permalink)  
Old 06-19-2008
gsw_aix gsw_aix is offline
Registered User
  
 

Join Date: Feb 2005
Posts: 4
Solaris & Oracle
1, Setup max shared memory and no semaphores as per the Oracle documentation.

2, Place ALL database files on 1 volume spanning as many disks as you have. Place online redo logs on a Raid 1/10 vol. Place archive redo logs on another Raid1/10 vol.

3, Mount the database files volume with forcedirectio and set the Oracle parameter FILESYSTEMIO_OPTIONS = setall

4, Follow OFA (Oracle Optimal Architecture Guidelines) - use google.

5, Use LMT's locally managed tablespaces everywhere .

6, Use automatic UNDO, and ASSM (Automatic Shared Memory Management) - via 1 oracle parameter SGA_TARGET. Also set PGA_TARGET an mimimum values for the Shared Pool and Buffer Cache.

7, Use an SPFILE

8, Use the standard Oracel dbconsole, its excellent for ad-hoc monitoring.

9, Always use Archive Logging if the database is important.

10, Use RMAN, its fast and easy to use.
  #3 (permalink)  
Old 06-20-2008
olaris olaris is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 12
Can you show me how to encrypt oracle password table ?
The link provided in the other post is confusing.
Thanks experts!
  #4 (permalink)  
Old 06-20-2008
olaris olaris is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 12
There's a plain text root password in my rman script. Is it possible to run it without root password ?
Closed Thread

Bookmarks

« authentication problem | How to Extract »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Hybrid Mode Hybrid Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 10:07 AM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0