The target area <location_of_oraInventory> is being written to by another session. A read lock cannot be obtained.
Solution
check your user permission :
sudo chown your_user -R your_oracle_home_path
check your disk space
might be your disk space is fulls fill and can not write some file
it works for me!!!
Hi . . . . i wanna share something 4 yaa. . .
at first, i knew this band from my local TV chanel . . .
and i’m going to download this band’s music
but unforunatly i just forgot what’s the Title???
i’m browsing and browsing and browsing again
and finally i got the band’s name and the title for the song
here it’s Boyz ii Man – One Up for Love
i ve no word to explain . . . . but awsome!!!
enjoy the music!
httpv://www.youtube.com/watch?v=NUOlrg2p6II
This section describes how to remove the Oracle HTML DB schema, synonyms, and users from the database without deleting the database.
Open SQL*PLUS and connect as privileged user SYS as SYSDBA
sqlplus sys as sysdba
Execute the following commands:
ALTER SESSION SET CURRENT_SCHEMA = flows_010500;
EXEC wwv_flow_upgrade.drop_public_synonyms;
ALTER SESSION SET CURRENT_SCHEMA = SYSTEM;
DROP USER flows_010500 CASCADE;
DROP USER flows_files CASCADE;
DROP USER htmldb_public_user CASCADE;
done!!
and now your Html DB schema has removed from your database.
🙂 seeeee U!
I ve a problem about remind my APEX admin’s password . . . .
It has along time since i installed my APEX and now,
i need my APEX to develop some Oracle program under web base.
Unfortunately, i’m forgot it . . . i m losing my admin’s password . . .
And good news is. . . . You know what?? i ve a trick to get my admin’s password back.
i try to reset APEX’s password and i ve succeed
let’s check it out here ::
following step by step >>>
1. Connect sys as sysdba
sqlplus sys as sysdba
2. Collect the information of the FLOWS% schema
select username,password,account_status from dba_users where username like ‘FLOW%’;
USERNAME PASSWORD ACCOUNT_STATUS ---------------- ------------------ ---------------- FLOWS_030000 240C2BE199B3DB1F LOCKED -------
3. Unlock the latest FLOWS% schema
alter user FLOWS_030000 account unlock;
4. Change the Password of FLOWS_030000
alter userFLOWS_030000 identified by mypass
conn FLOWS_030000/mypass
connected
5. Create user in Internal Workspace
BEGIN
wwv_flow_api.set_security_group_id(p_security_group_id => 10);
wwv_flow_fnd_user_api.create_fnd_user
(p_user_name => ‘adminq’
,p_email_address => ‘tikusrat@yahoo.com’
,p_web_password => ‘adminq’
);
END;
/PL/SQL procedure successfully completed.
commit;
Commit complete.
6. Open the applications, and Login to Internal Workspace with your new user :
http://your_ip:your_port/pls/htmldb
Login :
– Workspace : Internal
– Username : adminq
– password : adminq
and done!!!
and now you just need to enjoy your coffee and relax!!!
thanks for coming, have a nice day and seee yaaaaa!!!
#source : http://levicorp.com/2010/07/02/how-to-reset-password-in-apex/
Howyaaa friends , , , , ??? 😛
Aha Did U know some thing about ICS (Internet Connection Sharing) ?::
Yeah . . . . it was confused me.
Crossed in my mind i could not do that.
But my mind was wrong.
I could do that and fortunately i have succeed.
it just simple . . . . .U just need to share your smart modem connection and done! 😀 :
for more detail,
follow this step by step below :
1. Connect your smart phone till your EVDO Modem connected
2. Share your EVDO Modem with
*Open EVDO Data card Property>>Advanced >> Mark on “Internet Connection Sharing” to “Allow other network users…..”
*on the “Home networking connection” choose “Local Area Connection”
*And it should automatically change your IP address with “192.168.0.1”
* To share Internet Conection with your client use 192.168.0.1 for ip Gateway
or you can change it with your own subclass ip.
with default configurations :
Setting your client ip address between 192.168.0.2 till 254
use 192.168.0.1 for clients Default gateway
fill the DNS server addresses with yours
and your clients have already connected with internet connection
thanks for watching,have a nice day and seeeee yaaaa!!!!!
. . . . What’s exactly timer function is???
Timer function is kind of trigger that U can use to running your plSql prosedure by timer.
We can create timer function on the all levels of trigger.
And,……on CREATE_TIMER function has three parameters property :
timer name
timer time
timer process
and on “timer process” has 2 parameters :
REPEAT
and
NO_REPEAT
1. Create XTIMER procedure as below :
PROCEDURE XTIMER IS
timer_id TIMER;
timer_interval NUMBER := 1000;
BEGINtimer_id := CREATE_TIMER(‘timerq’,timer_interval,REPEAT);
END;
2. Create WHEN-NEW-FORM-INSTANCE trigger on the form level
3. Put XTIMER; procedure on WHEN-NEW-FORM-INSTANCE
4. Create WHEN-TIME-EXPIRED trigger on the form level too
(Put PLSQL function here to execute PLSQL functions when time has expired)
Descriptions :
On the “time_interval NUMBER :=1000;”
it means 1000 as 1 second
hi i ve something 4 U . . . .
it just simple to do . . . . . .
1. Create item and set property “sound”
2. Put the code below on when_button_pressed
Go_Item(‘your_sound_item_property‘);
Read_Sound_File(‘path_of_your_waves_file‘, ‘WAVE’, ‘your_sound_item_property‘);
Play_Sound(‘your_sound_item_property‘);
mine
Go_Item(‘top_bar.playx‘);
Read_Sound_File(‘E:bird_hawk.wav‘, ‘WAVE’, ‘top_bar.playx‘);
Play_Sound(‘top_bar.playx‘);
and done . . . . .
U can develop this, as long as U can do . . . . might be some alarms, thats U can use trigger by timer . . . or some thing else
hope that was worth 4 expand your knowledge . . .
that s a wrap to day . . . . seeee yaaaa!! 🙂
hi i ve some thing 4 U. . . . .
that’s nice to share something with some one and hope it’s going to help U . . . .
it calls
yeah it some functions to describe number to character in indonesian currency . . . . it should like “dua ribu rupiah” seribu limaratus rupiah . . .
end else . . . . . and U can use oracle_terbilang functions here : Continue reading
Ok . . . . i ve a simple way How to install Oracle Designer 6i Repository . . . .
1. download my designer.sql file here :
2. run the file as sys dba privilege :
sqlplus sys as sysdba
SQL*Plus: Release 10.2.0.1.0 – Production on Sat Mar 10 13:01:45 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL>
and run the sql file with :
SQL>@designer.sql
wait the generate process until finish . . . . after all preparation, log into your designer 6i with :
user : designer
pass : password
3. Go to Repository Administration Utility >>
configure your designer repository with
*DESIGNER,
*DESIGNER_INDEX,
*DESIGNER_TEMP tables space
and then?? start installation!!!
It should need very long time to wait installation progress . . . .
So, have a time to make a glass of coffee
after finished the installation . . . . . .
enjoy design your table . . . !!!
#i’m using :
ORA-01654: unable to extend index SYS.I_FILE#_BLOCK# by 128 in tablespace SYSTEM
Check the size and maxsize of the data files in the SYSTEM tablespace
select file_name, bytes, autoextensible, maxbytes
from dba_data_files
where tablespace_name=’SYSTEM’;
Increase the size of the data file;
alter database datafile ‘<Path to data file>’ resize <larger size>
#http://www.markcallen.com/oracle/ora-01654-unable-to-extend-index
ice cream gear 