Setting Threshold Value Without Using Grid
Jun 13, 2012if I create manual database how to set threshold value? is there any other tool to set threshold value?
View 4 Replies
ADVERTISEMENT
PL/SQL :: Space Required To Reduce Threshold?
Jul 3, 2013There are tablespaces where the current usage is crossed 90% and we are getting alerts.I want to know how much space required to add for these tablespaces ( datafiles) so that current usage can be reduced to 80 %. or 70 % Is the any SQL query to find this information . oracle 10 g database. .
View 5 Replies View RelatedEmail Notification To DBA When Threshold Of 80% Reached For Archive Log?
Jul 10, 2013 11.2.0.3 I want the database to email me when the threshold of 80% is reached for the archivelog and backup piece at recovery_dest folder how to do this. Is this the dict table I will check for threshold?
select * from v$recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES -------------------- ------------------ ------------------------- --------------- CONTROL FILE 0 0 0 REDO LOG 0 0 0 ARCHIVED LOG 2.02 1.06 21 BACKUP PIECE 4.76 0 11 IMAGE COPY 0 0 0 FLASHBACK LOG 0 0 0 FOREIGN ARCHIVED LOG 0 0 0 7 rows selected.
Grid / Real Application Clusters Grid Computing With RAC
Aug 12, 2010(Oracle Grid & Real Application Clusters Oracle Grid Computing with RAC) from rampant tech press. I have already ordered it 3 months back and still have not received it as its not printed yet or as i am told is in press. I would be glad to have a copy soon if its published.
View 4 Replies View RelatedSingle Instance Non-Grid To Single Instance Grid Database
Aug 27, 2012I'm trying to test moving a single instance 11202 database to single instance w/ grid infra.
Here is what I've done:
1. Install a database (11202), single instance and create a database
2. Install Grid Software only (user: grid)
3. start the cluster
4. "srvctl add database -d orclsidb -o $ORACLE_HOME" to register the database with grid.
4.1> I was able to start/stop the database with srvctl command here onwards
5. configure disks using asmlib and start the asm
6. "srvctl add asm" to register asm with grid.
7. PROBLEM ... when I try to "backup as copy database format '+ASM_DATA_DG';" from oracle user it errors out as below:
RMAN> backup as copy database format '+ASM_DATA_DG';
Starting backup at 24-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/fs0/oracle/oradata/orclsidb/sjc883p_indx_large_01.dbf
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/24/2012 08:53:29
ORA-19504: failed to create file "+ASM_DATA_DG"
ORA-12547: TNS:lost contact
ORA-15001: diskgroup "ASM_DATA_DG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contactConsidering "TNS: lost contact" I tried to see if grid listener is aware of ASM instance:
[Code]....
All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usracdb03.rwcats.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 22-AUG-2012 06:08:53
Uptime 2 days 2 hr. 50 min. 48 sec
Trace Level off
[Code]....
Forms :: Setting Tab Sequence?
Jan 27, 2011've form which is having 3 tabs in canvas, i want to open second tab first when we open form,
View 4 Replies View RelatedOracle 10g Setting Up Encryption
Sep 24, 2010I am trying to setup encryption and have the following entry in my sqlnet.ora file (all on one line).
ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/oracle/10.2.0.1.0/network/admin/encryption_wallet/)))
When I login into my DB I get the following error:
sqlplus ' / as sysdba '
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 24 16:30:49 2010
Copyright © 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> ALTER SYSTEM SET ENCRYPTION KEY AUTHENTICATED BY "XXX";
ALTER SYSTEM SET ENCRYPTION KEY AUTHENTICATED BY "XXX"
*
ERROR at line 1:
ORA-28368: cannot auto-create wallet
As you can see the directory is not created.
ls -ld /oracle/10.2.0.1.0/network/admin/encryption_wallet
ls: 0653-341 The file /oracle/10.2.0.1.0/network/admin/encryption_wallet does not exist.
The directory above where I want to create my wallet is owned by oracle, which is the user I am running sqlplus as (see below)
ls -ld /oracle/10.2.0.1.0/network/admin
drwxrwsr-x 4 oracle dba 512 Sep 24 15:45 /oracle/10.2.0.1.0/network/admin
/tmp who am i
oracle pts/1 Sep 24 13:25 (is122.hshhp.com)
Setting New Sub Partition Template Has No Effect
Oct 19, 2010Not sure if its an issue or just an Oracle "feature" of some sort. So I create a table with a specified partition/ sub partition template as follows:
CODEcreate table sr_part_test
(
part_key NUMBER,
subpart_key VARCHAR(10)
)
tablespace NORKOM_DATA
partition by range ( part_key )
subpartition by list ( subpart_key )
[code].......
Then when I split the MAX VALUE partition, all is hunky dorey and as expected:
CODEalter table sr_part_test split partition sr_part_max at (4) into
(
partition sr_part_4,
partition sr_part_max
);
select * from user_tab_subpartitions where table_name = 'SR_PART_TEST' and partition_name = 'SR_PART_4';
[code]......
But - what if I want to have new generated names and possibly even new subpartition keys? Won't work:
CODEalter table sr_part_test
set subpartition template
(
subpartition sp_1_NEWNAME values ('foo'),
subpartition sp_2_NEWNAME values ('bar'),
subpartition sp_3_NEWNAME values ('baz')
);
[code]........
Notice that the sub partition names are still using the old names (which I do NOT want), and still using the old keys! C .
Forms :: Field Column Setting?
Sep 30, 2013I am currently working on a bug that came from a user. An oracle form is used for entering employee information and the backend table is employees. One for the field here is LAN ID. It was found that some users were using space bar either before or after entering the Lan id and this is causing issues in finding the employees in the system. A request is being submitted to not let any blanks or space to be entered in the field. In the table, this particular field/column datatype is varchar2 and the size is 8.
How do I make no blanks or spaces to be entered in the field or otherwise, even if they put a space or blank, the field should only use the actual ID entered.. Is it possible?
Forms :: Setting Of Urdu Language
Feb 14, 2008Any one tell me how can i enable urdu in oracle 9i which charter set will be use
View 2 Replies View RelatedServer Administration :: Setting Up 11g Express
Aug 8, 2012I got the attached issue in Win 08 server when setting up 11g express.
Have you ever encountered the same?
Forms :: Setting Icon At Runtime
Feb 12, 2010i want to set the icon on my forms i write these lines.... for to do this...
MDI_ICO := WIN_API_UTILITY.GET_ACTIVE_WINDOW;
WIN_API_SESSION.CHANGE_MDI_ICON(MDI_ICO, '.IconsCOMPANY.ico', 0);
and i also attached the library d2kwutil.pll and when i run the form then this error raised...
FRM-40734: Internal Error : PL/SQL error occurred..
now what can i do for set the icon at run time..the first part of the message has been removed as it belongs to @allianz2010's previous topic; the rest has been split into a new.
Forms :: Setting Output Path
Feb 1, 2010Recently i faced with a situation of redirecting a report output to a particular path in my server, and then opening the output by using web.show_document.
I was successful in redirecting it too a path , however i am not able to open the file using URL. We should setup virtual path in orion-web.xml and proceed further.
I pointed the output to an existing virtual path as below in my orion_web.xml file.
D:OraHome_2 oolswebhtml
and tried opening the output through the url
<<<server_name>/forms/html/filename.extn>>>
however i was not able to add new virtual path here .
Server Administration :: Setting Up UTL_MAIL
Apr 9, 2013Using UTL_MAIL package.
My server version is:- 10.2.0.3.0
Here is the INIT Parameter file.
My question is, how it will affect if I configure the UTL_MAIL package by executing the Scripts ("utlmail.sql" and "prvtmail.plb")? And setting the Parameter SMTP_OUT_SERVER=''?
Forms :: Setting Date Formats In 6i
May 19, 2011I have been allocated a new PC. Where is the date format used by forms (6i) set up. I previously used to enter 20110519 in the application and it used to accept. It now does not accept the above format.
The nls_date_format on the database is setup as YYYYMMDD.
Preventing Loss Of Data Because Of NLS_LANG Setting?
Oct 28, 2010I have a database using character set AL32UTF8. The database contains character strings (VARCHAR2 colums) that may contain both Western European and Eastern European characters (and may be even other kinds of characters such as Cyrillic or Asian).
Suppose a client application has set NLS_LANG character set to WE8ISO8859P1. By this Western European characters will be shown correctly, while Eastern European characters which do not compare with WE8ISO8859P1 will be converted and shown as '?' (question marks) in the client application. If a user of this application fetches a record with Eastern European characters, modifies the record and then rewrites it to the database, the Eastern European characters with be rewritten to the database as question marks, i.e. Eastern European data have been corrupted.
I would like to prevent this by detecting that data were not converted properly during the fetch and then show the record to the user in read-only mode in order to avoid data loss, but I have not been able to detect the conversion error.
The application fetches data through the OCI interface using the "ofetch" function. The error code set by ofetch is the same (i.e. no error) regardless of whether the record contains Eastern European characters or not.
I thought I could manage this by setting the database parameter NLS_NCHAR_CONV_EXCP to TRUE, but this has no effect. Apparently this only deals with operations directly in the database.
SQL & PL/SQL :: Setting Session Variables From Application Server
Feb 23, 2012We are running a brower based client application in a J2EE container on weblogic, connecting to the database using proxy authentication from a connection pool.
We want to set the logging level in the front end, which should set a PL/SQL package/session variable to the respective value.
Any subsequent calls to the DB layer (stored procs) would then log appropriate messages depending on what the logging level has been set to.
The trouble is that the calls to be database are not persistent and in different sessions, and therefore the second call (i.e. the call to the stored proc) would not 'know' what the first call (to set the package variable) has done.
Alternatively we can change all the stored procedures to accept an input parameter denoting the logging level, but I am sure there are other better options.
Reports & Discoverer :: Export To Excel Setting
Mar 17, 2011I used to click the "export to excel" icon on the menu and it open the excel worksheet with the option for me to save in the specified directory and name. But after my computer have Java v24 updated, when I try to export to excel, it does not give the option to open the worksheet instead it saves the excel file to the C:/users/ directory and overwrite every time I export.
View 1 Replies View RelatedSQL & PL/SQL :: Setting Column Value Depending On Number Of Month
Aug 1, 2011My need is to calculate rows and write result into column:
c1 if current month is 1st in quarter,
c2 if current month is 2nd in quarter,
c3 if current month is 3rd in quarter.
How do I perform it?
SQL & PL/SQL :: Setting Variable In Procedure Based On Parameter?
May 24, 2011I am reading in a selection of parameters. I have created a new variable which I want to set according to the value of one of the input parameters.
I am doing this straight after declaring the variable, but before the cursors and BEGIN statement It is throwing an error when I do this - but I have to do it before the cursors.the variable I am setting is: v_fptransType you can see the IF statement towards the end of the code.
the error I am getting is:Error(28,3): PLS-00103: Encountered the symbol "IF" when expecting one of the following: begin function package pragma procedure subtype type use <an identifier> <a double-quoted delimited-identifier> form current cursor The symbol "begin" was substituted for "IF" to continue.
beginning of the
create or replace
PROCEDURE "P_GLPOST" (i_entity IN varchar2, i_transType IN varchar2, i_startDate IN VARCHAR2,
i_endDate IN VARCHAR2, i_accountPeriod IN VARCHAR2, i_includeInternals IN NUMBER, i_chargeable IN NUMBER, i_trialPost IN NUMBER,
i_postingReport IN NUMBER, TESTER IN VARCHAR2) is
--set serveroutput on size 1000000;
[code].....
Forms :: Setting A Date 18 Years In Future?
Mar 26, 2011I am trying to set a item to system date + 18 years. What type of formula or where to put such a thing. i tried putting- select add_months(sysdate,216) from dual; into the calculation-formula in property palette with no success.
View 1 Replies View RelatedSyntax For Setting Pctfree And Pct Used For A Specific Table?
Apr 25, 2013tell the syntax for setting pctfree and pct used for a specific table.
View 4 Replies View RelatedClient Tools :: Setting Oracle Parameters
Apr 24, 2012I am setting the oracle_home,oracle_sid on windows server2008.
oracle client 10g and oracle server 11.2.0.1.0 are installed on my machine and i have created 2 database on my machine.
Application Express :: Setting MaxDate Using Javascript?
Jun 24, 2013I am struggling to set the maxDate of a datetimepicker.
In the document load of the page I have this:
$('#P64_STARTDT').datepicker("option", "maxDate", $v('P64_XFORMATSTARTDT'));
P64_XFORMATSTARTDT is in the format YYYYMMDDHH24MI
It never sets it.
SQL & PL/SQL :: Setting Select Count Value Into Output Variable
Apr 12, 2011I'm trying to return the number of records in my link table that contains the excursion_id I pass in by counting them. It doesn't seem to like the select count(*) into my output variable.
create or replace
PROCEDURE BOOK_PASSENGER(
EXCURSION_ID IN excursion_booking.excursion_id%TYPE,
PASSENGER_ID IN excursion_booking.passenger_id%TYPE,
NUMBER_BOOKED OUT NUMBER)
AS
BEGIN
INSERT INTO EXCURSION_BOOKING VALUES(EXCURSION_ID, PASSENGER_ID, NULL);
SELECT COUNT(*) INTO NUMBER_BOOKED FROM EXCURSION_BOOKING WHERE EXCURSION_ID = EXCURSION_ID;
END BOOK_PASSENGER;
Forms :: PERMISSION DENIED While Setting Value Path
Oct 13, 2012At the time of installing developer 6i am getting the above error,at the stage of selecting the path for forms its throwing the above error saying the permission denied in setting the value path....
does any one come across this type of error before...
Setting Memory Parameter Values In Pfile
Nov 24, 2012If I have to create a database on server which has already 5 databases running , how will I set the memory (pga,sga) values . AFAIK it depends on o/s is linux and database version is 10g and 11g .
1)free avaialble memory on server .
2)kernel parameters .
what else has to be considering while initialize memory parameters .
Application Express :: Setting Up SSO In Work Area?
Jul 5, 2012How to set up Apex SSO in your work area? I have been trying to set it up, but to no avail. I even tried asking support but still under oblivion.
Have you able to run this script before?
apex_sso.sql, apex_verify.sql, apex_sso_server.sql
My output for this scripts are good.
Forms :: Dynamically Setting No Of Records Displayed In Block
Jun 25, 2010i have a cursor which selects the codes based on the school records now i have a multi record block b1 the requirement is that if no of records selected in cusor is 10 then in block b1 10 records should be displayed and if it is 15 then 15 records should be displayed. Is there any way that i can set the no of records displayed in a block dynamically.The block b1 is non database block i am only using a create_record to populate the block.
View 2 Replies View RelatedServer Administration :: Database Sessions - Setting Value Of Parameter
Mar 26, 2013I have a simple question about database sessions. The value of parameter "sessions" is set to 500 and the users connect to database through an application server(Jboss). There are more than 500 users connect to the database through application.
My question is, how more than 500 users can connect to the database without any issue, if we set the value of "sessions" parameter to 500?