Copy all of these files to a folder called Redthorn_Install on the drive with the most space. Extract the archived folders to this location.
3.Go to Folder "Red_Inst\SERVER" and Copy the following folders to the C:\ drive
CRUSERS
Oraback
Orared
4.Copy the following Folder to the root of the largest drive
Red_Inst\Red_Inst
5.Remove 'Read Only' Attribute from the following folders to include ALL Sub-Folders & Files.
Red_Inst
CRUSERS
Oraback
Orared
6. To setup server for access as a workstation
Browse RED_INST on Server, go into folder ORANT, for Win2K, Win2003 & XP double click w2kf60p17.reg enter it into the registry. For other operating systems use appropriate *.reg file. Open up the registry and check if the key HKLM\Software\ORACLE\HOME0 exists. If not repeat this step.
1. Run setup.exe found in \Redthorn_Install\Database\Disk1\. Use the following settings on each screen, pressing Next or Install to continue.
Oracle Installation screen
Select 'Install/Uninstall Products'
Welcome screen
File Locations screen
Path = 'c:\oracle\ora90'
Name = 'orahome90'
Available Products screen
Select 'Oracle Database 9.2.0.1.0'
Installation Types screen
Select 'Standard Edition'
Database Configuration screen
Select 'General Purpose'
Oracle Services for MTS screen
Confirm '2030'
Database Identification screen
Global Database Name = 'red.world'
(SID will set to red automatically)
Database File Location screen
Directory for Database Files = 'c or d:\oracle\oradata'
Database Character Set screen
Character set to 'WESTERN_EUROPEAN.WE8ISO8859P1'
Summary screen
Click 'Install'
2. Modyfying Server Registry
Click :- Start – Run – Regedit – OK
Click :- HKEY_LOCAL_MACHINE
Click :- SOFTWARE
Click :- ORACLE
Highlight:- HOME0
Scroll down to - NLS_LANG
Double Click - NLS_LANG
Place mouse on highlighted 'value data'
Right Click – Select 'Copy' – Select – 'Cancel'
In the right-hand window highlight:- HOME1
Find - NLS_LANG
Double click - NLS_LANG
Right-click the highlighted data and select 'paste'
It should now read: AMERICAN_AMERICA.WE8ISO8859P1
Close regedit.
3. Backup Oracle Registry Key
Right-Click the 'Oracle' key in the registry
Select & Click – 'Export Registry File'
Create NEW folder 'Reg_Backup' in the Oracle folder
Filename = Oracle Server
Save and then close the Registry Editor
4. Run Services.msc & Stop the following services
OracleMTSRecoveryService
OracleOraHome90Agent
OracleOraHome90HTTPServer (may not be running but close if open)
Highlight the Service, Double Click and then select STOP. Change Startup type to Manual – Apply & OK
5. The only Services that should show a status of 'Started' should be
OracleOraHome90TNSListener
OracleServiceRED
6. TEST DATABASE CONNECTION
Open SQLPLUSW (start menu/Programs/Oracle - OraDb10g..../Application Development
USER NAME = system
PASSWORD = red$$
HOST STRING = red
Type the following commands at the SQL> prompt.
conn / as sysdba
drop public synonym XMLCONCAT;
drop function XMLCONCAT;
shutdown immediate
1. Apply Oracle server Patch Set 3 - Ver.9.2.0.4.0
Stop the following services
OracleOraHome90TNSListener
OracleServiceRED
2. Run setup.exe found in \Redthorn_Install\Database\Disk3\Patch Set 3\p3095277_9204_WINNT\9204_nt_release\Disk1. Use the following settings on each screen, pressing Next or Install to continue.
Welcome Screen
File Locations Screen
Available Products Screen
Select OUI 2.2.0.18.0
Summary Screen
End of Installation Screen
Click Exit
3. Run setup.exe found in \Redthorn_Install\Database\Disk3\Patch Set 3\p3095277_9204_WINNT\9204_nt_release\Disk1. Use the following settings on each screen, pressing Next or Install to continue.
Welcome Screen
About Oracle Universal Installer
The screen should display
Oracle Universal Installer
Version 2.2.0.18.0
Copyright @ 1999,2002 Oracle CORORATION All Rights Reserved
(Note: Screen display other than the above start again from 2)
Exit this screen to continue
Welcome Screen
File Locations Screen
Available Products Screen
Oracle 9iR2 Patch Set 9.2.0.4.0
Summary Screen
End of Installation Screen
Exit
Now Click Exit again & Close ALL Windows
4. Start the following Services
OracleOraHome90TNSListener
OracleServiceRED
5. Open \Oracle\Admin\Red\pfile\ and create a backup of the init.ora.######## file
6. Open the origonal INIT.ORA.######## in notepadand make the changes shown in blue in the following example
###########################################################
# THIS IS A SAMPLE OF THE REDTHORN MODIFIED INIT.ORA FILE #
# @11.1 AS REQUIRED TO INSTALL PATCH SET 3 #
###########################################################
Open SQLPLUSW (start menu/Programs/Oracle - OraDb10g..../Application Development
USER NAME = system
PASSWORD = red$$
HOST STRING = red
Type the following commands at the SQL> prompt.
alter user system identified by manager;
alter user sys identified by manager;
commit;
conn system/manager as sysdba
shutdown immediate;
create spfile from pfile='%DRIVE%:\oracle\admin\red\pfile\init.ora.########';
startup
shutdown immediate;
startup migrate
spool patch.log;
@%DRIVE%:\oracle\ora90\rdbms\admin\catpatch;
Patch Set 3 will now be applied to the system. . . This will take some time! (45 minutes or more)
On completion of 12.2 above, the system will return to the SQL> prompt. DOC> END CATPATCH.SQL */ should appear immediately above the SQL> prompt.
At the SQL> prompt type
8. Open the origonal INIT.ORA.######## in notepadand make the changes shown in red in the following example
###########################################################
# THIS IS A SAMPLE OF THE REDTHORN MODIFIED INIT.ORA FILE #
# @11.1 AS REQUIRED TO INSTALL PATCH SET 3 #
###########################################################
1. Open 'C:\orared\crtablesp.sql' in notepad (If Prompted - open with Notepad)
Edit the file drive letters and customise for the server's environment. If only two drives are available (c: and d: for example) put both Data (REDD_1.dbf / REDPLAYD.dbf) and Indexes (REDI_1.dbf / REDPLAYI.dbf) on d:\oradata If there are three drives available (c: d: and e: for example) you can put the Data on d:\oradata and the Indexes on e:\oradata. The aim is to separate the indexes and data tablespaces for better system performance, this can be achieved firstly by keeping them separate from the server's system drive (usually c:) AND on separate drives.
2. Copy PLL & DMP (supplied by Redthorn UK) to C:\orared
3. Open C:\orared\impred.par in notepad and edit the file and fromuser values to represent the location and filename of the dmp, and the oracle user the data is coming from. Here is an example of what this should look like:
4. Open C:\orared\impredpl.par in notepad and edit the file and fromuser values to represent the location and filename of the dmp, and the oracle user the data is coming from. Here is an example of what this should look like:
Depending where you decided to have the data and indexes (see section 1) you will need to create a folder named 'oradata'. On a single drive system you will only create ONE oradata folder at c:\oracle\oradatae and both data and indexes will reside in there. On a two drive system the oradata folder will sit on the next drive to c: (usually d:) and the data and indexes will reside in there. On a three drive system you will need to create an oradata folder for the data files and an oradata folder for the indexes, usually this would consist d:\oradata (here we put the data files) and e:\oradata (here we put the index files).
7. Creating Tablespaces and Users
Open SQLPLUSW (start menu/Programs/Oracle - OraDb10g..../Application Development
USER NAME = system
PASSWORD = red$$
HOST STRING = red
PLEASE double check the import log files post import for errors
2. Update redlive user
Open SQLPLUSW (start menu/Programs/Oracle - OraDb10g..../Application Development
USER NAME = redlive
PASSWORD = asd159
HOST STRING = red
Type the following commands at the SQL> prompt.
@c:\crusers\resetpwd ******
At – 'Enter Destination Index – Tablespace Name' type;
red_index
3. Update redplay user
Type the following commands at the SQL> prompt.
conn redplay/play
@c:\crusers\resetpwd ******
At – 'Enter Destination Index – Tablespace Name' type;
Playindx
4. Change system passwords
Type the following commands at the SQL> prompt.
conn system/manager
@c:\crusers\changep
5. ########################
Type the following commands at the SQL> prompt.
conn system/red$$
@c:\crusers\build_syn
When prompted for username, type
redlive
6. ############################
Type the following commands at the SQL> prompt.
conn redop/red
@c:\crusers\sdt
(Database now shows listing of table SFMAT. This is a test to show the user redop can view the tables. This is used by the customer when using Access or Crystal Reports to create their own reports. Last line of table SFMAT= MAT_LIFE / MAT_CERT or similar)
7. ############################
Type the following commands at the SQL> prompt.
conn system/red$$
@c:\crusers\cp
System will automatically close SQL prompt and return the user to the desktop
8. Backup live system
Double Click 'liveback.com'
8. Backup play system
Double Click 'playback.com'
Notes: The System should now export data whilst creating a current 'redplay.dmp' file. Opening 'redplay.log' will show a text copy of the export. Please check for errors. All lines in 'redplay.log' should start with ' Exporting Table'
If 'Questionable Statistics' appears anywhere, Re-check that ALL the occasion of NLS_LANG where changed in the Oracle Registry
Go to Start – Programs – Accessories – System Tools – Scheduled Tasks, select the following
Add Scheduled Task
Next
Browse
C:\oraback
Liveback.com
Open
Daily
Next
22.00
Next
Enter the Server Administrator Password
Note: If Server Administrator Password is ever changed, this Scheduled Task will require modification of its task properties to reflect the password change.
Click - 'Next'
Click - 'Finish'
Note:Task should now be visible in 'Scheduled Tasks' folder.
Play system backup
Go to Start – Programs – Accessories – System Tools – Scheduled Tasks, select the following
Add Scheduled Task
Next
Browse
C:\oraback
Playback.com
Open
Daily
Next
23.00
Next
Enter the Server Administrator Password
Note: If Server Administrator Password is ever changed, this Scheduled Task will require modification of its task properties to reflect the password change.
Click - 'Next'
Click - 'Finish'
Note:Task should now be visible in 'Scheduled Tasks' folder.
Please ask the system administrator to include c:\oraback and x:\redthorn in his nightly backup.
IMPORTANT: Please make the customer aware that it is the FULL responsibility of the system administrator to check nightly exports and scheduled backups are working correctly. It is not Redthorn's responsibility to check this or be responsible for any consequences.
3. Test 'Liveback'
Right Click - 'Liveback' in 'Scheduled Tasks'
Select - 'Run'
Note: System runs DOS window that shows the tables being exported.
4. Test 'Playback'
Right Click - 'Playback' in 'Scheduled Tasks'
Select - 'Run'
Note: System runs DOS window that shows the tables being exported.
5. Create Desktop Shortcut
Create a shortcut to the oraback folder on the desktop and rename it 'View Daily Oraback Folder'
IMPORTANT: Please make the customer aware they needs to check this folder daily to confirm that the backup has been created (*.DMP file). Also, the folders required to be backed up by user are :- 'oraback' & 'redthorn'
Take note of the Ethernet Local Connection IP address (Eg: 168.192.50.1) and close command prompt.
Share the Red_Inst folder (eg. C:\Red_Inst)
Right Click - Red_Inst
Click - Sharing
Select - Share This Folder
Click - Apply
Click - OK
Edit the tnsnames.ora file (orant)
Open %DRIVE%\Red_Inst\orant\net80\admin\tnsnames.ora in notepad
Change - HOST = SERVER IP
To - HOST = 168.192.50.1*
*(this is an example IP address, the actual ip address for the server should be entered here.
Close and save the file
Edit the tnsnames.ora file (orawin95)
Open %DRIVE%\Red_Inst\orawin95\net80\admin\tnsnames.ora in notepad
Change - HOST = SERVER IP
To - HOST = 168.192.50.1*
*(this is an example IP address, the actual ip address for the server should be entered here.
Close and save the file
2. Create Redthorn Directory
Create folder on the C:\ drive called Redthorn
Share the Red_Inst folder (eg. C:\Redthorn)
Right Click - Redthorn
Click - Sharing
Select - Share This Folder
Click - Apply
Click - OK
Copy C:\orared\pcssec.pll to C:\Redthorn
Place current update CD into Server CD ROM drive.
CD will attempt to Autoload
Cancel autorun
Copy %CDDRIVE%\program.rtm\version.red to C:\Redthorn\
Copy all .frm files from %CDDRIVE%\Support\FRM to C:\Redthorn\
Remove 'Read Only' attribute from ALL FRM Files.
1. Setting up the server as a workstation to run PCS
IMPORTANT: DO NOT USE THE WORKSTATION INSTALL ROUTINE AS THIS WILL REMOVE THE ORACLE DATABASE SERVER REGISTRY – USE THE SERVER SPECIFIC NOTES BELOW.
Copy the ORANT folder from the RED_INST folder held on the servers hard drive & paste it onto the servers C:
Map the R:\ drive to the Redthorn shared folder
Note: In the above file where the line references c:\redthorn – this is assuming the Redthorn folder is on the servers drive C: If it is not, replace “c” with the drive letter where the Redthorn folder resides.
2. Log onto PCS and go to 'Set Central Company Information' and see which version of Crystal Reports is the default in default settings (either 8.5 or 9)
3. Go to 'File -> Document Layouts -> Crystal Reports Runtime Software' and install the version found in the previous step.
1. Map the R:\ drive to the Redthorn share from the server
2. Map the T:\ drive to the Red_Inst share from the server
3. Double Click the correct operating install .bat file
Files will now be copied from the Server to the Client
Hit any key when completed
4. Log onto PCS and go to 'Set Central Company Information' and see which version of Crystal Reports is the default in default settings (either 8.5 or 9)
5. Go to 'File -> Document Layouts -> Crystal Reports Runtime Software' and install the version found in the previous step.