iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

 

 

 

 

 

 

 

 

 

 

Lesson 02

"Love is doing small things with great love."

-Mother Teresa (1910-1997)

Please answer to my following questions.
Thanks in advance.

Q: I have installed SunOS 5.10 with OracleAS 10g and when I want to apply patches for My OracleAS 10g, I get the message that OS did not pass the requirement?

A: Yes: That is because the patch for 10.1.0.3 does not check for SunOS 5.10.
The solution is: 
You need to modify oraparam.ini file to show Solaris 10:
To do that you should copy Disk1/install/oraparam.ini file to a temporary location for example:
/tmp/oraparam.ini.
Then modify the line with "Solaris=5.8,5.9" to "Solaris=5.8,5.9,5.10"
and invoke your universal installer.
runInstaller -paramFile /tmp/oraparam.ini

Good Luck!
------------------------------------------------------------------------
Q: I installed Management Agent on one of server that I want to monitor. But my Grid Control doesn't see it. Why?

A: Your agent probably was not configure to point to your Grid Control. 
Do the following: 
Go to your Grid Contral Server and check the portlist.ini file in $ORACLE_HOME/install.
Make a note of the "Oracle Management Service Upload Port" line.
Default is 4889.
>> Oracle Management Service Upload (non-SSL) Port = 4889
Open the $AGENT_HOME/sysman/config/emd.properties file.
Then change the following line in the file to point to your Grid control application server
>> REPOSITORY_URL=http://yourGridServer:4889/em/upload/
>> emdWalletSrcUrl=http://yourGridServer:4889/em/wallets/emd

Good Luck!
----------------------------------------------------------------------
Q: I have problem installing Oracle Application Server10g Web Cache. I get the message "rlim_fd_max must be 65536 or higher." But when I check the "ulimit -Hn" command, it is 65536.


A: Unfortunately, the Oracle Application Server 10g installation doesn't check the memory space allocation using the ulimit command. It goes to your /etc/system and if it is not there you get that message. In Solaris 10 the default value for rlim_fd_max is 65536. That is the reason you get the error message.
Solution:
Just open the /etc/system file and add any value equal or more than 65536.

Good Luck!
----------------------------------------------------------------------
Q: What is the default OID port number and user supperid?


A: The default Port number for OID is 13061 and OID admin user id is something like the following:
cn=orcladmin,cn=Users,dc=ferc,dc=gov
Your password is the same as ias_admin and you can change it once you get in the "oidadmin" utility.
login to OIDadmin with cn=orcladmin password ias_admin

Good Luck!
---------------------------------------------------------------------
Q: What are the default port number when I install my Application Server 10g?


A: Check the $ORACLE_HOME/install/portlist.ini file in your server.
You should have something like this for your infrastracture installation:
[Ports]
Oracle HTTP Server port = 7777
Oracle HTTP Server Listen port = 7777
Oracle HTTP Server SSL port = 4443
Oracle HTTP Server Listen (SSL) port = 4443
Oracle HTTP Server Diagnostic port = 7200
Oracle Notification Server Request port = 6003
Oracle Notification Server Local port = 6101
Oracle Notification Server Remote port = 6200
ASG port = 7890
Log Loader port = 44000
Java Object Cache port = 7000
DCM Discovery port = 7101
Oracle Management Agent Port = 1157
Application Server Control RMI port = 1850
Application Server Control port = 1156
Oracle Internet Directory port = 13061
Oracle Internet Directory (SSL) port = 13131
Oracle Certificate Authority SSL Server Authentication port = 6600
Oracle Certificate Authority SSL Mutual Authentication port = 6601
Enterprise Manager Console HTTP Port (portald) = 5500
Enterprise Manager Agent Port (portald) = 1830

For the midletier installtion for your application server you should have the following default port.
[Ports]
Oracle HTTP Server port = 7777
Oracle HTTP Server Listen port = 7778
Oracle HTTP Server SSL port = 8250
Oracle HTTP Server Listen (SSL) port = 4444
Oracle HTTP Server Diagnostic port = 7200
Oracle Notification Server Request port = 6003
Oracle Notification Server Local port = 6101
Oracle Notification Server Remote port = 6200
ASG port = 7890
Log Loader port = 44000
Java Object Cache port = 7000
DCM Discovery port = 7101
Oracle Net Listener = 1521
Oracle Management Agent Port = 1157
Application Server Control RMI port = 1850
Application Server Control port = 1156
Web Cache HTTP Listen port = 7777
Web Cache HTTP Listen (SSL) port = 8250
Web Cache Administration port = 9400
Web Cache Invalidation port = 9401
Web Cache Statistics port = 9402
Reports Services bridge port = 14011
Reports Services discoveryService port = 14021
Discoverer Preference Port = 16001
Reports Services SQL*Net port = 1950

Good Luck!
------------------------------------------------------------------
Q: After I installed my Grid Control, I rebooted my server. Now I don't know how can I start my Oracle Management Service component?

A: Do the following:
Go to the $ORACLE_HOME/opmn/bin directory.
start all the application server components.
./opmnctl startall
*wait about 2 minutes to have everything get insync
cd ../../bin
./emctl status oms
*if not running - ./emctl start oms
*wait about 2 minutes to have everything get insync
Now try these urls:
http://oradev1.senate.gov:7777/em -- will use web cache.
http://oradev1.senate.gov:4888/em 
http://oradev1.senate.gov:4889/em -- directly to database.
http://oradev1.senate.gov:4890/em
To stop them:
./emctl stop oms
*wait about 2 minutes for everything to completely come down - even when you get comm
and prompt back things can take a moment to finish
cd ../opmn/bin
./opmnctl stopall
*wait about 2 minutes to ensure all is stopped
./opmnctl status
*should show everything down or not running

Good Luck!
-------------------------------------------------------------------
Q: Why I can not access to my J2EE application server control url (http://myserver:1156)?

A: You should make sure that you have alread started you iasconsole.
>> # emctl start iasconsole

Good Luck!
-------------------------------------------------------------------
Q: I get the message that my database can not allocate a new log; and my checkpoint not completed. Why? Oracle datdabase is hung.

A: When first checkpoint is happening which is in process of writing all the dirty buffers to the db files and if the activity is more which can cause the redologs to fill in faster and second checkpoint is issued, this time we log a message in the alert.log and the second checkpoint is processed which eventually does the same thing.
Very frequent such messages need redolog and checkpoint process tuning; the way to resolve incomplete checkpoints is through tuning checkpoints and logs: 
1. Give the checkpoint process more time to cycle through the logs 
- add more redo log groups 
- increase the size of the redo logs 
2. Reduce the frequency of checkpoints 
- increase LOG_CHECKPOINT_INTERVAL 
- increase size of online redo logs 
3. Improve the efficiency of checkpoints enabling the CKPT process with CHECKPOINT_PROCESS=TRUE 
4. Set LOG_CHECKPOINT_TIMEOUT = 0. This disables the checkpointing based on time interval. 

Good Luck!