Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Transfer SQL Profiles from One database to other database. Oracle
  • Oracle Data Direct to TAPE Oracle
  • Create type and Grant on it. Oracle
  • USE_NL and INDEX hints example Oracle
  • copying/removing directory with all its subdirectory Linux/Unix
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • Multiple listeners Oracle
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • Good links for x$ tables in oracle. Oracle
  • DBMS_STATS Metalinks Notes Oracle
  • Reclaim temp tablespace for oracle 8, 8i Oracle
  • Read CSV file using PySpark Python/PySpark
  • nfs mount command Linux/Unix
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle

Important Solaris Commands

Posted on 28-Sep-2005 By Admin No Comments on Important Solaris Commands

(*) To determine the size of the configured swap space, enter the following command:

/usr/sbin/swap -s

(*) To determine whether the system architecture is 64-bit, enter the following command:

/bin/isainfo -kv

This command should return the following output. If you do not see the expected output, you cannot install the 64-bit Oracle software on this system.

64-bit sparcv9 kernel modules

(*) To determine which version of Solaris is installed, enter the following command:

# uname -r

5.8

(*) To determine whether the required packages are installed, enter a command similar to the following:

# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms

SUNWsprot SUNWsprox SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs

SUNWxwfnt

(*) To determine whether an operating system patch is installed, enter a command similar to the following:

# /usr/sbin/patchadd -p | grep patch_number

If an operating system patch is not installed, download it from the following Web site and install it:

http://sunsolve.sun.com

(*) To determine whether the oinstall and dba groups exist, enter the following commands:

# grep oinstall /etc/group

# grep dba /etc/group

(*) If necessary, enter the following commands to create the oinstall and dba groups:

# /usr/sbin/groupadd oinstall

# /usr/sbin/groupadd dba

(*) To determine whether the oracle user exists and belongs to the correct groups, enter the following command:

# id -a oracle

If the oracle user exists, this command displays information about the groups to which the user belongs. The output should be similar to the following, indicating that oinstall is the primary group and dba is a secondary group:

uid=502(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)

(*) Changing group of user.

If the oracle user exists, but its primary group is not oinstall or it is not a member of the dba group, enter the following command:

# /usr/sbin/usermod -g oinstall -G dba oracle

(*) If the oracle user does not exist, enter the following command to create it:

# /usr/sbin/useradd -g oinstall -G dba oracle

This command creates the oracle user and specifies:

– oinstall as the primary group

– dba as the secondary group

(*) To set the password.

# passwd oracle

(*) kernel parameters

/etc/system has all kernel parameters defined there.

(*) To reboot the server.

Enter a command similar to the following to reboot the system:

# /usr/sbin/reboot

(*) The configuration assistants configure several Web-based applications, including Oracle Enterprise Manager Database Control. This screen displays the

URLs configured for these applications. Make a note of the URLs used. The port numbers used in these URLs are also recorded in the following file:

$ORACLE_HOME/install/portlist.ini

Linux/Unix, shell

Post navigation

Previous Post: SYSOPER Mystery
Next Post: Oracle 10g Installation/Applying Patches Tips

Related Posts

  • catall.sh Linux/Unix
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
  • cold backup scripts to copy locally Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • How to remove blank lines using vi editor command Linux/Unix
  • chk_space_SID.ksh Linux/Unix

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Renaming Global Name GLOBAL_NAME Oracle
  • Unix split command to split files Linux/Unix
  • Physical Standby switchover with session active Oracle
  • Find Time Consuming SQL Statements in Oracle 10g Oracle
  • Some OS level threshold for performance. Linux/Unix
  • Disbaling DBA_SCHEDULER_JOBS Oracle
  • currwait.sql Oracle
  • currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme