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 03

"If something comes to life in others because of you, then you have made an approach to immortality."

-Norman Cousins (1912-1990)

Please answer to my following questions.
Thanks in advance.

Q: On my application server machine, I noticed that there is a process running as following:
portald: /u05/tarbkup $ps -ef|grep oracle
oracle 611 1 0 09:44:51 ? 0:02 /u01/oracle/product/10.1.2/OraHomeDev/bin/ocssd.bin
I tried to kill it. It comes back. How can I stop it?


A: This is only for Solaris. The following command is necessary to run in order to stop this process:
First you should login to root 
then run the following command.
/etc/init.d/init.cssd stop
example:
myportal-portald: /u05/tarbkup $ps -ef|grep oracle
oracle 611 1 0 09:44:51 ? 0:02 /u01/oracle/product/10.1.2/OraHomeDev/bin/ocssd.bin
oracle 647 644 0 09:48:59 syscon 0:00 -ksh
oracle 719 647 0 10:36:11 syscon 0:00 grep oracle
oracle 718 647 0 10:36:11 syscon 0:00 ps -ef
myportal-portald: /u05/tarbkup $su 
Password: 
# /etc/init.d/init.cssd stop
Shutting down CRS daemon.
Shutting down EVM daemon.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
# ps -ef|grep oracle
root 768 720 0 10:39:44 syscon 0:00 grep oracle
oracle 647 644 0 09:48:59 syscon 0:00 -ksh

 

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!