DBAsupport.com Forums http://www.dbasupport.com/forums/ This is a discussion forum for all issues involved in databases and database development. en Mon, 20 May 2013 16:59:36 GMT vBulletin 60 http://www.dbasupport.com/forums/images/misc/rss.png DBAsupport.com Forums http://www.dbasupport.com/forums/ Emd_notification.queue_ready http://www.dbasupport.com/forums/showthread.php?62979-Emd_notification.queue_ready&goto=newpost Thu, 16 May 2013 19:21:49 GMT I have seen the DB activity spike occasionally, and when I look at the top sessions I see this running as sys man BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END; The software using the database doesn't appear to be effected (Users are not complaining during the high activity, and this is a user base were they complain over performance for everything else). When it happens it will kick me out of OEM. I have to restart the web browser and log back in. But if I check the status of dbconsole on the UNIX box is states hat it is still running the entire time. netstat shows the OEM port still listening. I did some google searching and found one site say it had to do with sys man not having execute rights to url_smtp and url_tcp, so I granted the rights but it still happened. The database is 10g and it is on a UNIX server. Can anyone give me some advise on resolving this issue, please. Thank you. ]]> Oracle Database Administration jayjabour http://www.dbasupport.com/forums/showthread.php?62979-Emd_notification.queue_ready Sql script that compares two db,s and updates db and insert date of update http://www.dbasupport.com/forums/showthread.php?62977-Sql-script-that-compares-two-db-s-and-updates-db-and-insert-date-of-update&goto=newpost Thu, 16 May 2013 14:46:20 GMT Hi i need some help creating an sql script that can update info from one table in dbase1 to another table in dbase2 that has the same columns and if posible insert date and time in one column when the syncronized is done? Can anyone help mee whit this? Hi i need some help creating an sql script that can update info from one table in dbase1 to another table in dbase2 that has the same columns and if posible insert date and time in one column when the syncronized is done? Can anyone help mee whit this? ]]> Oracle Database Administration miguel_q http://www.dbasupport.com/forums/showthread.php?62977-Sql-script-that-compares-two-db-s-and-updates-db-and-insert-date-of-update Temp Usage http://www.dbasupport.com/forums/showthread.php?62975-Temp-Usage&goto=newpost Thu, 16 May 2013 11:26:31 GMT Hi, I am new to Database activities.Please advise how to check the temp usage and find the query causing that temp in oracle 9i Hi,

I am new to Database activities.Please advise how to check the temp usage and find the query causing that temp in oracle 9i ]]> Oracle Database Administration gargi http://www.dbasupport.com/forums/showthread.php?62975-Temp-Usage Re-create archive logs http://www.dbasupport.com/forums/showthread.php?62971-Re-create-archive-logs&goto=newpost Mon, 13 May 2013 18:40:52 GMT Hello,
10g Standard DB on RHEL 4. I'm wondering if there is a way to re-create or re-generate past archive logs?

Here's the story behind this question:
A few days ago one of my guys started the DB by manually specifying pfile (eg: startup open pfile=/u01/app/oracle/admin/dbs/pfile/init.ora). The problem with that is the pfile specified did not contain all the parameters that are in spfile, namely log_archive_dest_1. I noticed the problem about two hours later and got it restarted correctly, the problem I have now is a gap in archive logs, missing about 25 log files. This gap has caused a problem with applying the archive logs to my standby database. I tried replacing the standby with a newer backup that I assumed wouldn't care about the missing logs but it still is. So I'm wondering if there is a way to remake those arch logs that got skipped or do I need to do an OPEN RESETLOGS?

Thanks, ]]> Oracle Database Administration louie75 http://www.dbasupport.com/forums/showthread.php?62971-Re-create-archive-logs archives not shipping on standby http://www.dbasupport.com/forums/showthread.php?62969-archives-not-shipping-on-standby&goto=newpost Sun, 12 May 2013 07:33:52 GMT Hii all,

I am trying to configure physical standby. Everything was fine but at the end i found that archives from primary db are not shipping to standby..Networking is fine.

Here is the production p file.

db_name=manish
db_unique_name=manish1
#service_name=manish1
remote_login_passwordfile=exclusive
shared_pool_size=102341017
db_block_size=8192
diagnostic_dest=/disk1/oradata/manish
undo_tablespace=undotbs
undo_management=auto
control_files = /disk1/oradata/manish/control.ctl
compatible ='11.2.0'
###################Data guard PARAM's###################
log_archive_dest_1='location=/disk1/oradata/manish/arch
valid_for=(all_logfiles,all_roles)'
log_archive_dest_2='service=stand
valid_for=(online_logfiles,primary_role)
db_unique_name=stand1 lgwr sync affirm reopen=10'
standby_archive_dest=/dsik1/oradata/manish/arch
standby_file_management=auto
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
fal_server=stand
fal_client=manish

