Enterprise Search :: Configuring Tags For A Keyword?

Jun 21, 2013

We have an Oracle UCM and Oracle SES implementation.Currently there are too many tags returned for certain keywords by SES which breaks the UI,some of the tags being irrelevant too.Is there any configuration variable in SES by which these tags can be limited to say 20 most relevant tags.?

View 0 Replies


ADVERTISEMENT

SQL & PL/SQL :: Search Documentation In Oracle With Keyword (Top-N)?

Feb 12, 2011

I have questions on Top N.Before post this thread, I have read these: One select in TOP Na thread very similar with my problem

Search the documentation in Oracle with key word "Top-N", but what I mostly got is about: "Top-N Frequency Categorical Binning"

SQL> select ename, sal
2 from emp
3 where sal in
4 (
5 select distinct sal

[code]...

Actually, I am not missing parenthesis, and I can not see any syntax error.what does the issue occur?

View 6 Replies View Related

Enterprise Manager :: Configuring Grid Alerts For Two Different Groups Based On Database Environment

Aug 12, 2010

i have implemeted grid control for monitoring database. we have different database environment like PROD , STAGE, TEST, BETA.

Now my requirement is, i need to configure PROD & STAGE alert for one group (group1@oracle.com) means, what ever alerts generated by grid should sent notification to group1@oracle.com and TEST AND BETA database alerts should to group2@oracle.com.

Now i am following the oracle manual to configure notifications. unfortunately i could not find to complete my requirement.

[URL]

did any one implemented alerts to send different groups.

View 2 Replies View Related

Enterprise Search :: Last Modified In Web Source

Jul 13, 2012

I have created a web source with the default settings and pointed it at a test site. The pages being craweled have both last modified response headers and meta tag last-modified being set in the rendered html but the crawler doesn't seem to be indexing the values.

It is indexing and returning last modified on the liked files (i.e. *.doc, *.pdf) but not the actual web page itself.

Am I missing a step? How do I get the last modified meta tag of html to be indexed?

View 0 Replies View Related

Enterprise Search :: Supported SES11g security Module With WCC11g

May 24, 2013

My customer is using latest SES11g with WCC11g, the WCC11g has ACL security module, in SES document, it mentioned only security group and account module in WCC is supported when using SES, but somebody tested SES did work with WCC with ACL security module, is there any document in SES mentioned this is a supported feature?

View 0 Replies View Related

SQL & PL/SQL :: How To Use Tags And Make Code Easier To Read

Sep 5, 2011

format your code (Instant SQL Formatter is here) and - before submitting a message - enclose it into the [code] tags.Note the difference; see how the formatted code is easier to read?

View -1 Replies View Related

PL/SQL :: Escape HTML Content Without Escaping Tags

Jul 4, 2013

How can I escape HTML content without escaping the HTML tags?

View 4 Replies View Related

SQL & PL/SQL :: Finding Function In Oracle Which Removes All HTML Tags?

Dec 14, 2010

is there any function in oracle which removes all HTML tags . our web pages uses rich text editor, when user enters text into editorand saves it, the database will have text with formatting ie all html tags. this works fine as long we display this text in web pages , but some time we have to provide reports to user just by running sql and ouptut in excel, in this case I want to strip out all html tags within the text .there is any function which can strip all HTML tags?

View 6 Replies View Related

Application Express :: Enable IR Search Field To Search In Hidden Columns

Jul 15, 2012

I am using apex 4.1. I must hide phone number columns in my IR report, but at the same time the values of that columns should be available to search for using IR Search Field. is there a way to do this ?

if not, that means I have to :

1- Add a text filed P1_PHONE
2- edit my report query to something similar to
> Select * from Table where :P1_phone in (mobile1,mobile2) or :p1_phone is null
3- add button to refresh the report.

but the item P1_PHONE should be on the header of the Report region. is there a way to do this.
I am using theme 23
page template without sidebars
Report template : Reports Region.

how to put the item P1_PHONE on the tab of the page. Just similar to the Search item of in the Application Builder.

View 7 Replies View Related

RAC & Failsafe :: Error While Configuring Css?

Jul 23, 2011

i got a problem while configuring asm in linux operation system for practice purpose and it troughs error the folllowing details are as fallows.

operting system = oracle enterprise linux 5
software =oracle 10g version= 10.1.0.2.0
oerating system kernel parameters=2.6.18-194.el5PAE

when i'as issuing commed(Localconfig add) on root users i'm getting the following error
[root@prod ~] localconfig add
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 392: /etc/init.d./init.cssd : no such file or directory
/bin/rm: cannot remove '/etc/init.d/init.cssd' no such file or directory
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 402: /etc/oracle/ocr.loc no such file or directory
in/rm : cannot remove /etc/oracle/ocr.loc' no such file or directory
bin/rm: missing operand
try '/bin/rm --help for more information

solution i tried for this errror
1.i tried to locate lidbl.so.2 libraies using locate libdl.so.2 and cpoied to location create soft link but still its the same error.
2)i tried ti install rpm pakages for kernel 2.6.18-194.el5PAE but still same eror.
3)i export the library path in bash_profile but still i got same problem

