RC-50004: Fatal: Error occurred in ApplyDatabase:

When executing 'perl adcfgclone.pl dbTier'

PROBLEM:

RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed

RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase in log file

SOLUTİON:

set your ORACLE_HOME

chmod -R 777 /var/tmp/.oracle

AR-ARLPLB: -1732 ORA-01732: data manipulation operation not legal on this view

If you're use ebs 11.5 - 12.X;



Problem:


AR-ARLPLB: arlval returned FALSE.
AR-ARLPLB: Error in main.
AR-ARLPLB: -1732 ORA-01732: data manipulation operation not legal on this view



Solution:

Set optimizer_secure_view_merging to false.

This can be done by running the following in SQLPLUS :


SQL>alter system set optimizer_secure_view_merging=false;


RDBMS parameter optimizer_secure_view_merging = FALSE, which is a mandatory
init.ora parameter using Oracle applications was not correctly set.

Ref:Oracle Receivables Lockbox: Known Issues and Patches [ID 1358497.1]


Try and be happy:)

ORA-01403 No Data Found Error When Searching For Repair Orders

Problem:


ORA-01403 No Data Found Error When Searching For Repair Orders



Solution:


Apply Patch 14848578: 12.1 CONSOLIDATED PATCH FOR BUG FIXES BETWEEN DATES

APP-FND-01934: ORA-01403

Problem:

APP-FND-01934: ORA-01403 no data found in Package PO_HXC_INTERFACE_PVT Procedure CHECK_TIMECARD_EXISTS

Solution:

Apply 12533942 patch.

1)download this patch from Oracle support then unzip file.

2)Shutdown your Application System via running adstpall.sh

3)Enable maintenance mode

adadmin
change maintenance mode
enable maintenance mode


cd 12533942

adpatch

Then solved the problem:)

Give a chance to you:))

bash: /usr/bin/X11/xterm: No such file or directory

If you're get error while connecting  to unix server via xstart


Problem:

bash: /usr/bin/X11/xterm: No such file or directory xstart


change your command

/usr/bin/X11/xterm –ls –display $DISPLAY


remove '/usr/bin/X11' at this command



just below:


Solution:

xterm -ls -display $DISPLAY

ORA-12638

Problem:

ORA-12638: Credential retrieval failed

Solution:

vi $ORACLE_HOME/NETWORK/ADMIN/sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS) change it to

SQLNET.AUTHENTICATION_SERVICES= (NONE)

Xsetroot vnc problem

   After I installed Linux Red Hat 6 I tried to connect the server via vncserver.But I get
some error about 'xsetroot'.When I wanted to connect vnc,vnc start successfully but
there was an error in log file.I tried to solve this problem for two days;but I can't solve it.Then  I changed viewpoint.Sometimes we should change our viewpoint:))

Problem:


Thu Sep 27 13:34:57 2012
 vncext:      VNC extension running!
 vncext:      Listening for VNC connections on all interface(s), port 5923
 vncext:      created VNC server for screen 0
expected keysym, got XF86TouchpadOn: line 120 of inet
expected keysym, got XF86TouchpadOff: line 121 of inet




Solution:

#service iptables restart

This command can be disabled the firewall


Try and success:)))

ORA-00283

Problem:

If you try to recover database you startup database mount mode if not you get this error

ORA-00283

Solution:

shutdown immediate

startup mount

OC4J portal was 'none'

Problem:

We have Oracle Application Server 10g,we shut down the application and rebooted the server which
in application run.But then we can't have start opmn.We we run 'opmnctl startall' OC4J portal
was 'none'.It can't have been alive.

Solution:

ulimit -c unlimited

This command change all limits to unlimited.The problem caused by 'open files' parameter:)

ORA-12560:TNS:protocol adapter error(windows)

While you're logging sys / as sysdba you may get this error on windows


Problem:

ORA-12560:TNS:protocol adapter error

Solution:


C:\>set oracle_sid=necodb

C:\>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on 17:06:19 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

username : sys as sysdba
password:

connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning option

SQL>

If you use unix you follow link below:

http://doganay.wordpress.com/2012/04/03/tns-12555-tns-permission-denied/

ORA-19809: limit exceeded for recovery files

Problem:

Errors in file /home/oracle11g/diag/rdbms/necodb/trace/necodb_arc3_27348.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 790890496 bytes disk space from 4070572032 limit
ARC3: Error 19809 Creating archive log file to '/home/oracle11g/flash_recovery_area/ANKDB/archivelog/2012_09_07/o1_mf_1_9_%u_.arc'

Solution:

increase DB_RECOVERY_FILE_DEST_SIZE(Database recovery files size limit )

alter system set parameter DB_RECOVERY_FILE_DEST_SIZE=integer;

You don't need to restart the instance,this parameter is dynamic:))

ORA-12162 TNS:net service name is incorrectly specified

Problem:

After you installed ORACLE database,if you want to connect database with sqlplus,you get a this error

********************************************************
*ORA-12162 TNS:net service name is incorrectly specified
********************************************************

Solution:

You have to add your database SID in your '.bash_profile' or if you use Solaris file is '.profile'

export ORACLE_SID=<SID>


Good luck:))

Message dictionary couldn't open the CLE application message file.Can't open file $CLE_TOP/mesg/US.msg for reading

Problem:

Message dictionary couldn't open the CLE application message file.Can't open file
$CLE_TOP/mesg/US.msg for reading

Solution:

Navigate to Applications Developer responsibility:
Run concurrent request: Generate Messages, with the following parameters:
Language: US
Application: CLE
Mode: DB_TO_RUNTIME

Then try
cd $CLE_TOP

cd mesg

ls

US.msg is came:))

The following error occurs during execution of apwdame1.sql

Problem:

When attempting to apply Oracle Internet Expenses Mini-pack 11i.OIE.K (4165000)
the following error occurs during execution of apwdame1.sql


Solution:

Apply Patch 4873179 to Application

Re-apply the OIE Patch 4165000

RC-20200: Fatal: Could not find Unzip

Problem:

0% completed RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.
Please make sure you have UnZip 5.X in your path and try again.

Solution:

Apply patch 9874305 on Application

Then;

Set your java and unzip in your .profile(bash_profile) file

ERROR [code=-1] compiling out of date JSP files

Problem:

ERROR [code=-1] compiling out of date JSP files


Solution:

1)cd $ADMIN_SCRIPTS_HOME

bash-4.2$ ./adautocfg.sh

2)cd /data_appl/apps/apps_st/appl/fnd/12.0.0/patch/115/bin

bash-4.2$ perl ojspCompile.pl --compile --quiet

Installing 8626084 10.1.3 Application Server patch(error: writing to file)

Problem:We installed ebs 12.1.1 on IBM AIX on POWER Systems (64-bit) version 6.1.Then started 
the 12.1.3 upgrade;when install 8626084 application server patch we get an error.
This error like below:

Our opmn.xml include 'data1/R12/ab/apps/XB9R1211/apps/tech_st/10.1.3'
But this isn't my ORACLE_HOME.There isn't like this home so upgrade installation
is failed.We created an SR,we gave all of logs.After 1 week one man from oracle
support advice a document.Documnet id is below,also error's screenshot and error logs.

The solution to this document( [ID 1086315.1]):

Solution:edit comps.xml file check all the failure ORACLE_HOME and replace real ORACLE_HOME,
then run adautocfg.sh.

Of course for all of them,firsly you set 10.1.3 env:)))

error blog include:

LPX-00202: could not open "/dbhome/data_appl/inst/apps/BRLPROD_burladb/ora/10.1.2/opmn/conf/opmn.xml" (error 200)

XML parse failed: error 202.

unzip command not found in AIX

I get this error when I want to extract unzip files

problem:unzip command not found

so you have to install aix unzip rpm

you can download this site:

http://www-03.ibm.com/systems/power/software/aix/linux/toolbox/alpha.html

After you downloaded rpm

su - root

change directory where rpm is  in there

solution:rpm -ivh unzip-5.51-1.aix5.1.ppc.rpm

Then you can unzip .zip files.

good luck:)))

RMAN-03009: failure of backup command on ORA_DISK_1 channel

Hi,

I was getting backup application's database,I got these errors in below.
Master problem is;

ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/test_db/sys/system09.dbf

We use E-Business Suite R12,so we have a lot of system dbf.

Problem:

channel ORA_DISK_1: starting piece 1 at 29-JUN-12


RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/29/2012 10:20:22

ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/test_db/sys/system09.dbf

continuing other job steps, job failed will not be re-run

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

channel ORA_DISK_1: starting piece 1 at 29-JUN-12

channel ORA_DISK_1: finished piece 1 at 29-JUN-12

piece handle=/u01/backup/NECOTEST_787227623_42.rman tag=TAG20120629T101617 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/29/2012 10:20:22
ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/test_db/sys/system09.dbf


Solution:

SQL> select file_name,tablespace_name,bytes/1024/1024/1024 from dba_data_files where tablespace_name='SYSTEM';

FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME                BYTES/1024/1024/1024
------------------------------ --------------------
/u01/test_db/sys/system09.dbf
SYSTEM                                   1.46484375

/u01/test_db/sys/system08.dbf
SYSTEM                                    1.7578125

/u01/test_db/sys/system07.dbf
SYSTEM                                   .732421875

Our system09.dbf is 1,46 GB.We will change this dbf size then return old size.

SQL> alter database datafile '/u01/test_db/sys/system09.dbf' resize 1000m


Then;


SQL> alter database datafile '/u01/test_db/sys/system09.dbf' resize 1464m

After this changes

We can take backup successfully...

Have a nice weekend:)))

Display Netbackup Admin Console on Solaris

Hi,

I installed Symantec Netbackup 7.5 on Solaris 10_SPARC(64 bit) server.This server is
master server.Then I wanted to open Admin console on vnc to configure client server

admin console path=/usr/openv/netbackup/bin/./jnbSA

But it didn't work,can't display anything.I searched internet and tried all of
method,but I didn't find any solution.

Then my friend that the admin of 'howto.gen.tr',suggest a program to open netbackup
admin konsole.This program name is XMANAGER.

XMANAGER uses ssh(port 22),also vnc uses ssh(port 22).XMANAGER connect directly;
but vnc opens a port.

Good luck:)))

FRM-92101: There was a failure in the Forms Server during stratup.

Problem:If you run the form you may get this error

FRM-92101: There was a failure in the Forms Server during stratup.

Solution:Download openmotif21-2.1.30-11.EL5.i386.rpm from

http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/

then

#rpm -ivh openmotif21-2.1.30-11.EL5.i386.rpm

Good luck:)))

You have encountered an unexpected error. Please contact the System Administrator for assistance.

Hi,


While you're logging in e-business suite erp web page(just;erpdb.doganay.com.tr)
You may get this error :

Error Page
----------------------------
You have encountered an unexpected error. Please contact the System Administrator for assistance.


Don't panic:)))


Apache,web server or application cache may caused this error.But before the searching these things from the metalink.I advice 'bounce the server':))


Solution:Stop the application and start the application

ERROR: NMO not setuid-root

When using Enterprise Manager, you might get the following error message:
If you get this error while using Enterprise Manager;

Problem:ERROR: NMO not setuid-root (Unix-only)

Solution:

$ su - root

$ cd $ORACLE_HOME/bin

$ chown root nmb nmhs nmo

$ chmod 6750 nmb nmhs nmo

Then restart the database:)

ORA-04031:unable to allocate 248 bytes of shared memory

Problem:ORA-04031:unable to allocate 248 bytes of shared memory

Solution:If we get this error,we have to open our parameter file init.ora.End then increase below parameters

