How To Change Remote_login_password File Status
Jan 21, 2006How to change the status of remote_login_password file!
View 14 RepliesHow to change the status of remote_login_password file!
View 14 Replieshow to change tablespace plugged_in =no status to yes
View 1 Replies View RelatedIn one of the databases, we have created more temp tables as on commit preserve rows. but i want to change the on commit preserve rows to on commit delete rows as per application requirements.I have searched the google but i didnt find any alter scripts for it.?
View 1 Replies View RelatedI have a requirement to get decrypted value of national_identifier from database and display in Social Security number, when user queries for employee in employee form of HRMS. Also, National_identifier should be in encrypted format in database table always.
To meet above requirement, I am using custom.pll. In WHEN-NEW-BLOCK-INSTANCE I am getting decrypted value of national_identifer from database and assigning it to :person.national_identifier(database block) by using COPY function, so far it is working as expected.
When user query for employee, he/she able to decrypted value. but if user closes the form it is asking 'Do you want to save changes you made' as there is a change in :person.national_identifier.
Do we have any property to reset record/block status to something like unchanged, so we will not get 'Do you want to save changes you made message'.
I want to backup all archive logs,but it raise error,why?
run{
allocate channel dup type disk;
sql 'alter system archive log current';
backup format '/u01/app/oracle/duplicate/al_t%t_s%s_p%p' archivelog all;
release channel dup;
}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/13/2012 05:04:04
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/duplicate/1_33_769179320.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Oracle Database Version : 9.2.0.8.0
Some of the datafiles status have been changed to 'RECOVER', because the datafiles are physically missing.
Now, how can i find that when (timestamp) the status of the datafiles have been changed, as i am unable to find when the datafiles have been physically lost?
Please consider both the case :
1) when the database is in ARCHIVELOG Mode.
2) when the database is in NOARCHIVELOG Mode.
I'm in an environment with Weblogic Oracle Forms 11G (Oracle Fusion Middleware). I can not update a form that is in use. I can not change the fmx file.
Can I change this? Where can I configure this?
does, block change tracking file is read during incremental level 0 backup?
View 4 Replies View Relatedi did such commands
1. RMAN -> backup incremental level 0 database;
2. SQLPLUS -> alter database enable block change tracking using file '/home/oracle/block_change_tracking.tr';
3. RMAN -> backup incremental level 1 cumulative database;
4. RMAN -> backup incremental level 1 cumulative database;
5. RMAN -> backup incremental level 1 cumulative database;
and for such order i noticed that block change tracking file wasn't used for any cumulative backup. for each cumulative backup was done full scan over database.
it was used after i did incremental level 0 backup, and again incremental 1 cumulative.
if i want this feature to be usefull i should enable it before my incremental level 0, or i should do incremental level 0 immediately after i enable it?
how i can change backup datafile name into its original file name,bcoz at time backup datafile name is different and how i can change that name into its original datafile name so i apply recovery command in user managaed recovery..
View 7 Replies View RelatedI need to change "File Character" when I export application with Apex 4.2.1.00.08 version, but this option, is not possible. The ComboBox already select with
"Unicode UTF-8]', but I need "ISO-8859-1 - Europa Ocidental",
how can I do change it?
I delete member logfile from disk with statement: shred -fu /u01/app/oracle/redologs/activeredolog/DB1/redo0102.log
But if I check status one logfile with statement:
select status from v$logfile wheremember='/u01/app/oracle/redologs/activeredolog/DB1/redo0102.log';
Status is still null. I think status should be change.
My database is 11.2.0.1 with single instance.
Status is changed after restart instance.
Haw can I monitor status logfiles without restart instance?
Im looking for a query which returns the batch for which all the child should either be in 'A_STATUS','B_STATUS' or 'C_STATUS'. In this query im expecting a query which returns batch 2,3 and 4.
create table batch (batchid number);
insert into batch values(1);
insert into batch values(2);
insert into batch values(3);
insert into batch values(4);
[Code]...
i am migrating forms 6i to 10g, when i compile one form to checking purpose all are successfully fine but the record status bar not showing there fore message are not appear how to solve this problem
View 1 Replies View RelatedI have a clients table called CLIENTS. One of the fields in this table is called 'status'
I need to set this status field, depending on if the transactions for this client have passed.
The transactions are in a table called TXNS and has fields
client_id, txn_id, txn_status
txn_status can be 'success' or 'failed'
I need to somehow set the overall 'status' field on CLIENTS to success or fail depending on if any transactions failed or not
So for every client I want to list the status, any query that can possible list the overall status for the client?
select client_id, MAX(status)
from txns
group by client_id
but the max(status) bit needs to get the overall status part
I'm looking for a way to get continuous dates as a period in the result.My tabledata contains a date and a status, I want to get continuous dates with the same status value.
That's my tabledata:
select * from (
select to_date('01022012', 'ddmmyyyy') as thedate, 1 as status from dual
union select to_date('02022012', 'ddmmyyyy') as thedate, 1 as status from dual
union select to_date('03022012', 'ddmmyyyy') as thedate, 2 as status from dual
[code]...
THEDATE STATUS
---------- ------
01.02.2012 1
02.02.2012 1
03.02.2012 2
04.02.2012 1
05.02.2012 1
[code]...
And that's the result I am looking for:
select * from (
select to_date('01022012', 'ddmmyyyy') as startdate,
to_date('02022012', 'ddmmyyyy') as enddate from dual
union select to_date('04022012', 'ddmmyyyy') as startdate,
[code]....
I've got a pl/sql procedure that i would like to monitor its progress. Its been running for quite a few hours now and i dont really know if it is stuck in a loop or if it is just taking too long read/execute queries. Is there a way to find out what is the status of the procedure? or what it is currently doing?
I looked at views like v$sessions or v$session_longops but they dont actually tell me what it is currently doing. All of them just point to the call to the pl/sql procedure. Also, is it possible to look at the physical files on the filesystem to know if there is actually any processing going on and files are being written to? Is this possible or a files written to only after a commit?
CREATE TABLE stud(id number,Status CHAR(1))
INSERT INTO stud values(10,'Y')
INSERT INTO stud values(10,'Y')
INSERT INTO stud values(10,'Y')
INSERT INTO stud values(10,'N')
[code]...
ID STATUS
10 Y
10 Y
10 Y
10 N
20 Y
[code]...
I want to display the out put the IDs which are having the status both 'Y' and 'N'The output should be
ID STATUS
10 Y
10 Y
10 Y
10 N
20 Y
20 N
20 N
We are upgrading 10.2.0.4 enterprise edition single instance to 11.2.0.3 enterprise edition single edition manually. What should the listener status while doing upgradation. This is my first upgradation project.
View 5 Replies View Relatedcreate a procedure that will update the column status from active to closed after every two years.
View 4 Replies View RelatedQuestion:
How to find out the status of the import job(how much work is done, ETA), i have started the job few days back it still running on the server. i am using import not datapump, because i got the dump which took with export. DB version is 11.2.0.2.0
for datapump i know i can use the following queries, but these are not giving any output l think these are only for datapump
select sid, serial#, sofar, totalwork from v$session_longops;
select sid, serial# from v$session s, dba_datapump_sessions d where s.saddr = d.saddr;
I am manually committing the form by writing commit statement in key - commit trigger for some reason.
Everything is working fine. I want to display a message if some necessary fields are not filled properly, like if a user filled half table and mistakenly he press the commit button. Here I want to show him a message that you can't saved the data because the table is not completely filled.
create table test_exp (oid number, ioid number, status varchar2(20));
Below are the insert statements.
Insert into TEST_EXP (OID, IOID, STATUS) Values (1, 100, 'NEW');
Insert into TEST_EXP (OID, IOID, STATUS) Values (1, 101, 'DISCO');
Insert into TEST_EXP (OID, IOID, STATUS) Values (1, 102, 'CANCELLED');
Insert into TEST_EXP (OID, IOID, STATUS) Values (2, 103, 'NEW');
Insert into TEST_EXP (OID, IOID, STATUS) Values (3, 104, 'DISCO');
Insert into TEST_EXP (OID, IOID, STATUS) Values (4, 105, 'DISCO');
Insert into TEST_EXP (OID, IOID, STATUS) Values (4, 106, 'NEW');
Insert into TEST_EXP (OID, IOID, STATUS) Values (5, 107, 'NEW');
Insert into TEST_EXP (OID, IOID, STATUS) Values (5, 108, 'CANCELLED');
[code]...
Now my problem is we should fetch the data based on the below rules
If an OID contains 2 IOIDs for which there is a NEW and DISCO status attached, then fetch the 2 records
If an OID has only 1 of these status, then ignore the same
If an OID has none of the 2 status, then ignore the same.
The expected output will be like below:
OID|IOID|STATUS
1 |100 |NEW
1 |101 |DISCO
4 |105 |DISCO
4 |106 |NEW
If a session runs a query, the status will be inactive after completing the database call. I know this concept. But I just want to know what will be session status, if it running a procedure contains many select queries, DML quries and loop? Whether it will be active until procedure completes or it will be switching active and inactive?
View 3 Replies View RelatedI was working with forms and found a problem related to accessing of status of checkbox. In a block with multi record to be checked, if we want to check all the checkbox status which is already clicked, Then what should i do.
Now i am using the function Checkbox_check as:
if Checkbox_Checked('FVA.STATUS')
But the problem with this function, it is giving status of last clicked checkbox only.
How to verify if the backups are successfully completed in RAC environment ?
View 9 Replies View RelatedI want to select the IDs which have no IN or PLANNING status in AREA 9
ID 1 has AREA 9 and STATUS IN so dont select
ID 2 SELECT
ID 3 has area 9 BUT STATUS is OUT so Select.
So if an ID has has IN or PLANNING status in AREA 9 i do not wish to see it!
CREATE TABLE DAN_T1
(
ID varchar(8),
AREA varchar(8),
UNIT varchar(8),
STATUS varchar(8)
)
INSERT INTO DAN_T1 (ID,AREA,UNIT,STATUS) VALUES (1,6,'AA','IN');
[code]......
ID AREA UNIT STATUS
16AAIN
17ABPLANNING
17ACOUT
19ADIN
25ACIN
25AAOUT
35BAPLANNING
36DAIN
35CAIN
39CGOUT
WANT:
ID
2
3
i have created a fast refresh materialized view but it is not performing any refresh.Then i have checked my materialized view capabilities in mv_capabilities_table i got a message that" materialized view log is newer than last full refresh".
View 3 Replies View RelatedI need to pull most recent status from a table with date field in the case statement.
status date
1 08/28/2013
2 05/12/2-13
3 02/11/2013
I need the status result of 1 (i.e most recent) and have to do in case statement only. Not interested in the date field in the final result.
I have This output
GROUP#STATUSTYPE MEMBERIS_RECOVERY_DEST_FILE
1 ONLINE E:orcl_FILESorclREDO21.LOGNO
1 ONLINEE:orcl_FILESorclREDO11.LOGNO
1 ONLINEE:orcl_FILESorclREDO31.LOGNO
2 ONLINEF:orcl_FILESorclREDO12.LOGNO
2 ONLINEF:orcl_FILESorclREDO22.LOGNO
2 ONLINEF:orcl_FILESorclREDO32.LOGNO
3 ONLINEQ:orcl_FILESorclREDO23.LOGNO
3 ONLINEQ:orcl_FILESorclREDO13.LOGNO
3 ONLINEQ:orcl_FILESorclREDO33.LOGNO
GROUP#MEMBERSSTATUSARCHIVED
1 3UNUSEDYES
2 3CURRENTNO
3 3UNUSEDYES
when perform this both select
SELECT GROUP#, MEMBERS, STATUS, ARCHIVED FROM V$LOG;
select * from v$logfile;
Why the status values is null in the first select and how i can update the status. in the second select How I can Update the status of group 1 of redo log to current Value and i need to shutdown the database to update status.