View 1 Replies View Related

PL/SQL :: Error While Configuring Emca

Sep 26, 2012

Below is the error returned, while configuring "emca" for "enterprise manager"

C:Documents and Settingsuser> emca -config dbcontrol db -repos create

STARTED EMCA at **** **:**:** PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: orcl
Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable.
at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(DatabaseChecks.java:151)
at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:144)
at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
------------------------------------------------------------------------------------------

orcl is the oracle sid on my computer and database status is RUNNING

View 3 Replies View Related

Application Express :: Configuring FOP For 4.2?

Mar 14, 2013

What do I have to do in order to configure FOP for APEX 4.2 ?

View 3 Replies View Related

Error While Configuring RMAN Script?

Aug 6, 2010

after configuring the rman sript when im running the script its giving the error like this

RMAN-00571:-----------------------------------------------------------------------------------------------------
RMN-OO569:--------------------ERROR MESSAGE STACK FOLLOWS-------------------------------------------
RMAN-00571:--------------------------------------------------------------------------------------------------------
RMAN-03008:error while performing automativ resync of recovery catalog
ORA-01580:error creating control backup file /disk1/oradata/car/rman/snapcf_car.f
ORA-02704:file create error unable to create file

View 1 Replies View Related

Configuring OEM Alerts For Mobiles To Send SMS

Aug 15, 2010

How to configure SMS alerts for mobiles from OEM. We have a very big setup managed by 10g grid and i want to configure Mobile SMS alerts from OEM Grid.

View 5 Replies View Related

Configuring Udev Rule For Raw Disks?

Jan 1, 2013

I am using oel 5.8, oracle 11.2.0.3. The raw disk permissions are getting changed when the node gets rebooted.I am trying to use udev rule to change the permission permanently but its not working.

CODE[root@VM-PAGRAC3 rules.d]# more 99-asm.rules
KERNEL=="sd", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",*
RESULT=="SATA_VBOX_HARDDISK_VB7a29b7ae-de673b56_",
NAME+="oracleasm/disks/DSK1#" OWNER="grid"
GROUP="asmadmin" MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",
RESULT=="SATA_VBOX_HARDDISK_VB36f5d134-4e0e4c43_",

[code].....

View 8 Replies View Related

Golden Gate Errors Out While Configuring?

Aug 18, 2011

I am trying to configure Golden Gate but i am running into the following errors while configuring. Given below is the contents of the configuration.

ggssci>edit params mgr
PORT 7809
USERID ggs_owner, PASSWORD ggs_owner
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/ex, USECHECKPOINTS

[Code].....

View 1 Replies View Related

Configuring Loopback Adapter For Oracle

Jun 4, 2013

On my PC I have installed Oracle 10g & Oracle Forms & Reports 6i .My PC is on LAN ,to avoid problem of dynamic ip address & tns 12514 as PC get connected & disconnected from LAN regularly I have just installed Loopback Adapter.As my PC on LAN so it have old NETWORK CONNECTION which have specific ip address,subnet mask, default gateway,preferred DNS server , alternate DNS server.

How loopback adapter going to work & what I have to do after installing LOOPBACK ADAPTER? Can I give the same ip address,subnet mask, default gateway,preferred DNS server , alternate DNS server on my new network connection (generated after installing Loopback Adapter) as it is on my old network connection & delete or disable old Network Connection. And come in my original LAN with same settings on new Loopback Adapters newtwork connection. Or I have to keep both network connection .

View 5 Replies View Related

Exadata :: Configuring Dataguard With DR Server And DBM

Oct 10, 2012

Refer a MOS Note for configuring data-guard on Exadata with DR server being and Exadata DBM too.

View 4 Replies View Related

Server Administration :: Configuring IP Address Instead Of HOSTNAME

Apr 7, 2009

I have purchased LIVE IP on my application server to access it anywhere on the internet.I am calling application on the internet as URL>...And its working perfectly.

I have configured Sigle Sign On and using this code on "When-Button-Pressed" to call report

WEB.show_document('/reports/rwservlet?server='||:PARAMETER.reps
||'&ssoconn=default/oracledb/userid'
||'&report='||repid
||'&desformat=PDF'
||'&destype=CACHE'
||'&pyear='||:PARAMETER.pyear
||'&branch='||:PARAMETER.branch_id
||'&bk='||:transactions.book
||'&sno='||:transactions.srno
||'¶mform=no'
,'_blank');

From Client side When i press button "sigle sign on authentication page" of Internet Directory is not coming. Because URL is accessing the application server using the HOSTNAME of application server instead of IP ADDRESS like this URL....

How can i configure it to use only IP address.

View 25 Replies View Related

SQL & PL/SQL :: ORA-00923 - FROM Keyword Not Found Where

Jul 12, 2012

SELECT CREWACTIONFACTID
,CrewKey
,EventID

[Code].....

View 3 Replies View Related

