Ans. You have to change the database character set to "AL32UTF8" manually. Or during installation of the database select advanced installation and change the character set to
"AL32UTF8" during the configuration of the database.
I am getting error like "proper tablespace is required" during installation time. What should I do to solve this?
Ans. You are using raw devices for database file storage where you need to create to table spaces manually. Create the tablespaces and its minimum storage type like this.
If there are some problems on starting up the components because port conflicts, how can I solve that?
Ans. Port conflicts with ephemeral ports arise when an Oracle Application Server process is configured to use a port in the ephemeral port range. The Oracle Application Server process tries to start up, but discovers that the port that it needs is already in use by a client process (the client received the ephemeral port assignment from the operating system). This client can be any process on the computer capable of communicating via TCP/IP. The Oracle Application Server process fails to start up when the port that it needs is unavailable.
Install Oracle Application Server using staticports.ini so that Oracle Application Server components do not use ports within the ephemeral range. In the staticports.ini file, use port numbers below 1024 or above 5000.
If you have already installed Oracle Application Server, you can reconfigure the components to use ports below 1024 or above 5000. See the Oracle Application Server Administrator's Guide to learn how to change the current ports used by Application Server processes.
I am unable to run Oracle Application Server On-Network as Well as Off-Network. How to solve this problem?
Ans. If you want to run Oracle Application Server on-network as well as off-network, you need to install a loopback adapter. On computers with static IP address, when you go off-network, your Ethernet adapter will be down (ipconfig shows cable disconnected) and ipconfig cannot resolve that IP.
When I am clicking on "setup.exe", the installer screen is not appearing. What should I do?
Ans. If you are installing Oracle Application Server on a computer that is already running Oracle Database 10g, then you have to start up the installer with the following option ->
G:\> setup.exe -J-Dsun.java2d.noddraw=true -Dsun.awt.nopixfmt=true
What is the location of my installation log files?
Ans. The installer writes the following log files ->
inventory_location\logs\installActionstimestamp.log
inventory_location\logs\oraInstalltimestamp.err
inventory_location\logs\oraInstalltimestamp.out
The default inventory_location is ->
C:\Program Files\Oracle\Inventory
After installation how to check the status of all processes?
Ans. When installation is complete, you can run the following commands to see the assigned ports and processes status ->
C:\> ORACLE_HOME/opmn/bin/opmnctl startall
C:\> ORACLE_HOME/opmn/bin/opmnctl status –l
How to check if a port is use or not?
Ans. To check if a port is being used, you can run the netstat command as follows ->
C:\> netstat -an | find "portnum"
During installation of Webcenter Suite in windows machine do I need to turn off the firewall?
Ans. Yes, you need to turn off the firewall during installation time. After installation you can turn it on again. Otherwise, Oracle Webcenter Installation will fail.
I am getting error like "Incompatible database" during Installation time. What should I do?
Ans. You can use only following databases with Webcenter Suite Oracle Content DB ->
a. Oracle Database version 10.1.0.5.0
b. Oracle Database version 10.2.0.2.0
No other databases like Oracle 9i, even Oracle Database Express Edition are supported by the installation.
If you are upgrading one existing database for webcenter suite installation doesn't forget to run these sql queries after upgradation.
catupgrd.sql (For Oracle Database version 10.2.0.2)
utlrp.sql (For Oracle Database version 10.2.0.2)
changePerm.sh (For Oracle Database version 10.2.0.2)
catpatch.sql (For Oracle Database version 10.1.0.5)
I am getting following error during webcenter suite installation.
Ans. You have not set the proper parameter value in the database for Oracle Content Database Installation. There is a file in installation root directory "cdb_alter_system.sql" which you need to execute before Webcenter Suite Content DB Installation. Otherwise you can manually set database values like the following ->
Use this SQL command to set the parameters ->
SQL> alter system set parameter_name=parameter_value scope=both;
Don't forget to restart the database after running the sql commands.
"AL32UTF8" during the configuration of the database.
I am getting error like "proper tablespace is required" during installation time. What should I do to solve this?
Ans. You are using raw devices for database file storage where you need to create to table spaces manually. Create the tablespaces and its minimum storage type like this.
Tablespace Name
|
Minimum Size
|
CONTENT_IFS_MAIN
|
60MB
|
CONTENT_IFS_LOB_N
|
270MB
|
CONTENT_IFS_LOB_I
|
270MB
|
CONTENT_IFS_LOB_M
|
10MB
|
CONTENT_IFS_CTX_I
|
10MB
|
CONTENT_IFS_CTX_K
|
15MB
|
CONTENT_IFS_CTX_X
|
130MB
|
WORKFLOW_IFS_MAIN
|
10MB
|
If there are some problems on starting up the components because port conflicts, how can I solve that?
Ans. Port conflicts with ephemeral ports arise when an Oracle Application Server process is configured to use a port in the ephemeral port range. The Oracle Application Server process tries to start up, but discovers that the port that it needs is already in use by a client process (the client received the ephemeral port assignment from the operating system). This client can be any process on the computer capable of communicating via TCP/IP. The Oracle Application Server process fails to start up when the port that it needs is unavailable.
Install Oracle Application Server using staticports.ini so that Oracle Application Server components do not use ports within the ephemeral range. In the staticports.ini file, use port numbers below 1024 or above 5000.
If you have already installed Oracle Application Server, you can reconfigure the components to use ports below 1024 or above 5000. See the Oracle Application Server Administrator's Guide to learn how to change the current ports used by Application Server processes.
I am unable to run Oracle Application Server On-Network as Well as Off-Network. How to solve this problem?
Ans. If you want to run Oracle Application Server on-network as well as off-network, you need to install a loopback adapter. On computers with static IP address, when you go off-network, your Ethernet adapter will be down (ipconfig shows cable disconnected) and ipconfig cannot resolve that IP.
When I am clicking on "setup.exe", the installer screen is not appearing. What should I do?
Ans. If you are installing Oracle Application Server on a computer that is already running Oracle Database 10g, then you have to start up the installer with the following option ->
G:\> setup.exe -J-Dsun.java2d.noddraw=true -Dsun.awt.nopixfmt=true
What is the location of my installation log files?
Ans. The installer writes the following log files ->
inventory_location\logs\installActionstimestamp.log
inventory_location\logs\oraInstalltimestamp.err
inventory_location\logs\oraInstalltimestamp.out
The default inventory_location is ->
C:\Program Files\Oracle\Inventory
After installation how to check the status of all processes?
Ans. When installation is complete, you can run the following commands to see the assigned ports and processes status ->
C:\> ORACLE_HOME/opmn/bin/opmnctl startall
C:\> ORACLE_HOME/opmn/bin/opmnctl status –l
How to check if a port is use or not?
Ans. To check if a port is being used, you can run the netstat command as follows ->
C:\> netstat -an | find "portnum"
During installation of Webcenter Suite in windows machine do I need to turn off the firewall?
Ans. Yes, you need to turn off the firewall during installation time. After installation you can turn it on again. Otherwise, Oracle Webcenter Installation will fail.
I am getting error like "Incompatible database" during Installation time. What should I do?
Ans. You can use only following databases with Webcenter Suite Oracle Content DB ->
a. Oracle Database version 10.1.0.5.0
b. Oracle Database version 10.2.0.2.0
No other databases like Oracle 9i, even Oracle Database Express Edition are supported by the installation.
If you are upgrading one existing database for webcenter suite installation doesn't forget to run these sql queries after upgradation.
catupgrd.sql (For Oracle Database version 10.2.0.2)
utlrp.sql (For Oracle Database version 10.2.0.2)
changePerm.sh (For Oracle Database version 10.2.0.2)
catpatch.sql (For Oracle Database version 10.1.0.5)
I am getting following error during webcenter suite installation.
Ans. You have not set the proper parameter value in the database for Oracle Content Database Installation. There is a file in installation root directory "cdb_alter_system.sql" which you need to execute before Webcenter Suite Content DB Installation. Otherwise you can manually set database values like the following ->
Parameter Name
|
Minimum Value
|
aq_tm_processes
|
1
|
db_recovery_file_dest_size
|
2147483648
|
dml_locks
|
200
|
job_queue_processes
|
10
|
max_commit_propagation_delay
|
0
This parameter was deprecated in Oracle Database 10g 10.2. If you are using a 10.2 database, you do not need to set this parameter. |
open_cursors
|
400
|
Processes
|
250
|
remote_login_passwordfile
|
EXCLUSIVE
|
session_max_open_files
|
50
|
Sessions
|
400
|
undo_management
|
AUTO
|
PLSQL_CODE_TYPE
|
INTERPRETED
|
db_create_file_dest
| Set this parameter to identify the default location for the database server to create the following files -> ■ Datafiles ■ Tempfiles ■ Redo log files ■ Control files ■ Block change tracking files The following example sets /u01/oradata as the default directory to use when creating Oracle-managed files -> DB_CREATE_FILE_DEST = '/u01/oradata' |
Use this SQL command to set the parameters ->
SQL> alter system set parameter_name=parameter_value scope=both;
Don't forget to restart the database after running the sql commands.
No comments :
Post a Comment