Appboard/old/configuration database/example oracle - Revision history

imported>Jason.nicholls at 09:16, 18 July 2014

2014-07-18T09:16:48Z

← Older revision		Revision as of 09:16, 18 July 2014
Line 1:		Line 1:
	{{DISPLAYTITLE:Oracle}}		{{DISPLAYTITLE:Oracle}}
			[[Category:AppBoard old]]

	This section describes the tasks that must be performed in order to use Oracle with enPortal:		This section describes the tasks that must be performed in order to use Oracle with enPortal:
Line 15:		Line 16:
	Table A1: Oracle Installation Screen Prompts		Table A1: Oracle Installation Screen Prompts
	<br>		<br>
	{\|class="wikitable~~" border="1" style="background-color:#eeeeee;~~"		{\|class="wikitable"
	!Prompt		!Prompt
	!Value		!Value

imported>Jason.nicholls: moved Configuring Databases/Oracle to appboard/old/configuration database/example oracle

2014-07-18T09:16:29Z

moved Configuring Databases/Oracle to appboard/old/configuration database/example oracle

← Older revision	Revision as of 09:16, 18 July 2014
(No difference)

imported>David.moore at 20:05, 25 November 2013

2013-11-25T20:05:00Z

← Older revision		Revision as of 20:05, 25 November 2013
Line 81:		Line 81:
	#*Connect As: SYSDBA		#*Connect As: SYSDBA
	#Click Instance and set the state to Open.		#Click Instance and set the state to Open.

			=== Creating a User ===

			To create a new Oracle database user:

			#Start the Oracle Database DBA Studio.
			#*Windows: Launched from the Start menu.
			#*UNIX: Launched by executing the following command: <tt>$ORACLE_HOME/bin/oemapp dbastudio</tt>
			#Connect to the portal database using the following parameters:
			#*Username: system
			#*Password: manager
			#*Connect As: NORMAL
			#Expand portal→Security→Users
			#Right-click Users and select Create from the pop-up menu.
			#In the Create User window, enter values for the Name and Password. It is recommended that you use portal for both
			#Click the Role tab. The Role page opens.
			#Grant the additional roles of:
			#*IMP_FULL_DATABASE
			#*RESOURCE
			#Click Create. The user has been created.

imported>David.moore: /* Managing the Database */

2013-11-25T20:03:15Z

Managing the Database

← Older revision		Revision as of 20:03, 25 November 2013
Line 80:		Line 80:
	#*Password: manager		#*Password: manager
	#*Connect As: SYSDBA		#*Connect As: SYSDBA
	4. Click Instance and set the state to Open.		#Click Instance and set the state to Open.

imported>David.moore at 20:03, 25 November 2013

2013-11-25T20:03:02Z

← Older revision		Revision as of 20:03, 25 November 2013
Line 67:		Line 67:
	\|UTF8		\|UTF8
	\|}		\|}

			=== Managing the Database ===

			To connect to an Oracle database as manager:

			#Start the Oracle Database DBA Studio.
			#*Windows: Launched from the Start menu.
			#*UNIX: Launched by executing the following command: <tt>$ORACLE_HOME/bin/oemapp dbastudio</tt>
			#Add a new database to the tree.
			#Open the database and connect to the new database using the following parameters:
			#*Username: system
			#*Password: manager
			#*Connect As: SYSDBA
			4. Click Instance and set the state to Open.

imported>David.moore at 20:01, 25 November 2013

2013-11-25T20:01:54Z

← Older revision		Revision as of 20:01, 25 November 2013
Line 38:		Line 38:
	#Ensure that a listener exists for the local machine and identify the TCP/IP port on which it is listening. The default port is 1521.		#Ensure that a listener exists for the local machine and identify the TCP/IP port on which it is listening. The default port is 1521.
	#Close the Oracle Net8 Assistant.		#Close the Oracle Net8 Assistant.

			=== Creating a Database ===

			To create an Oracle database:

			#Start the Oracle Database Configuration Assistant.
			#*Windows: Launched from the Start menu.
			#*UNIX: Launched by executing the following command: <tt>$ORACLE_HOME/bin/dbassist</tt>
			#Choose Custom for the type of database to create. Except for the values shown in Table A2, choose all defaults:

			Table A2: Oracle Database Configuration Assistant Prompts and Values
			<br>
			{\|class="wikitable" border="1" style="background-color:#eeeeee;"
			!Prompt
			!Value
			\|-
			\|Type of Configuration
			\|Custom
			\|-
			\|Database Identification:
			*Global Database Name
			*SID
			\|
			*portal (recommended value)
			*portal (recommended value)
			\|-
			\|Character Set (same screen as SID)
			\|UTF8
			\|}

imported>David.moore at 19:38, 25 November 2013

2013-11-25T19:38:49Z

← Older revision		Revision as of 19:38, 25 November 2013
Line 28:		Line 28:
	\|No		\|No
	\|}		\|}

			=== Listener Verification ===

			To verify a listener for Oracle is active:

			#Start the Oracle Net8 Assistant.
			#*Windows: Launched from the Start menu.
			#*UNIX: Launched by executing the following command: <tt>$ORACLE_HOME/bin/netasst</tt>
			#Ensure that a listener exists for the local machine and identify the TCP/IP port on which it is listening. The default port is 1521.
			#Close the Oracle Net8 Assistant.

imported>David.moore: Created page with '{{DISPLAYTITLE:Oracle}} This section describes the tasks that must be performed in order to use Oracle with enPortal: === Installing Oracle === These installation instructions…'

2013-11-25T19:36:54Z

Created page with '{{DISPLAYTITLE:Oracle}} This section describes the tasks that must be performed in order to use Oracle with enPortal: === Installing Oracle === These installation instructions…'

New page

{{DISPLAYTITLE:Oracle}}

This section describes the tasks that must be performed in order to use Oracle with enPortal:

=== Installing Oracle ===

These installation instructions apply to Oracle 8i. To install Oracle:

#Obtain the Oracle installation media.
#On the server, start the Oracle Universal Installer.
#Follow the instructions that appear and enter appropriate values when necessary. When prompted for the following information, enter the values listed in Table A1. This will help ensure that Oracle functions properly with enPortal.

{{Note|The database must be set to treat strings in a case-sensitive manner.}}

Table A1: Oracle Installation Screen Prompts
<br>
{|class="wikitable" border="1" style="background-color:#eeeeee;"
!Prompt
!Value
|-
|Product Selection
|Oracle 8i Enterprise Edition
|-
|Installation Type
|Minimal
|-
|Make Starter Database
|No
|}