Parallel Keyword In Expdp

Dec 17, 2012

i am trying to export table using datapump in oracle 10g, this expdp takes 5 hours time, so i want use use parallel keyword in expdp,
my question is how should i know number of parallels can i use...?

View 3 Replies View Related

PL/SQL :: Use A Subquery After Update Keyword?

Oct 18, 2012

Can we use a subquery after the update keyword??

For example

UPDATE ( Select col1 from test)
set col1='x';

In short can we replace the table name after an update and use a select statement instead??

View 3 Replies View Related

SQL & PL/SQL :: ORA-00969 / Missing ON Keyword

Jan 11, 2012

I issued the command

grant select(employee_id, job_id) on employees to scott;

But it returns error as

HR:orcl > grant select(employee_id, job_id) on employees to classuser;
select(employee_id, job_id) on employees to classuser
*
ERROR at line 1:
ORA-00969: missing ON keyword

View 5 Replies View Related

RAC & Failsafe :: Installing / Configuring Real Application Cluster Using NFS Instead Of ASM?

Feb 28, 2012

i want to install oracle real application cluster using shared file system and not using ASM. we are not creating LUN for our data to kept and SAN admin will give us NFS share where we will place the database.

View 5 Replies View Related

Networking And Gateways :: Listener Start Failed After Configuring?

Nov 2, 2011

i could not able to add and open listener to install Oracle database 11g R2 on window 7 ( 64 bit OS).

Steps :

1) i installed Oracle 11g R2 Software Only.

2) Started DBCA to configure Database

3) I got a message that i need to configure Listener first.

4) I opened NETCA and add a listener ( default name LISTENER)

5) Then re-opened DBCA to start Database configuration and found the same message configure listner.

6) I went to control panel-> Services -> i found no listeners there

7) i started NETMGR and add a listner and its location as well I started DBCA and found the same message add listener

9) i opened LSNRCTL and typed the command to START LISTENER and i found no listener error

10) When i am trying to add listener using NETCA ,during it's last step listener adding completion i found the below message :

Oracle Net Services Configuration:
Stopping Oracle Net Listener:
Running Listener Control:
d:apporacleproduct11.2.0dbhome_1inlsnrctl stop LISTENER
Listener Control complete.
Listener stop failed.

[code]....

View 4 Replies View Related

ORA-00905 Missing Keyword Error

Apr 9, 2008

Oracle and I am receiving ora-00905 missing keyword error.what could possibly be wrong with this SQL statement?

Select
T1.*,
T2.*
From
Table1 T1 INNER JOIN
Table2 T2 On
[code]....

I am trying to select the maximum dates from 2 different tables and I am using Oracle 10.

View 8 Replies View Related

SQL & PL/SQL :: ORA-00923 - FROM Keyword Not Found Where Expected

Nov 11, 2010

I am having some difficulties with this trigger. It keeps giving me the error "ERROR at line 5: PL/SQL: ORA-00923: FROM keyword not found where expected" when I am not even using a SELECT before the line it says the error is on? Here is the trigger that I am attempting to create.

CREATE OR REPLACE TRIGGER ClassRestraint
BEFORE INSERT ON Enrolled
FOR EACH ROW
DECLARE
numCourses NUMBER :=0;
myException EXCEPTION;
BEGIN
[code]...

I am getting the error on line 5.

View 5 Replies View Related

SQL & PL/SQL :: Analytical Function With Distinct Keyword

Mar 8, 2012

can we use distinct keyword with the count and sum analytical functions?

View 5 Replies View Related

ORA-00923 - FROM Keyword Not Found Where Expected

Jun 23, 2011

I have this script which should find tablespaces and their size, joined with free bytes. Trying to run this gives me the SQL Error: ORA-00923: FROM keyword not found where expected.

I have two questions:

1. Where should the FROM be?

2. Is there something wrong with the join.

==============================================
set linesize 120
col "TOTAL (KB)" format 99999999999999999
col "FREE (KB)" format 9999999999999999
col TSNAME format a35
col "% FREE" format a10;

SELECT a.tablespace_name TSNAME, sum(a.bytes/1024) "TOTAL (KB)",
Sum(b.bytes/1024) "FREE (KB)"
To_char(round((sum(a.bytes/1024)/sum(a.bytes/1024))*100),2), 'FM99990D999999')
|| ' % ' "% FREE"
FROM dba_data_files a, dba_free_space b
Where a.tablespace_name = b.tablespacename
Group by a. tablespace_name
[/i]
=============================================

I used the script from [URL]

It worked great but I'm not sure how to use the arithmetic functions to show me MB instead of bytes.

View 1 Replies View Related

ORA-00923 / FROM Keyword Not Found Where Expected

Jun 29, 2007

The following syntax gives me the error:

ORA-00923: FROM key word not found where expected

if this is so, why use 'from' in TRIM function? Or is my syntax incorrect?

SYNTAX: select trim leading ('0' from (substr(to_char(polref_nbr),9,10))) "TRIM example" from tbl_vg_adhoc;

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved