Problem:
While installing 11gR2 64-bit version on Oracle Linux 5.7 64-bit, the installer states that certain RPMs (libaio-devel-0.3.106 and unixODBC-devel-2.2.11) are missing. After installing the missing RPMs using the ‘rpm -Uvh’ command, the installer still does not detect the newly applied RPMs.
Solution:
Exit the 11gR2 installer, apply the RPMs and then rerun the installer.
Problem: While installing Oracle 9.2.0.4 for Linux, the following error appears in RunInstaller:
Error: You do not have sufficient privileges to write to the specified path. In component Database Configuration Assistant 9.2.0.1.0. Installation cannot continue for this component.
Solution: Export ORACLE_BASE:
export ORACLE_BASE=/u01/app/oracle
Exporting ORACLE_BASE resolved the issue.
Subject: Linux 9.2.0.4 Installation – Error: You do not have sufficient privileges to write to the specified path in Database Configuration Assistant Component (Doc ID: 267171.1)
Problem:
When rerunning adcfgclone.pl, the following error occurs:
ERROR: The version of the OUI found in /u0/oracle/testora/iAS/appsoui (2.1.0.17.0) is too low. Please make sure that you have applied the latest OUI patch required by Rapid Clone.
Restart adclone.pl after performing required corrections.
ERROR: Failed to execute adclone.pl
Solution:
Apply patch 5035661:
A. Applying the patch on the iAS $ORACLE_HOME:
———————————————-
1.Unzip the patch into the <iAS ORACLE_HOME> directory:
unzip -od <iAS ORACLE_HOME> p5035661_11i_<PLATFORM>.zip
ie: unzip -od /u01/oracle/prodora/iAS p5035661_11i_LINUX.zip
2.Source the Apps environment file :
On Unix/Linux, execute <APPL_TOP>/APPS<SID>_<hostname>.env
On Windows, execute <APPL_TOP>Envshell.cmd.
If the environment file is not available, please make sure the environment variable ‘APPL_TOP’ is set.
3.Change directory to the <iAS ORACLE_HOME>/appsoui/setup
4.Execute the perl script OUIsetup.pl:
perl OUIsetup.pl
NOTE:
In the case of a Multi-Node instance, the above process should be repeated on the <iAS ORACLE_HOME> of each Node.
unzip -od /u0/oracle/testora/iAS/ /u0/patches/p5035661_11i_LINUX.zip
. /u0/oracle/testappl/APPSTEST_ebusinesstest.env
cd /u0/oracle/testora/iAS/appsoui/setup/
perl OUIsetup.pl
Installing Oracle Database 10g Release 2 (10.2) for Linux x86
1. Download the 10201_database_linux32.zip file from the Oracle web site
22d23ab01a8013500313ff92f65d0fe5 10201_database_linux32.zip 668734007KB
2. Unzip the zip file in an appropriate directory.
3. Open the welcome.html file from the database directory.
4. Click the Documentation tab, then click on the Quick Installation Guide HTML link. Follow the steps to begin installation
———-
1. Log on as root user and execute the commands:
# xhost +
# grep MemTotal /proc/meminfo
# grep SwapTotal /proc/meminfo
# free
# df -k /tmp
# df -k
# grep “model name” /proc/cpuinfo
2. Ensure that the following packages (or later versions) are installed for Red Hat Enterprise Linux 4.0:
* make-3.79.1 [make-3.80-6.EL4 found]
* gcc-3.2.3-34 [gcc-3.4.6-3.1 found]
* glibc-2.3.2-95.20 [glibc-2.3.4-2.25 found]
* compat-db-4.0.14-5 [compat-db-4.1.25-9 found]
* compat-gcc-7.3-2.96.128 [not found]
* compat-gcc-c++-7.3-2.96.128 [not found]
* compat-libstdc++-7.3-2.96.128 [not found]
* compat-libstdc++-devel-7.3-2.96.128 [not found]
* openmotif21-2.1.30-8 [not found]
* setarch-1.3-1 [setarch-1.6-1 found]
To update these packages, navigate to Add or Remove Packages and check Legacy Software Development. Then click Update.
3. Issue more commands:
cat /etc/issue
uname -r
4. Set up Oracle user and groups
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# id oracle
# /usr/sbin/useradd -g oinstall -G dba oracle
or
# /usr/sbin/usermod -g oinstall -G dba oracle
# id nobody
5. Update kernel parameters. Edit /etc/sysctl.conf and add the following parameters:
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
rmem_default = 262144
rmem_max = 262144
wmem_default = 262144
wmem_max = 262144
6. Prerequisite Check Errors
Error Encountered:
—————–
Checking operating system package requirements …
Checking for make-3.79; found make-1:3.80-6.EL4. Passed
Checking for binutils-2.14; found binutils-2.15.92.0.2-21. Passed
Checking for gcc-3.2; found gcc-3.4.6-3.1. Passed
Checking for libaio-0.3.96; found Not found. Failed <<<<
Check complete. The overall result of this check is: Failed <<<<
Problem: Some packages required for the Oracle Database 10g to function properly are missing (see above).
Solution:
——–
Install libaio-0.3.105-2.i386.rpm from CD 3
Error Encountered:
—————–
Checking kernel parameters
Checking for semmsl=250; found semmsl=250. Passed
Checking for semmns=32000; found semmns=32000. Passed
Checking for semopm=100; found semopm=100. Passed
Checking for semmni=128; found semmni=128. Passed
Checking for shmmax=536870912; found shmmax=2147483648. Passed
Checking for shmmni=4096; found shmmni=4096. Passed
Checking for shmall=2097152; found shmall=2097152. Passed
Checking for file-max=65536; found file-max=65536. Passed
Checking for VERSION=2.6.9; found VERSION=2.6.9-42.0.0.0.1.EL. Passed
Checking for ip_local_port_range=1024 – 65000; found ip_local_port_range=1024 – 65000. Passed
Checking for rmem_default=262144; found rmem_default=110592. Failed <<<<
Checking for rmem_max=262144; found rmem_max=131071. Failed <<<<
Checking for wmem_default=262144; found wmem_default=110592. Failed <<<<
Checking for wmem_max=262144; found wmem_max=131071. Failed <<<<
Check complete. The overall result of this check is: Failed <<<<
Problem: The kernel parameters do not meet the minimum requirements (see above).
Recommendation: Perform operating system specific instructions to update the kernel parameters.
Solution:
——–
/etc/sysctl.conf should read (last four parameters different):
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
Error Encountered:
—————–
Checking available swap space requirements …
Expected result: 2274MB
Actual Result: 1983MB
Check complete. The overall result of this check is: Failed <<<<
Problem: The system does not have the required swap space.
Recommendation: Make more swap space available to perform the install.
Solution:
——–
Create a new swap partition.
fdisk /dev/hdb
Delete old partition, create a new /dev/hdb1 and /dev/hdb2, with /dev/hdb2 at least 2275MB
Edit /etc/fstab and add new swap device
mount -a
swapon -a
Set environment variables for ORACLE_BASE, ORACLE_HOME and SID before starting dbca
SID should be in lowercase e.g. orcl
Set Global Database Identifier same as SID i.e. orcl
After installing, run lab_02_05.sh script to create listener. Or create it manually.
Configure a TNS Listener using netca
Configure orcl entry in tnsnames.ora using netca >
Start dbconsole using emctl start dbconsole: gave error about
Timezone mismatch: The agentTZRegion value (GMT) in
/u1/app/oracle/product/10.2.0/db_1/enterprise.support.com_orcl/sysman/config/emd.properties
does not match the current environment TZ setting().
The dbconsole cannot run with this mismatch.
If GMT is the correct timezone, set your timezone environment variable to GMT and repeat the ’emctl start dbconsole’ operation.
If GMT is not the correct timezone, make sure that the timezone in your environment is correct, and then run the following command in your local Oracle Home: ’emctl resetTZ agent’
The output of this command will include detailed instructions to follow, to correct the mismatch.
[oracle@enterprise admin]$ emctl resetTZ agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Updating /u1/app/oracle/product/10.2.0/db_1/enterprise.support.com_orcl/sysman/config/emd.properties…
Time zone set to America/Anguilla.
To complete this process, you must either:
connect to the database served by this DBConsole as user ‘sysman’, and execute:
SQL> exec mgmt_target.set_agent_tzrgn(‘enterprise.support.com:3938′,’America/Anguilla’)
— or —
connect to the database served by this DBConsole as user ‘sys’, and execute:
SQL> alter session set current_schema = SYSMAN;
SQL> exec mgmt_target.set_agent_tzrgn(‘enterprise.support.com:3938′,’America/Anguilla’)
sqlplus sys/oracle
alter session set current_schema = SYSMAN;
exec mgmt_target.set_agent_tzrgn(‘enterprise.support.com:3938′,’America/Anguilla’);
Error Encountered:
—————–
Unable to connect using service (orcl) as in sqlplus system/oracle@orcl
Solution:
——–
Added the following lines to the listener.ora file:
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u1/app/oracle/product/10.2.0/db_1/)
(SID_NAME = orcl)
)
The listener.ora file now reads:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u1/app/oracle/product/10.2.0/db_1/)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u1/app/oracle/product/10.2.0/db_1/)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = enterprise.support.com)(PORT = 1521))
)
)
This documentation shows the steps covered in installing Oracle Application Express.
Refer to: http://www.oracle.com/technology/products/database/application_express/index.html
10gR1 Installation
Step 1: Install Oracle Database 10g on Windows machine using the Oracle Database 10g Release 1 (10.1.0.2) for Microsoft Windows (32-bit) CD.
Step 2: Install HTML DB from Oracle Database 10g Companion CD.
Step 3: Point browser to http://oracleserver.support.com:7777/pls/htmldb
10gR2 Installation
Step 1: Install Oracle Database 10g on Windows machine using the Oracle Database 10g Release 1 (10.1.0.2) for Microsoft Windows (32-bit) CD.
Issue encountered where it was not able to write to directory. It was defaulting to D:oracleoradata for the data files. This is the CD-ROM drive, so I had to do Advanced installation and specify E:oracleoradata.
Step 2: Install HTML DB from Oracle Database 10g Companion CD.
Step 3: Point browser to http://oracleserver.support.com:7777/pls/htmldb
Step 1: Log on to the appslinux server either at the console or via VNC and load the Terminal Command Line.
Step 2: To determine products installed, navigate to /u5/oracle/VIS12/db/tech_st/10.2.0/ and source the environment
(. ./VIS12_appslinux.env).
Step 3: Next, navigate to /u5/oracle/VIS12/db/tech_st/10.2.0/oui/bin and run runInstaller (./runInstaller)
Step 4: Download and install the apex_3.0.zip file from Oracle.com onto any directory that applmgr owns (e.g. /u0).
Step 5: Unzip apex_3.0.zip into the /u0 directory.
[applmgr@appslinux 9.2.0]$ cd /u0/ [applmgr@appslinux u0]$ unzip apex_3.0.zip
Step 6: The VIS12 instance shall be used. Navigate to the VIS12 10.2.0 Oracle Home and source the environment.
[applmgr@appslinux u0]$ cd /u5/oracle/VIS12/db/tech_st /10.2.0/ [applmgr@appslinux 10.2.0]$ . ./VIS12_appslinux.env [applmgr@appslinux apex]$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jul 10 18:29:00 2007 Copyright (c) 1982, 2005, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> select tablespace_name from dba_tablespaces order by 1; TABLESPACE_NAME ------------------------------ APPS_CALCLIP APPS_OMO APPS_TS_ARCHIVE APPS_TS_DISCO APPS_TS_DISCO_OLAP APPS_TS_INTERFACE APPS_TS_MEDIA APPS_TS_NOLOGGING APPS_TS_QUEUES APPS_TS_SEED APPS_TS_SUMMARY APPS_TS_TOOLS APPS_TS_TX_DATA APPS_TS_TX_IDX APPS_UNDOTS1 B2B_DT B2B_IDX B2B_LOB B2B_RT BAM CTXSYS CWMLITE DCM DISCO_PTM5_CACHE DISCO_PTM5_META DSGATEWAY_TAB GEOR_TBS HTMLDB IAS_META MTR NOETIX NON_APPS_TS_DATA OCATS ODM_DATA OLTS_ATTRSTORE OLTS_BATTRSTORE OLTS_CT_STORE OLTS_DEFAULT OLTS_SVRMGSTORE OPMOR ORABPEL OWAPUB PORTAL PORTAL_DOC SYNCSERVER SYSAUX SYSTEM TEMP1 TEMP2 XDB 55 rows selected. SQL>
VIS4 Installation
Step 7: Log on to the appslinux server either at the console or via VNC and load the Terminal Command Line.
Step 8: Download and install the apex_3.0.zip file from Metalink onto any directory that applmgr owns (e.g. /u0).
Step 9: Unzip apex_3.0.zip into the /u3 directory.
[applmgr@appslinux 9.2.0]$ cd /u0/ [applmgr@appslinux u3]$ unzip apex_3.0.zip
Step 10: The VIS4 instance shall be used. Navigate to the VIS4 9.2.0 Oracle Home and source the environment.
[applmgr@appslinux u3]$ cd /u3/oracle/vis4db/9.2.0/ [applmgr@appslinux 9.2.0]$ . ./VIS4_appslinux.env
Step 11: Change directory to the apex working directory.
[applmgr@appslinux u3]$ cd /u0/apex [applmgr@appslinux apex]$ ls apex_epg_config11.sql core apex_epg_config.sql coreins.sql apexins.sql doc apexvalidate.sql images apxconf.sql load_trans.sql apxremov.sql owa apxxepwd.sql utilities builder welcome.html
Step 12: Log on to sqlplus and check if the required tablespaces exist:
[applmgr@appslinux apex]$ sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.5.0 - Production on Wed Jun 27 10:51:04 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Pro duction With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.5.0 - Production SQL> select tablespace_name from dba_tablespaces order by 1; TABLESPACE_NAME ------------------------------ APPS_TS_ARCHIVE APPS_TS_MEDIA APPS_TS_NOLOGGING APPS_TS_QUEUES APPS_TS_SEED APPS_TS_SUMMARY APPS_TS_TX_DATA APPS_TS_TX_IDX APPS_TS_TX_INTERFACE APPS_UNDOTS1 CTXSYS TABLESPACE_NAME ------------------------------ DATA ODM OLAP OWAPUB PORTAL SYNCSERVER SYSTEM TEMP 19 rows selected.
Step 13: The Temp tablespace exists, but there is no SYSAUX. This tablespace shall be created for use with APEX.
SQL> create tablespace sysaux datafile '/u3/oracle/vis4data/sysaux.dbf' size 32M autoextend on maxsize unlimited permanent online extent management local; Tablespace created.
Step 14: Run the command:
SQL> @ apexins oracle sysaux sysaux temp /i/
Step 15: Run the command:
SQL> @apex_epg_config11 /u0
Step 16: Run the command:
SQL> alter user anonymous account unlock; User altered.
Step 17: Run the command:
SQL> select dbms_xdb.gethttpport from dual; GETHTTPPORT ----------- 0
Step 18: Run the command:
SQL> exec dbms_xdb.sethttpport(8080);
Step 19: Run the command:
[applmgr@appslinux ~]$ cd /u5/oracle/VIS12/apps/apps_st/ appl/ [applmgr@appslinux appl]$ . ./APPSVIS12_appslinux.env [applmgr@appslinux appl]$ cp -rf /u0/apex/images/ /u5/oracle/VIS12/apps/tech_st/10.1.2/Apache/Apache/
To source 9.2.0 RDMBS environment:
cd /u5/oracle/VIS12/db/tech_st/10.2.0/ . ./VIS12_appslinux.env [applmgr@appslinux appl]$ . ./APPSVIS12_appslinux.env [applmgr@appslinux appl]$ echo $ORACLE_HOME /u5/oracle/VIS12/apps/tech_st/10.1.2 (INCORRECT HTTPD HOME)
SQL to remove schemas after a failed new installation
drop user flows_030000 cascade; drop user flows_files cascade;
@apxremov.sql drop user FLOWS_010500 cascade; drop user FLOWS_020000 cascade; select username from dba_users order by 1; select owner, object_name, object_type, status from dba_objects where status = ‘INVALID’;
@apexins oracle sysaux sysaux temp1 /i/
THE BELOW IS CORRECT:
/u5/oracle/VIS12/inst/apps/VIS12_appslinux/ora/10.1.3
Location of updated dads.conf: /u5/oracle/VIS12/apps/tech_st/10.1.2/Apache/modplsql/conf
Log file:
/u5/oracle/VIS12/inst/apps/VIS12_appslinux/logs/ora/10.1.3/Apache/
To stop and start HTTP server:
/u5/oracle/VIS12/inst/apps/VIS12_appslinux/admin/scripts
This documentation covers locating the latest version of ADI on Metalink, downloading it, installing it on the client machine and configuring it to access an Oracle Applications instance.
Step 1: Log on to Oracle Metalink using your logon information (email address and password).
Step 2: Search for and read “Application Desktop Integrator (ADI) – FAQ” (Doc ID: Note:106667.1) to obtain instructions to download the latest version of ADI.
(Adapted from the FAQ):
QUESTION: Where can I download ADI from?
Download ADI from Metalink
Log on to http://metalink.oracle.com Click the Patches & Updates tab. On the Patches & Updates page, click Advanced Search. Enter: Product or Product Family: Click the Torchlight icon to search for Applications Desktop Integrator (adi). Release: ADI 7.2 Platform or Language: Microsoft Windows (32-bit) Client Patch Type: Any Press Go and the 7.2 base release will be available for download.
Step 3: The results of the search are returned at the bottom of the page.
Click the link ‘3966101’ to locate the patchset.
Step 4: You may be required to enter a username and password to access the file. Enter the email address and password that you used to log onto Metalink.
Step 5: Details about the patchset are displayed on screen.
Click Download to begin downloading the file. Note that the download size is 71MB.
Step 6: Click Save in the File Download dialog box, and then choose a location to save the file.
Step 7: After downloading, execute the patchset by double-clicking on it.
Step 8: Enter a location to unzip the files to, and then click Unzip.
Step 9: Ensure that all files were unzipped correctly (you should see ‘5179 file(s) unzipped successfully’), and then click Ok.
Then click Close to close the WinZip Self-Extractor program.
Step 10: In the folder that ADI was unzipped to, read the README.TXT file. It points the user to the ADI Installation Guide (ADI.PDF), which should be read before proceeding.
Step 11: After reading the installation guide, double-click Setupadi.exe to begin installation.
Caution: Remove headphones while installing this product since it uses a lot of extremely annoying sound effects.
Step 12: The Oracle ADI Installer loads.
Click Oracle Applications Desktop Integrator for Excel 2000/XP/2003.
Step 13: Click Yes to begin installation.
Step 14: The Oracle Installer Settings form is displayed. In the Company Name field, enter the name of the company. Then click Ok.
Step 15: The Software Asset Manager appears.
Install all of the products listed under Available Products. The products can be installed individually (one at a time), or all products can be selected and installed.
Note: The ADI Online Help will require you to choose a language to install.
Step 16: After installing the products, click Exit to exit the installer. You will be required to reboot the machine after exiting the installer.
Step 17: After the computer restarts, load Applications Desktop Integrator by clicking on the Start button, All Programs, Oracle ADI, and finally Applications Desktop Integrator.
Note: Let the client log on to the machine so that you can configure ADI under the user’s id. This is necessary since signon details are not shared between users.
Step 18: When the application is first loaded, a message appears informing the user to select an Applications database.
Step 19: After reading the message by the Office Assistant, click on the Signon button.
Step 20: The Signon form appears. Since there are no predefined databases, click Define Databases to define a new Applications database.
Step 21: The Select Database form appears. Click Add to add a database.
Step 22: Fill out the fields in the Add Database Details form, and then click OK.
Copy sqlnet.ora and tnsnames.ora from the “806 NET80” directory in the Project Folder to c:orantnet80admin and c:orantnetworkadmin. Note that these files contain configuration information for the production instance only.
In addition, each instance has a unique server ID. To obtain the server ID for the production instance, navigate to the Project Folder, and then open the file “Server ID.txt”. Copy the hexadecimal string under MFGP and paste it into the Server ID field in the Add Database Details form.
Step 23: After setting up the database details, save the information and log on to ADI using an Oracle Applications username:
After logging on, perform the following:
The job is submitted and completes within a few minutes. It will automatically open in Excel on completion.
Error Message: “No Listener”
Solution: Either instance on server does not exist or entry in TNSNAMES.ORA is incorrect. If TNS entry in the local TNSNAMES.ORA file is correct, then listener or database is not started on the server.
Error Message: “ORA-12571: TNS Packet Writer Failure”
Solution: Cannot send packets to the server. A firewall is blocking packets on the client machine.
Error Message: “ORA-12154: TNS: could not resolve service name”
Solution: Ensure that the service name is in c:orantnet80admintnsnames.ora
Check that c:orantnet80adminsqlnet.ora has names.default_domain and name.default_zone commented off.
Check %WINDIR%system32driversetchosts file has hostname and ip address.
Error Message: “An error occurred while attempting to establish an Applications File Server connection. There may be a network configuration problem, or the TNS listener may not be running. Nodename : ORACLESRV”
Solution: Incorrect FNDFS entry is in the TNSNAMES.ORA file. Recopy sqlnet.ora and tnsnames.ora from server onto client machine.
Subject: Tns Packet Writer Failure When Trying To Connect To ADI Ora-12571 (Doc ID: Note:264952.1)
Subject: Unable To Start ADI ORA-12571:TNS:Packet Writer Failure (Doc ID: Note:351088.1)
Subject: Troubleshooting the “Error Occurred While Attempting to Establish an Applications File Server Connection” (Doc ID: Note:117012.1)
[amazon asin=0071779728&template=iframe image&chan=default] [amazon asin=1849680620&template=iframe image&chan=default] [amazon asin=0071622292&template=iframe image&chan=default]
Recent Comments