11.5.10 install

I'm trying to install EBS 11.5.10 on Suse Linux.
First I created a staging area on my external hard disk. I found out, a few files (*.zip) could not be copied...Disk7 from the Database1 dvd and disk6 from the first APPL_TOP dvd.
All the other files went well, so I decided to download the bad disk from the Oracle E-delivery site. After downloaded and burned the cd's..the copy to my staging area went fine.
So, today I can begin the install. It's running right now, unzipping files from the RDBMS disk.
To be continued....

Recyclebin 10g

I have looked into the recyclebin feature in 10g.
I have tested it by dropping a table form the user scott, comiited the drop and recovered the table.


SQL> conn scott/tiger
Connected.

SQL> descr recyclebin
Name Null? Type
----------------------------------------- -------- ----------------------------
OBJECT_NAME NOT NULL VARCHAR2(30)
ORIGINAL_NAME VARCHAR2(32)
OPERATION VARCHAR2(9)
TYPE VARCHAR2(25)
TS_NAME VARCHAR2(30)
CREATETIME VARCHAR2(19)
DROPTIME VARCHAR2(19)
DROPSCN NUMBER
PARTITION_NAME VARCHAR2(32)
CAN_UNDROP VARCHAR2(3)
CAN_PURGE VARCHAR2(3)
RELATED NOT NULL NUMBER
BASE_OBJECT NOT NULL NUMBER
PURGE_OBJECT NOT NULL NUMBER
SPACE NUMBER


SQL> select object_name from user_objects;


OBJECT_NAME

--------------------------------------------------------------------------------
PK_DEPT
DEPT
EMP
PK_EMP
BONUS
SALGRADE

6 rows selected.

SQL> drop table salgrade;

Table dropped.

SQL> commit;

Commit complete.

SQL> select droptime, original_name from recyclebin;

DROPTIME ORIGINAL_NAME
------------------- --------------------------------
2006-08-29:07:10:28 SALGRADE


SQL> select object_name, original_name, operation from recyclebin;

OBJECT_NAME ORIGINAL_NAME OPERATION
------------------------------ -------------------------------- ---------
BIN$HCIPm0RKljjgQKjAAV0coQ==$0 SALGRADE DROP


SQL> select object_name from user_objects;

OBJECT_NAME
--------------------------------------------------------------------------------
PK_DEPT
DEPT
EMP
PK_EMP
BONUS
BIN$HCIPm0RKljjgQKjAAV0coQ==$0

6 rows selected.

SQL> flashback table salgrade to before drop;

Flashback complete.

SQL> select object_name from recyclebin;

no rows selectedSQL> select object_name from user_objects;

OBJECT_NAME
--------------------------------------------------------------------------------
PK_DEPT
DEPT
EMP
PK_EMP
BONUS
SALGRADE

6 rows selected.

SQL> select * from salgrade;

GRADE LOSAL HISAL
---------- ---------- ----------
1 700 1200
2 1201 1400
3 1401 2000
4 2001 3000
5 3001 9999

The recyclebin feature does not work for sys objects
If you realy want to delete the table and release the space, use the purge command.

Patching HP unix

It has been a few days since my last post. I have had a change of project.
I am working on a internal project.
The last two days I have been patching unix....
I have never done this before. I am used to install Oracle patches using adpatch, but now I had to use swinstall and swremove.

10g on vmware

Yesterday I installed a 10gR2 Oracle database on Suse Linux. Nothing special about that off course, but I did it on my Windows XP laptop using vmware workstation.
With vmware you can create virtual machines with their own operating system.
It takes a lot of resources from your laptop, but it was fun to install it.
Just remember that Oracle does not support vmware in a production environment....see also
http://blogs.oracle.com/schan/2006/08/23#a636

EBS 11i laptop/desktop

In the UK there is a company that sells laptops with EBS 11.5.10 already installed. Because of the great demand of these laptops, they now also sell a desktop version.
For more information, check this link..http://www.appsdba.co.uk/products.html

11.5.9 install part III

I have checked everything so far. The most important test is to check whether all the admin tools work ok. So, I tested adpatch and adadmin.
The Oracle Applications Manager is working, and the applications login also. I cannot start up a forms session from the webapplication..nothing happens. I can login forms without the web application, directly into the forms application.
I think it could be a memory problem, when I start all the services..my laptop is running out of memory.

Oracle Application DBA field guide

At this moment I am reading a book called 'Oracle Applications DBA field guide' from Elke Phelps and Paul Jackson. I must say, it's a really good book with al ot of detailed information about Oapps dba work. I suggest every oapps dba to buy and read this book.
ISBN number 1-59059-644-7

11.5.9 Install part II

Ok, I have solved the jsp problem mentioned in my first 11.5.9 Install post. I can login into the EBS with the sysadmin account. But when I want to start a forms session, nothing happens.
Not even an error, so I have to go through the logfiles again.
I must admit, it isn't easy to work with the EBS 11i on a windows platform when you are used to unix/linux. For example, when I set the environment set ORACLE_HOME=E:\oralce\proddb\9.2.0, and after this I try to cd $ORACLE_HOME, nothing happens. Echo $ORACLE_HOME results in $ORACLE_HOME. SO, I found out instead of using the well known $, use %ORACLE_HOME%....
Well, nobody said it was going to be easy, I have some work to do.

More to come in part III

Changing concurrent output name

Someone asked me if the name of the concurrent output could be changed.
There are two ways to name your concurrent output using the parameter APPCPNAM.
This parameter can be found in the applications environment file (in the $APPL_TOP)
The following values are possible..

APPCPNAM="REQID" (o999999.out)
APPCPNAM="USER" (ORAUSER.out)
APPCPNAM="USER.REQID" (ORAUSER.999999)
APPCPNAM=(unset or unrecognized syntax) (o999999.out)

11.5.9 install

Yesterday I successfully installed 11.5.9 on my windows XP laptop. Before I could begin the install I first had to install al kind of tools like cygwin, gnumake etc...Also installed VC2005 (C++). See note 117545.1 on Metalink for these tools.....
After doing this, I finally began the installation. The first problem I encountered was that the rapid installer didn't find any free space on my external disk. , Found a solution on Metalink, a higher version of the installer (patch 3486525, oui version 11.5.9.22 ). Ok, now it reconized my 250 gb of free space, but finds other errors, which the older version did not encounter ?? Tried again with the older version and ......it works !!!! Don't know why, and I don't care.
So lets begin...Oracle calls it the rapidwiz, but I don't know what's rapid about it...
Because I want to install a vision database, a ebs database with data, the installer skips the first database cd's ( I think...). There are 18 database cd's and at 98 % (cd 18) the installer suddenly hangs....it hangs on adsvdcnv.cmd, at least it takes a long time. Just in case it really hangs, lets google..and yes I find some people with the same problem. But none of them satisfy me. Lets find the logfiles....I found them in the $ORACLE_HOME/appsutil/logs
Huh, the installer hangs on the database conversion, but according to the logfile two steps ago it ran into an error ? It seems the database creation did not went very well..I cannot log in as sysdba and neither can the script that should create the controlfiles !!
I can log in as SYSOPER with pwd change_on_install, and from there connect as sysdba (?)
Created the controlfile myself, and also finished the other scripts including the adsvdcnv.cmd script. No errors...it takes 2 minutes to run this command...But still the installer hangs. In the windows taskmanager I find a sql session...lets kill it. Yes, the installer continues and asks for the tools cd nr1.
It took me te whole night to finish the installation, but it did. At the end there was only a problem with JSP pages, I have to figure that out tonight..

I still don't know why the creation of the database went wrong, but I'm glad I was able to solve the problem. Now that I have an 11.5.9 EBS running, I can patch, clone etc...

Installing 11i

I have tried to take the online course at the opn site, but I couldn't. I received an error, so I have to try again. I also tried to install 11.5.9 on my laptop, I bought an external hard disk, but that not as easy as I thought. Before installing 11i on windows, you first have to install all kind of tools, like gnumake etc..It seems the EBS 11i was designed for Unix only, so the install only uses unix shell scripts instead of windows executables....Tomorrow I will continua the install.

Oracle Implementation Champion

On the Oracle Partner Network (OPN), I found a learning path to become an Oracle Implementation Champion for the EBS 11.5.10.
If you successfully pass the tests, you can call yourself a champion !!
I have tried it at work, but it didn't work. I will try it tonight at home....I will let you know.
For OPN you or your company must be a Oracle partner...

http://www.oracle.com/partners/education/roadmaps/global/implementation/impl_11i10appdba.html

EBS 11.5.10

Some nice features when using EBS 11.5.10

* FNDCPASS has a new parameter, ALLORACLE. With this parameter all Oracle Application schema passwords can be changed in one call (apply the latest application technology patch (11i.ATG_PF.H RUP3 )).

* New in 11.5.10 is also the 'forms personalization'. In earlier versions of 11i, forms personalization was only possible by editing the CUSTOM.pll using the Oracle Forms Builder. Now there is form in the EBS to make these personalizations....Using Help-->Diagnostics-->Custom Code-->Personalize , you can change the form.

* To move personalizations between instances, you can use FNDLOAD. Use the $FND_TOP/patch/115/import/affrmcus.lct to download and upload the personalizations from one database to another.

Work

Today I am working at home for a change. I am trying to prepare myself for the performce job next week. I want to work out a few scenarios. Today I want to find out more about the standby database, maybe it's an option... Above you see how a standby database works..


Update : I also ran into the possibility of upgrading your windows 2003 server from 32 bits to 64 bits to gain more memory....but I have no idea if such an upgrade is easy to do....

Performance

Yesterday I visited a customer who is facing performance problems in their Oracle environment. I have to go back next week, because I had to examine some solutions.
Their environment exists of an Oracle 10gR2 database, and they are running discoverer and an a application on the same database. That's what causing the performance problems....Now I have to look for the best options to solve this, and present them to the customer. Together we will have to solve this problem.

Huh ?

This morning I was searching Metalink for another FNDLOAD issue, when I ran into the following note 37689.1 ,dated 14-JUL-2006....

It seems Oracle has its own FNDLOAD config file for an Alert !!!
This note is very recent, when I started te work on the config file there was no documentation on Metalink on this subject.
But I don't understand...
Why is the Alert not mentioned is the documentation of FNDLOAD (note 274667.1) ?
Why is the Alert config file not in the $FND_TOP/patch/115/import directory, just like all the other config files ???

Well, it seems I have done a lot of work for nothing. At least now I know how FNDLOAD works in detail.

I suggest everyone who wants to transfer Alerts via FNDLOAD, uses the Oraclce config file..

Services in Windows XP

I always face the same problem when deleting/uninstall an Oracle database from my laptop. I don't know why, but I have always some Oracle services left. After a while you have an large list of services, you no longer need to see...Since you cannot delete them from the services screen, I found a way to delete them from the command line.

In the command prompt use the following :

to delete a service you no longer use : sc delete 'service name'
After refreshing the screen, you will notice the service is no longer in the list....

Unix commands on windows

Today I have installed cygwin on my laptop. With cygwin, you create an unix environment to work with your local databases. Otherwise you only have the command prompt, with cygwin you get an unix like screen and all the unix commands seem to work. I love using 'ls' instead of 'dir'.....

I have also started to read the "Oracle Applications Dba field guide". As far as I can see, it's a nice book with all the tasks a Oapps dba should perform or must know. When I have finished the book, I will tell you more about it.

Oracle rocker......

I participated a OTN forum on '10g Enterprise Manager' and got the following reply...
The problem Dele is facing, is a typical windows problem when using the Enterprise Manager..


DELE
Posts: 9 Registered: 7/13/06
backup with enterprise manager Posted: Jul 19, 2006 1:43 AM

Reply
Dear Folks,I have oracle 10g running on windows 2003 server. I want to use enterprise manager to schedule backup. I tried testing the backup but I receive an error message that user name or password is not correct. I am very sure the password is correct.I contacted my Network administrator who granted me backup operator privileges on the host of the database. To my surprise the error message persists.I installed oracle on windows xp standalone and tried to schedule the backup again with enterprise manager i get the same error again.Please anyone with a solution kindly contact me. This is very urgent pleasesss.

Bas Klaassen
Posts: 40 From: NetherlandsRegistered: 7/22/05
Re: backup with enterprise manager Posted: Jul 19, 2006 1:54 AM in response to: DELE


Reply
Be sure that the os user has the 'Logon as a batch job' privilege.

DELE
Posts: 9 Registered: 7/13/06
Re: backup with enterprise manager Posted: Jul 19, 2006 2:45 AM in response to: Bas Klaassen


Reply
Cheers mate,Your solution works fine. U are a cool oracle rocker.

Import status

Today a colleague started an import, approximately 9 gb (one scheme).
At a certain moment the import was running for three hours and I wanted to know what was happening.
I found the following sql script, which shows you the current table in which the import is inserting rows. It seemed our import was inserting over more then 18 million rows.

SELECT
SUBSTR(sql_text, INSTR(sql_text,'INTO "'),30) table_name
, rows_processed
, ROUND( (sysdate-TO_DATE(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes
, TRUNC(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60)) rows_per_minute
FROM sys.v_$sqlarea
WHERE
sql_text like 'INSERT %INTO "%'
AND command_type = 2
AND open_versions > 0;

The script was published by Nasir Mahmood.
Here is an example output of the script....

TABLE_NAME ROWS_PROCESSED MINUTES ROWS_PER_MINUTE
------------------------------ -------------- ---------- ---------------
INTO "ICE_CVS_FAC_TUSSEN_TAB" 3626392 1436 2525

Especially the table sys.v _$sqlarea is very interesting, I am going to find out more about this table.