Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • moving lob object to other tablespace lob_mvmt.sql Oracle
  • Explain Plan Output 2 Oracle
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • Privileges Required to Create Procedures and Functions that uses objects from other schema. Oracle
  • Export With Query Another Example. Oracle
  • chk_space_SID.ksh Linux/Unix
  • pvm_metric.sql for gathering report from vmstat tables Oracle
  • Pending Transaction Neighbors Script Oracle
  • usnsql.sql Displays information about UNDO segments with sql statements Oracle
  • telnet listening Linux/Unix
  • oracle tips… from http://www.bijoos.com/oracle/douknow.htm Oracle
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
  • Kill a session dynanically using execute immediate Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • before_trunc.sql Before Truncate table needs to execute following: 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

  • Transfer SQL Profiles from One database to other database. Oracle
  • ipcs -l Linux/Unix
  • Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
  • Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
  • How to remove blank lines using vi editor command Linux/Unix
  • How to change hostname in Linux 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • All About oracle password and security from metalink Oracle
  • find_longsql.sql Oracle
  • usnsql.sql Displays information about UNDO segments with sql statements Oracle
  • Facts about SCN and Rollback Segment Oracle
  • How to change hostname in Linux Linux/Unix
  • Oracle 10g for solaris 10 Oracle
  • Rman Notes -1 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme