-
Analyze AWR reports
Hi, I am looking for a tool to analyze a set of awr snapshots, something like WISE or spviwer. Any ideas?
Help will be appreciated
Regards,
Luis
Posted:
Jan 10 2008, 10:30 AM EST by
-
ASM with PeopleSoft - yes or no?
We are doing an initial installation of a new PeopleSoft system. This will run on Oracle under AIX. Our plan was to install and use ASM with Oracle. Our PeopleSoft consultants, however, tell us that the PeopleSoft install scripts are written for a non-ASM environment and will not work in an ASM environment unless they are heavily modified. They also tell us that none of the New York State PeopleSoft customers are using ASM.
We are building a brand new system here, and want to do it the best way. I need to decide whether we need to insist that we go with ASM, or follow the advice of the PeopleSoft consultants and build a non-ASM environment. We are new to Oracle, AIX and PeopleSoft, and are looking for help in making this important decision. Since we have no Oracle experience, we want to build a system that is solid, and that is easy to support. Our hope was that ASM would help us to do that.
Any advice would be welcome. Here is our environment:
# IBM Power 550 8204-E8A
# AIX v6.1 TL0 SP4
# Oracle 10.2.0.3.0 64-
# PeopleTools Release 8.49
Thanks.
Posted:
Jul 1 2008, 8:16 AM EDT by
-
Berkeley data base have a probelm
I have a very serious problem with a Berkeley data base.
The system is like oracle data base system, but for embedded systems.
The problem is that when I need to empty one of data dase (in xxxx.db files), the xxxx.db file doesn't reduce it's size.
But I can see how those records disappear of the data base.
How is this possible?
Please respond as soon as posible.
Thanks.
Posted:
Mar 6 2008, 10:23 AM EST by
-
Content deletion audit
I would like to know when somebody erases a version or complete content from content server.
I can get an access audit from one version of the content. however, if I delete the current content version I will lose the possibility of getting an access audit from this version. The content trash is disabled on my UCM instance.
How can i do that ORACLE UCM 10g?
Posted:
Jan 4 2008, 5:47 AM EST by
-
Create Database Links in a LOOP
Does anyone know how to go about creating a database link within a loop statement? I keep getting the following error messasge:
PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:
begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
I am trying to use the columns from a table and declare that as a cursor and then loop through that cursor to use that information in a create database link statement.
Any ideas?
Posted:
Feb 4 2008, 10:23 AM EST by
-
DataPump Import
Hi,
I am facing a small problem with datapump import, i exported a schema using datapump export(expdp) the same dump file i used for import using (impdp), once when the import is over i see all procedures,triggers and etc are all created with double quotes such as CREATE OR REPLACE PROCEDURE "ACCOUNTTRANSFERDETAIL_INSERT". So when doing a DataBase Difference these all comes as mismatch, so is there any way to overcome this error.
When i do a export and import in oracle 9i everthing was ok.
Now our QA team is doing a oracle 10g export and import (EXP & IMP) activities and i (DEV) team using oracle 10g datapump for export and import (expdp & impdp) this is where we are facing problem. Comparison is between oracle 10g (exp & imp ) and oracle 10g datapump (expdp & impdp).
For their schema there was no double quotes and when i refreshed a schema using impdp objects where enclosed using double quotes.
I also checked in data dictionary there also i see the object names enclosed with double quotes.
so i anybody has solution please revert back.
Thanks
Regards,
Ganesh R
Posted:
Jun 4 2008, 12:29 AM EDT by
-
DB upgrade from oracle 8.1.7 to oracle 10g (10.2)
I was looking for a list of common issues that may arise from an Oracle 8i (8.1.7.3.0) to Oracle 10g (10.2.0.2) migration for my quality control team to focus on. Do you know of a place where a list of known issues exists?
Posted:
May 13 2008, 11:37 AM EDT by
-
HI all
I have one problem in Toplink.
i am using Jdeveloper For create Toplink. I tryed one search methon Toplink Map. I created as per my knowl.
runing also i got success page.
the problem is i am getting result from One Table if i give that critirea means i will get a result page. But here if i give the primary key field the result page came other wise it wound come.
i dont know how to solve it.
please any one help me..
i am waiting for good guidence...
Posted:
Apr 23 2008, 5:59 AM EDT by
-
how to find the size of table in oracle
1)how to find the size of table in oracle?
Please suggest.
2)I am trying to truncate a table have millons of records and having 11k partitions.
ddl statement (truncate) doesnt comes out after hours.
when I used drop table commands it succeed.
Please explain why?
3) Is it ok to rebuild indexes on every monday and analyse them on every friday?
Thanks in advance.
Posted:
Jun 12 2008, 2:04 AM EDT by
-
i need help
Can any one explain about ADF BC?
Any one having strong work experience IN ADF BC?
Please Reply to me.
Posted:
May 21 2008, 5:19 AM EDT by
-
I'm having a problem installing Oracle9i on Vista!
I tried to install oracle 9i on windows vista but not succeed. Can anyone please tell me what to do? Or what is the compatible version of oracle 9i on windows vista.
I keep getting JRE was not found. To be precise here is the message I was getting:
“The Java run Time Environment was not found at C:\...\jre\bin\jrew.exe. Hence, the Oracle universal Installer cannot be run. Please visit sttp://www.javasoft.com and install JRE Version 1.1.7 or higher and try again”
I have installed JRE version 1.6.0 and is enabled in the machine I’m trying to install Oracle9i.
Can anyone help me figure out the problem?
Thanks
Posted:
Jul 26 2008, 6:05 PM EDT by
-
Import Template
Cannot obtain Virtual Machine type. I'm using the template for Linux 5.1 X86 PVM 4GB which I dowloaded from the Oracle VM site. I have 2 servers in my pool one is for VM Server and the other is for Server Pool Master and Utility Server. Anybody know what this is about?
Thanks
Posted:
Apr 30 2008, 6:59 PM EDT by
-
Inactive session
Hi Guys,
Could you please tell me what exactly SQLNET.EXPIRE_TIME parameter does in sqlnet.ora file? if i set that to non zero number, does it kill inactive sessions??
help me please
Posted:
Jul 7 2008, 12:48 AM EDT by
-
Insert using &
Hi,
Does anyone know how to use the insert statement with inserting a value that includes the &?? I have a column in my database that requires me to use the & sign. For example, the field would be 'PB&J'. However, SQL Developer does not allow me to insert those values because it keeps asking me to insert a substitution value. Any ideas on how to get around this?
Thanks!
Posted:
Jan 21 2008, 2:05 PM EST by
-
Installation setup suggestion
suggestion for the tree products in the installation setup : to first display two branch by separating server products from the client products.
Posted:
Jun 4 2008, 10:42 AM EDT by
-
Live Migration
Is there any demo or how-to for live migration? I tried to use the VM Manager web based utility for a live migration process, but seems I also have to do some other stuff manually before that. Here is the message I got when tried to use the VM Manger:
failed:<Exception: tgt_host=xxx.xx.xx.66 =>failed:<Exception: Could not find '/OVS/running_pool/34_OEL_R5U1_01' in any storage repository.>>
I have 2 servers on 2 identical servers and want to migrate a OEL U5R1 from one server to another one (I can use NFS only). What steps do I have to take before using Oracle VM Manager web-gui lets me to do the migration?
Please consider me as a newbie in Xen and Oracle VM.
Posted:
Feb 7 2008, 4:06 PM EST by
-
My wish list of Chinese New Year
I wish JDeveloper can have a set of video like this: http://msdn2.microsoft.com/en-us/beginner/bb308760.aspx for beginner.
I do play quite a bit of JDeveloper and I like OC4J and ADF but I find it hard to convince convince my colleagues and customers to learn JDeveloper.
Posted:
Feb 6 2008, 5:18 AM EST by
-
new to oracle
please willove to be a good dba any good guide on steps is my wish
Posted:
Jun 10 2008, 10:10 AM EDT by
-
OA Framework Question
Dear friends,
Kindly help me with your thoughts for resolving this particular issue in my current project.
Question:
In iReceivables, how the customer can submit a credit request (Dispute) with comments?
Note:
Need to make the comments attribute required. The comments attribute is in the Enter Dispute Details page. Any help in greatly appreciated.
Thanks in advance.
Regards,
CK
-
OCA
hi
I want to be OCA
but i dont have any idea abt examination
i havent any material
please help me by providing proper guidence
Posted:
Apr 28 2008, 9:25 AM EDT by
|
|