**shared_pool_reserved_size

**shared_pool_size

**SGA 

After we increased these parameters shutdown your application,shutdown your database,startup your database,startup your application.

Note:If you don't have application just shutdown database then startup your database:))))

adstpall.sh:Exiting with status 1

Problem:For shut down your ERP application you have to run this below script

While shutting down your application you may get this error.


------------------------------------------------------------------------------------------------------
You are running adstpall.sh version 120.10.12010000.4


Enter the APPS username: apps

Enter the APPS password:

file:/u01/test_appl/inst/apps/doganay_erpdb/appl/admin/doganay_erpdb.xml<Line 2, Column 6>: XML-20109: (Fatal Error) PI with the name 'xml' can occur only in the beginning of the document.
The logfile for this session is located at /u01/test_appl/inst/apps/doganay_erpdb/logs/appl/admin/log/adstpall.log
Exception in thread "main" java.lang.NullPointerException
        at oracle.apps.ad.autoconfig.ServiceControl.parseServices(ServiceControl.java:487)
        at oracle.apps.ad.autoconfig.ServiceControl.<init>(ServiceControl.java:331)
        at oracle.apps.ad.autoconfig.ServiceControl.main(ServiceControl.java:976)

adstpall.sh:Exiting with status 1

adstpall.sh:  check the logfile /u01/test_appl/inst/apps/doganay_erpdb/logs/appl/admin/log/adstpall.log for more information



/u01/test_appl/inst/apps/doganay_erpdb/appl/admin/doganay_erpdb.xml

--------------------------------------------------------------------------------------------------------
Solution:You may have damaged your doganay_erpdb.xml file.You have to back your doganay_erpdb.xml backup.

If we recovery your doganay_erpdb.xml backup,application will shutdown smoothly:)))

Couldn't find "xauth" on your PATH

bash-3.2$ vncserver
vncserver: couldn't find "xauth" on your PATH.



Problem: couldn't find "xauth" on your PATH
------------------------------------------

PATH=$PATH:/usr/X11/bin:/usr/openwin/bin
   export PATH
------------------------------------------------
Solution:Save your .profile(solaris),.bash_profile(linux) above path.Then log out and log in

Then


bash-3.2$ vncserver

You established vncserver:)))

ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX

Problem:ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX


Solution:Extend your data file which have SYSAUX tablespace

Remote Desktop via Vncserver on Unix OS

If you want to set via remote desktop for Unix,you may use vncserver.But don't forget one thing while connecting.

1)Open a terminal,then open vncserver session like below.
[applprod@erpapps appl]$ vncserver

You will require a password to access your desktops.

Password:
Verify:
xauth:  creating new authority file /home/applprod/.Xauthority

New 'erpapps:3 (applprod)' desktop is erpapps:3

Creating default startup script /home/applprod/.vnc/xstartup
Starting applications specified in /home/applprod/.vnc/xstartup
Log file is /home/applprod/.vnc/erpapps:3.log

2)Vncserver create a file which name is .vnc under /home/applprod/

3)Go to /home/applprod/.vnc

[applprod@erpapps appl]$ cd /home/applprod/.vnc

4)You can see file list via ls command

[applprod@erpapps .vnc]$ ls

erpapps:3.log  erpapps:3.pid  passwd  xstartup

5)We open xtartup,because of using 'vi' command to change xstartup content

[applprod@erpapps .vnc]$ vi xstartup



---------------------------------------------------------------------------------------------
#!/bin/sh

# Uncomment the following two lines for normal desktop:
# unset SESSION_MANAGER
#exec /etc/X11/xinit/xinitrc

[ -x /etc/vnc/xstartup ] && exec /etc/vnc/xstartup
[ -r $HOME/.Xresources ] && xrdb $HOME/.Xresources
xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
twm &
---------------------------------------------------------------------------------------------

6)We should delete '#' from '#exec /etc/X11/xinit/xinitrc' line.Like below

---------------------------------------------------------------------------------------------
#!/bin/sh

# Uncomment the following two lines for normal desktop:
# unset SESSION_MANAGER
exec /etc/X11/xinit/xinitrc

[ -x /etc/vnc/xstartup ] && exec /etc/vnc/xstartup
[ -r $HOME/.Xresources ] && xrdb $HOME/.Xresources
xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
twm &
---------------------------------------------------------------------------------------------

7)Then you have to open another vncserver session

[applprod@erpapps appl]$ vncserver

8)connect this session via vncserver.

old:bold blue one


new:bold red one

                                                                  Good Luck:)

Discoverer Application not able to access

While you're connecting discoverer application you may get an error like this:

Problem:

A connection error.
- Failed to connect to database - Unable to connect to Oracle Applications
database: invalid username/password.

Solution:

You have to change dbc file from TEST01.dbc to test01.dbc in discoverer user at FND_SECURE location.

It must be lower character:)

oraInst.loc location

oraInst.loc file location is /etc on OEL(oracle enterprise linux) OS;
But on Solaris OS oraInst.loc file location is /var/opt/oracle/
Don't forget:))

Linux:/etc/oraInst.loc

Solaris:/var/opt/oracle/oraInst.loc

Patch Id is Null

Problem:Patch Id is Null

While I am upgrading from E-Business Suite 12.1.1 to 12.1.3,applying patches I get an error 'Patch id is null'.

Solution:The patch version causes this error.After apply the 6880880 patch,opatch version is upgraded and solve the problem 

Note:We can see all applied patches with 'opatch lsinventory'

bash-3.2$ opatch lsinventory
Oracle Interim Patch Installer version 11.1.0.9.6
Copyright (c) 2012, Oracle Corporation.  All rights reserved.




Oracle Home       : /u01/data_db/db
Central Inventory : /u01/data_db/db/admin/oui/ORSALIVE_erpdb/oraInventory
   from           : /u01/data_db/db/oraInst.loc
OPatch version    : 11.1.0.9.6
OUI version       : 11.1.0.7.0
Log file location : /u01/data_db/db/cfgtoollogs/opatch/opatch2012-05-10_15-41-33PM_1.log


Lsinventory Output file location : /u01/data_db/db/cfgtoollogs/opatch/lsinv/lsinventory2012-05-10_15-41-33PM.txt

Patch  8639653      : applied on Wed May 09 19:34:03 EEST 2012

Unique Patch ID:  11697961

   Created on 21 Aug 2009, 11:50:13 hrs US/Pacific

   Bugs fixed:

     8639653

The file just loaded does not appear to be executable

Sun Sparc T4-2 makinasına Solaris 10'kurmak için 'boot cdrom'komutunu çalıştırınca bu hata alınır.devalias'a bakıldığında cdrom'un olmadığı gözükür.

Çözüm: boot dvd

Oracle Exadata Veritabanı Makinası

Merhaba arkadaşlar;

Dün katıldığım exadata eğitimde edindiğim bilgileri sizinle paylaşmak istedim.

Exadata Database Machine Oracle CEO'sunun da dediği 'parallel everything'.Bu sistemin büyüsü
donanımda saklı gibi gözükse de büyü yazılım tarafında saklıdır.Aslında donanımın üstüne
gömülmüş yazılımdır bize exadatayı büyülü gösteren.

Exadatanın X2-2 ve X2-8 olmak üzere iki serisi var.X2-2 nin çeyrek,yarın ve tam olmak üzere
üç tipi vardır.Bizim aldığımız eğitimde daha çok çeyrek X2-2 nin üzerinden duruldu,çünkü
sadece onu görme imkanımız vardı:)))

 Database machine ilk başta 2008 Hp oracle database machine(V1) adı altında sadece data warehousing
için üretildi.Daha sonra 2009 da Sun oracle database machine(V2) piyasaya sürüldü.2010'da
Oracle'ın Sun'ı almasıyla birlikte şu anda bahsedeceğimiz Exadata halini almıştır.

 Peki bu kadar maliyetli bir şey şirkete neden alınır,mevcut serverler yeterli değil mi
diye düşünebilirsiniz.Exadata database machine bize ne gibi avantajlar sağlar,biraz da
bunlardan bahsedelim ve bu özellikleri anlatalım;

*Exadata makinasının 2 işletim sistemi desteği vardır(linux ve solaris)

*Storage tarafında oracle linux kuruludur

*Network trafiğini ortadan kaldırır(40Gb/s ethernet)

*HR,EDW,CRM,ERP,SC,DM hepsinin database'i için Exadata kullanılabilir

*SAP Oracle üzerinde artık certified oldu

*Exadata nın sırrı yüksek performansıdır

*Smart scan özelliği ile datayı akılı çeker:)

Bu özellik cell'ler uzerine gömülü yazımlar sağlanmaktadır.Kullanıcı database'den bir veri istediğinde database storage'dan kullanıcının istediği
veriyi ister ama veri filtrelenmemiş şekilde database'e aktarılır filtreleme işi database'e kalır,bu da database'in performansını etkilemektedir.
Smart scan ile bu filtreleme storage tarafında cell'ler üzerindeki gömülü yazılımlar sayesinde gerçekleşmektedir.Ve filtrelenmiş veri database'e
çıkar,database'de gelen veriyi aynen kullanıcıya aktarır.Bu şekilde performanstan hiçbir şekilde ödün verilmemiş olur.Tabii ki bazı şeylere smart
scan gerekmeyebilir.Mesela OLTP de smart scan yapmanın anlamı yoktur.Smart scan için aşağıdaki video'yu izleyebilirsiniz:)

http://www.youtube.com/watch?v=IdaU-7PsVJY

*Peki exadata çeyrekten daha küçük olabilir mi?

Kullanımı olmamakla beraber,Oracle tarafından tavsiye edilmez.Çünkü exadata database machine'in mantığı yüksek performans ve maksimum kullanışlılıktır.
Exadata makinamızın çeyrekten daha küçük olması demek performans ve kullanışlılıktan ödün vermek demektir.Bu da istenmeyen bir durumdur.

*Çeyrek bir exadata makinasında 3 cell ve 2 database node'u bulunmaktadır.Herbir cell'in 12 tane disk girişi mevcuttur.Herbir disk de 600Gb'dır
Yani toplam 3*12=36 tane disk,36*600Gb bir disk alanı vardır.

*300 commit/s bir hıza sahiptir

*Exadata makinasına node eklerken sistemi kapamamıza gerek yoktur

*Peki exadata upgrade edilmek istenirse(mesela çeyrekten yarıma geçilmek istenirse):

Bunun için Oracle sipariş verilir,onlar gelir parçaları ekler ve makinamız yarım olmuş olur

*Flash cache çok büyüktür,peki elektrikler kesildiğinde flash cache deki data ne olur?

Flash cache'in ayrıca battary'si vardır,elektrik gitse de flash cache'e bir şey olmaz

*Backup tape'e direkt alınabilir,backuplarda dbfs özelliği var

*Clone database,anlık snapshot özelliği mevcuttur

*İki network vardır;management network ve client network

*Tek bir yerden bütün cell lere aynı komutu gönderebiliriz

*1 TB tablespace 13 dakikada'da create edilebilir

*Gereksiz data flash cache e çıkarılmaz(örneğin;full table scan)

Biraz da bu ürünü kimlerin kullandığından,lisansından ve fiyatından bahsedelim.

Türkiyede toplam 63 data exadata makinası vardır.Çeyrek bir exadatanın kullanıcıya maliyeti(herbir disk'in ayrı ayrı lisanslandığını düşünün) her şeyiyle
beraber toplam 1000000$'dır.

Unutmadan herhangi bir exadata makinasını inceleme fırsatını bulduğunuzda,Cisco switch'ini görünce şaşırmayın:)))