here is my standby's p file

db_name=manish
db_unique_name=stand1
remote_login_passwordfile=exclusive
shared_pool_size=102341017
db_block_size=8192
diagnostic_dest=/disk1/oradata/manish
undo_tablespace=undotbs
undo_management=auto
control_files = /disk1/oradata/manish/stand.ctl
compatible ='11.2.0'
###################Data guard PARAM's###################
log_archive_dest_1='location=/disk1/oradata/manish/arch
valid_for=(all_logfiles,all_roles)'
log_archive_dest_2='service=manish lgwr sync affirm reopen=10'
standby_archive_dest=/dsik1/oradata/manish/arch
standby_file_management=auto
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
fal_server=manish
fal_client=stand


archive log list (primary)

archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /disk1/oradata/manish/arch
Oldest online log sequence 198
Next log sequence to archive 199
Current log sequence 199


archive log list(standby)

archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /disk1/oradata/manish/arch
Oldest online log sequence 178
Next log sequence to archive 179
Current log sequence 179

Please help me to get through this ...
Thanks :cool: ]]> Oracle Database Administration manish.sharma http://www.dbasupport.com/forums/showthread.php?62969-archives-not-shipping-on-standby Recover Oracle datafile http://www.dbasupport.com/forums/showthread.php?62967-Recover-Oracle-datafile&goto=newpost Thu, 09 May 2013 13:33:55 GMT Hi all,
unfortunately my hard disk's server crashed, and I do not have any backup,
I recovered oradata folder in crashed hard disk, which is contains DBF, Ora and log files as attachment picture.
My Oracle database version is 10.2.
would you please guid me how can I recover my databse step by step?
Attached Images
]]> Oracle Database Administration saber_talas http://www.dbasupport.com/forums/showthread.php?62967-Recover-Oracle-datafile stored procedure http://www.dbasupport.com/forums/showthread.php?62965-stored-procedure&goto=newpost Wed, 08 May 2013 09:14:00 GMT hi
my Recquierment is I have an 100's of records in my table in that i need to select some records based on Item_ID and that Item_ID records all are shoud come in One Temporary Table and based on this table Item_ID's i need to delete records in 4 child Tables....
After the deleting process ends then i should delete that temporary table....
This temporary table records i need to pass all StoredProcedures and delete as per conditions........
Please provide StoredProcedure For This requirement ]]> Oracle Development panduranga http://www.dbasupport.com/forums/showthread.php?62965-stored-procedure NESTED ERROR when making admin server a windows service http://www.dbasupport.com/forums/showthread.php?62963-NESTED-ERROR-when-making-admin-server-a-windows-service&goto=newpost Mon, 06 May 2013 14:25:55 GMT (Runtim eAccessImpl.java:149) at weblogic.management.provider.internal.RuntimeAccessService.start(Runt imeAccessService.java:41) at weblogic.t3.srvr.ServerServicesManager.startService(ServerServicesMan ager.java:461) at weblogic.t3.srvr.ServerServicesManager.startInStandbyState(ServerServ icesManager.java:166) at weblogic.t3.srvr.T3Srvr.initializeStandby(T3Srvr.java:881) at weblogic.t3.srvr.T3Srvr.startup(T3Srvr.java:568) at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:469) at weblogic.Server.main(Server.java:71) C:\Oracle\Middleware\wlserver_10.3\server\bin>]]> I created a script to make my admin server a windows service. I successfully made it a service but when it starts it then shuts itself down. i ran a debug and found a error. I dont get what to do. I have tried changing the variables in the script and try it over and over again .....here is my script code and here is the error i got from debug output:

script

SETLOCAL

set DOMAIN_NAME=FRClassicDomain

set USERDOMAIN_HOME=C:/Oracle/Middleware/user_projects/domains/FRClassicDomain

set SERVER_NAME=FRweblogic

set WLS_USER=FRweblogic

set WLS_PW=hidden

set ADMIN_URL=http://hidden:hidden

set JAVA_VENDOR=Sun

set JAVA_HOME=C:/Program Files/Java/jdk1.7.0

set PRODUCTION_MODE=true

set MEM_ARGS=-Xms512m –Xmx512m

call "C:/Oracle/Middleware/user_projects/domains/FRClassicDomain/bin/setDomainEnv.cmd"

call "C:/Oracle/Middleware/wlserver_10.3/server/bin/installSvc.cmd"

ENDLOCAL

my debug output:

...............

There are 1 nested errors:

weblogic.management.ManagementException: [Management:141223]The server name FRwe
blogic specified with -Dweblogic.Name does not exist. The configuration includes
the following servers {AdminServer,WLS_FORMS,WLS_REPORTS,FRasserver}.
at weblogic.management.provider.internal.RuntimeAccessImpl.(Runtim
eAccessImpl.java:149)
at weblogic.management.provider.internal.RuntimeAccessService.start(Runt
imeAccessService.java:41)
at weblogic.t3.srvr.ServerServicesManager.startService(ServerServicesMan
ager.java:461)
at weblogic.t3.srvr.ServerServicesManager.startInStandbyState(ServerServ
icesManager.java:166)
at weblogic.t3.srvr.T3Srvr.initializeStandby(T3Srvr.java:881)
at weblogic.t3.srvr.T3Srvr.startup(T3Srvr.java:568)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:469)
at weblogic.Server.main(Server.java:71)


te changed to FAILED>
te changed to FORCE_SHUTTING_DOWN>

C:\Oracle\Middleware\wlserver_10.3\server\bin> ]]> Oracle Applications DBA eortiz10 http://www.dbasupport.com/forums/showthread.php?62963-NESTED-ERROR-when-making-admin-server-a-windows-service INSERT statement http://www.dbasupport.com/forums/showthread.php?62959-INSERT-statement&goto=newpost Fri, 03 May 2013 05:39:36 GMT I'm trying to insert a values in a table, that has 3 columns. But I'm getting "ora-00984 : column not allowed here" - error. I've taken a value in w_total = 20865000 and executing
insert into temp_latepos values ('USD',w_total,0) in VB 6.0. Please help me resolve this issue.
w_total is the figure got by various calculations and cannot be the same every time. USD is always constant and 0 is also constant. ]]> Oracle Database Administration K PRASANNA http://www.dbasupport.com/forums/showthread.php?62959-INSERT-statement Datafile extend or add new file http://www.dbasupport.com/forums/showthread.php?62957-Datafile-extend-or-add-new-file&goto=newpost Thu, 02 May 2013 18:51:21 GMT I am a new oracle dba. I am concerned that one of the files is getting low on space. Running oracle 8i on AIX. Does the file automatically extend or does it create a new file? I think I have to create a new file, just not sure. Thanks;) I am a new oracle dba. I am concerned that one of the files is getting low on space. Running oracle 8i on AIX. Does the file automatically extend or does it create a new file? I think I have to create a new file, just not sure.

Thanks;) ]]> Oracle Database Administration char http://www.dbasupport.com/forums/showthread.php?62957-Datafile-extend-or-add-new-file Sequences out of sync http://www.dbasupport.com/forums/showthread.php?62953-Sequences-out-of-sync&goto=newpost Thu, 25 Apr 2013 20:39:52 GMT Hello everyone, is there a scriptable way of figuring out if the database sequences are out of sync?

We have almost 200 sequences and over 900 databases. Every once in a blue moon we have an application problem that takes us a few hours of trouble shooting to figure out that a sequence is out of sync. I fix the offending sequence but it always makes me wonder about the other 199 and we don't have time to check every one of them.

I have googled this a lot of times and have always came up empty handed which makes me think the answer is no but I wanted to ask just to be 100% sure.

Thank you for your help in advanced!
:o ]]> Oracle Database Administration StoneCold http://www.dbasupport.com/forums/showthread.php?62953-Sequences-out-of-sync Stats collection for upgrade to 11G http://www.dbasupport.com/forums/showthread.php?62951-Stats-collection-for-upgrade-to-11G&goto=newpost Mon, 22 Apr 2013 13:04:09 GMT Hi, I have a 10.2.0.5 database running on Windows Server x64bit that I want to move to 11G Linux SUSE10. I will be using export / import. Should I export the database stats from 10G and import into 11G ? Or will export / import take care of this ? Hi, I have a 10.2.0.5 database running on Windows Server x64bit that I want to move to 11G Linux SUSE10. I will be using export / import. Should I export the database stats from 10G and import into 11G ? Or will export / import take care of this ? ]]> Oracle Database Administration pascal01 http://www.dbasupport.com/forums/showthread.php?62951-Stats-collection-for-upgrade-to-11G