Search This Blog

Saturday, June 13, 2009

Change Oracle WebCache or Apache port to 80 in unix

As root
===========
cd $ORACLE_HOME/Apache/Apache/bin
chown root .apachectl
chmod 6750 .apachectl

As oracle
====================
Stop Oracle Web Cache using Application Server Control, or with the following
opmn command, as the oracle user (not root):

% opmnctl stopproc ias-component=WebCache

As root
============

# cd $ORACLE_HOME/webcache/bin
# webcache_setuser.sh setroot

As oracle
=============
Start Oracle Web Cache using Application Server Control, or with the following
opmn command, as the oracle user (not root):

% opmnctl startproc ias-component=WebCache

Change the port to 80 in the web cache administration site .

Tuesday, June 2, 2009

Report Server tips and docs ( Windows )

Setup Greek fonts when the report server run under windows env
=================================================================

How to Configure Reports to Generate PDF with Eastern European National Characters Doc ID: 223949.1

How to setup images
======================
How to Deploy Iconic Images via a JAR File in Forms 9i/10g? Doc ID: 232413.1

How to test a report
========================
http://localhost/reports/rwservlet?destype=cache&desformat=PDF&report=test.rdf

How to test a report with database connection
===============================================
http://localhost/reports/rwservlet?server=reportserverName&report=test_report.rdf&desformat=PDF&destype=cache&userid=username/password@develop_cy

Set Rac Database in NoARCHIVELOG

export ORACLE_SID=instance_name

sqlplus "/ as sysdba"

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1271564 bytes
Variable Size 314575092 bytes
Database Buffers 750780416 bytes
Redo Buffers 7114752 bytes
SQL> alter system set cluster_database=false scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> exit
SQL> startup mount
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1271564 bytes
Variable Size 314575092 bytes
Database Buffers 750780416 bytes
Redo Buffers 7114752 bytes
Database mounted.
SQL>alter database noarchivelog;


Database altered.
Set the Cluster_database parameter again to true.

SQL> alter system set cluster_database=true scope=spfile;
System altered.
SQL>shutdown immediateWe will again use srvctl to start the database and associated service

[/home/oracle>srvctl start database -d