Oracle-Solaris - Versionshistorik

Js146669: /* Solaris Kernel Params for Oracle Dbase */

2021-09-29T08:03:40Z

‎Solaris Kernel Params for Oracle Dbase

Js146669: /* Solaris IPS Publisher Package tool */

2021-09-29T08:01:02Z

‎Solaris IPS Publisher Package tool

Js146669: /* Solaris IPS Publisher Package tool */

2021-09-29T07:59:45Z

‎Solaris IPS Publisher Package tool

Js146669 den 29 september 2021 kl. 07.59

2021-09-29T07:59:08Z

Js146669 den 26 maj 2021 kl. 16.34

2021-05-26T16:34:24Z

Js146669 den 5 september 2017 kl. 20.36

2017-09-05T20:36:41Z

@@ Rad 117: / Rad 117: @@
                 -K "process.max-sem-nsems=(priv,2000,deny)" \
                 -K "process.max-file-descriptor=(basic,4096,deny)" oracledb
 Check a list of running processes and their assigned projects

@@ Rad 124: / Rad 124: @@
 Display available versions
   $ pkg list -af entire
 Dry-run update

@@ Rad 123: / Rad 123: @@
 == Solaris IPS Publisher Package tool ==
 Display available versions
-	# pkg list -af entire
+ $ pkg list -af entire
 Dry-run update
-	$ pkg update -nv entire@11.4-11.4.8.0.1.5.0 '*'
+ $ pkg update -nv entire@11.4-11.4.8.0.1.5.0 '*'
 Be sure to use the -nv options and check the output before performing the actual update.
@@ Rad 132: / Rad 132: @@
 Update the pkg
-	$ pkg update --be-name 20200528 entire@11.4-11.4.8.0.1.5.0 ‘*'
+ $ pkg update --be-name 20200528 entire@11.4-11.4.8.0.1.5.0 ‘*'

← Äldre version		Versionen från 29 september 2021 kl. 07.59
Rad 120:		Rad 120:
	Check a list of running processes and their assigned projects		Check a list of running processes and their assigned projects
	$ prstat -J		$ prstat -J
		+
		+	== Solaris IPS Publisher Package tool ==
		+	Display available versions
		+	# pkg list -af entire
		+
		+	Dry-run update
		+	$ pkg update -nv entire@11.4-11.4.8.0.1.5.0 '*'
		+	Be sure to use the -nv options and check the output before performing the actual update.
		+
		+	When you perform the actual update, use the --be-name option to give the new BE a meaningful name.
		+
		+	Update the pkg
		+	$ pkg update --be-name 20200528 entire@11.4-11.4.8.0.1.5.0 ‘*'

← Äldre version		Versionen från 26 maj 2021 kl. 16.34
Rad 59:		Rad 59:
	# nscfg import –f svc:/network/dns/client:default		# nscfg import –f svc:/network/dns/client:default
	# svcadm refresh dns/client		# svcadm refresh dns/client
		+
		+
		+	== Solaris Kernel Params for Oracle Dbase ==
		+	Starting with Solaris 10, these kernel adjustments are now done through Project Resource Management.
		+	*Adjustments done through the projects does not require a reboot anymore.
		+	*All that is needed from the user associated to the project is to re-login for changes to take effect.
		+	*This is an improvement, especially when multiple applications are running on the same server and CM/reboot restrictions apply.
		+
		+	Below is a table of kernel parameter definition and their equivalent in projects.
		+	'''shmmax''' - indicates maximum allowable size of shared memory segment
		+	(default=1048576 (1mb) max=4294967295 (4gb))
		+	'''shmmin''' - smallest size (bytes) of a shared memory segment
		+	(default=1 max=4294967295)
		+	'''shmmni''' - maximum shared memory segments in the system
		+	(default=100 max=2147483647)
		+	'''shmseg''' - maximum number of shared memory segments a user process can attach.
		+	Usually set equal to shmmni (default=6 max=32767 (32k))
		+	'''semmns''' - the number of semaphores in the system
		+	(SID_A+SID_B)+(SID_C * 2)+(no. of instances * 10)
		+	where: SID_A,SID_B,SID_C = processes value per instance
		+	SID_C = has the largest value
		+	'''semmni''' - the number of semaphore set identifiers that can be
		+	created at any one time
		+	'''semmsl''' - maximum number of semaphores that can be in one semaphore set.
		+	Should be equal to or greater than the value of oracle processes.
		+
		+	Check the Resource Control value of a project
		+	Example for Project user.root:
		+	$ prctl -n project.max-shm-memory -i project user.root
		+
		+	Temporarily set 2 GB max shared memory
		+	$ prctl -n project.max-shm-memory -v 2gb -r -i project user.root
		+	$ prctl -n project.max-shm-memory -i project user.root
		+
		+	List existing value of process param of current session
		+	$ prctl -n process.max-sem-nsems $$
		+	Temporary set a new value of process param & verify the new settings
		+	$ prctl -n process.max-sem-nsems -v 8192 -r -i process 9334
		+	$ prctl -n process.max-sem-nsems 9334
		+
		+	Add a new project
		+	$ projadd -p 200 -c "Oracle Database Project" \
		+	-K "project.max-shm-memory=(priv,4294967296,deny)" \
		+	-K "process.max-sem-nsems=(priv,1024,deny)" \
		+	-K "process.max-file-descriptor=(basic,4096,deny)" oracledb
		+	where:
		+	-p \| assigned project id (is optional)
		+	-U \| list of member users
		+	-G \| list of member group
		+	-c \| comment
		+	-K \| key values
		+
		+	Verify changes added in /etc/project
		+
		+	To modify existing project use projmod.
		+	$ projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" \
		+	-K "process.max-sem-nsems=(priv,2000,deny)" \
		+	-K "process.max-file-descriptor=(basic,4096,deny)" oracledb
		+
		+	Check a list of running processes and their assigned projects
		+	$ prstat -J

← Äldre version		Versionen från 5 september 2017 kl. 20.36
Rad 1:		Rad 1:
		+	__TOC__
	==Disk Devices==		==Disk Devices==