AskDBA.org Forum » Forum: Database Administration

AskDBA.org Forum » Forum: Database Administration - Recent Topics http://www.forum.askdba.org/ Forum for Oracle DBA's en Sat, 11 Feb 2012 12:58:40 +0000 Amit Bansal on "User Registrations" http://www.forum.askdba.org/topic/user-registrations#post-299 Wed, 16 Nov 2011 04:02:10 +0000 Amit Bansal 299@http://www.forum.askdba.org/ To tackle lot of spam being generated on this forum, I have modified the user registration process. Now when a user registers, he/she will not get immediate login and it will be stored in a moderation queue. Only once moderators approve, user will be able to login. In case registration is not approved for some time or password is not working, then send mail to <a href="mailto:amit.bansal@askdba.org">amit.bansal@askdba.org</a> kyrool on "Problem Tracing Data" http://www.forum.askdba.org/topic/problem-tracing-data#post-277 Fri, 28 Oct 2011 11:11:57 +0000 kyrool 277@http://www.forum.askdba.org/ Hi, I just doing final year project, I just want to know from your opinion, what is problem you are facing when tracing data from audit trail? kyrool on "Database Security" http://www.forum.askdba.org/topic/database-security#post-282 Mon, 31 Oct 2011 03:06:57 +0000 kyrool 282@http://www.forum.askdba.org/ Hi, What type of security can implement in database level? orabcn on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-217 Tue, 28 Jun 2011 12:33:30 +0000 orabcn 217@http://www.forum.askdba.org/ Hello, I need your advice about a project I am doing now: I have 7 RAC 11gR2 nodes on Redhat Linux. We are backing up the database (one instance node) using incremental updated backups via RMAN, and then we move the backups to tape. I autobackup the controlfile and spfile with RMAN and my retention window is 60 days. I am also, running md_backup every night to backup ASM metadata. until now everything is ok. But, what happens if I completely loose the 7 nodes RAC? if all the servers are down and completely lost? I am backing up the archive log files also using RMAN. My database is in archivelog mode and block change tracking is enabled also, I am using control file instead of recovery catalogue. And, I am saving the DBID of the instances. And I am backing up the FRA to tape. I have to think about the best, easier solution to restore from tapes and then restore/recover my database (database + ASM) to a dedicated single instance on a separated server located in another data center. could you share your experience and advice the step by step of doing it? thank you Ashish on "Pre Installation Reqrtment" http://www.forum.askdba.org/topic/pre-installation-reqrtment#post-207 Sat, 11 Jun 2011 17:58:09 +0000 Ashish 207@http://www.forum.askdba.org/ kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default=262144 net.core.rmem_max=262144 net.core.wmem_default=262144 net.core.wmem_max=262144 oraraj on "package running slowly" http://www.forum.askdba.org/topic/package-running-slowly#post-204 Thu, 09 Jun 2011 05:05:43 +0000 oraraj 204@http://www.forum.askdba.org/ Hi, We have a unix script which calls a package and that in turns loads 2 materialzed views. For the past 2 months the job is exceeding the normal loading time...It was running for 3 to 4 hrs initially and now it is running for 9 to 10 hrs. I am a developer and I want to know what are the measures that I can do from my end in order to first find out what is the reason why it is taking long time. The log does not say anything since this is a package. Thanks daniesh on "RMAN Backup" http://www.forum.askdba.org/topic/rman-backup#post-190 Mon, 20 Dec 2010 13:04:15 +0000 daniesh 190@http://www.forum.askdba.org/ Hi, I am a bit confused. When we take a rman backup.Suppose the rmnan backup is in progress. At the same user is executing any update query and the update query is in progress and he has not committed. What will happen internally in this case like the transaction which is in progress will get backed up or the oracle will wait for the transaction to get committed after that it will backed up the transaction. If the update query ia taking 4-5 hrs to get complete. what will happen is this case. Your views on this is much appreciated. Thanks and Regards, Dan Ajgarcia11 on "Upgrade Oracle Database 10.1 to 11g" http://www.forum.askdba.org/topic/upgrade-oracle-database-101-to-11g#post-203 Thu, 10 Mar 2011 12:27:08 +0000 Ajgarcia11 203@http://www.forum.askdba.org/ A client has some applications developed in. NET running on an Oracle database version 10.1, and want to know the impact is to make the upgrade to version 10.2 and / or 11g. The idea is to get a guideline of things that will not work, or will have to be revised / modified, etc. Now, if the jump is from 10.1 to 11g, there may be an issue because older versions of Oracle worked for Rules (and still holding potential for 10), newer versions now working for Costs (11g only works for costs .) So depending on how the current basis are 10.1 (Rules or costs), the upgrade may be more transparent, or review the queries require that the costs you can change rules by having a big performance problem. faizal on "stop listener but permission is denied" http://www.forum.askdba.org/topic/stop-listener-but-permission-is-denied#post-202 Wed, 09 Mar 2011 08:40:58 +0000 faizal 202@http://www.forum.askdba.org/ Hi , I have created two dbs(many instances) , the first db ive created, i have brought up the listener first.But the second one I have not. The first db I have created can also stop the instance one the 2nd db. Please help where I stumbled. Here is the scenario: [oraisuztxn@scymesstg2 tmp]$ lsnrctl stop LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 09-MAR-2011 16:30:41 Copyright (c) 1991, 2008, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) The command completed successfully [oraisuztxn@scymesstg2 tmp]$ lsnrctl stop LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 09-MAR-2011 16:31:18 Copyright (c) 1991, 2008, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) TNS-01190: The user is not authorized to execute the requested listener command Peter P on "Orcale 11g and Solaris Containers/Zones" http://www.forum.askdba.org/topic/orcale-11g-and-solaris-containerszones#post-198 Tue, 15 Feb 2011 09:38:22 +0000 Peter P 198@http://www.forum.askdba.org/ Hi everyone, We are looking at using Solaris 10 Containers on a Sun M4000 to create a discrete database zone allocating one of the two CPUs to this zone. (The plan is to install Oracle 11g into this zone and deploy the other application components across a number of other Sun boxes.) Has anyone else experience of containers/zones and are there any issues or concerns with these when running an Oracle Database? Amit Bansal on "NO SPAM Entertained on this forum" http://www.forum.askdba.org/topic/no-spam-entertained-on-this-forum#post-167 Tue, 29 Jun 2010 12:58:47 +0000 Amit Bansal 167@http://www.forum.askdba.org/ Hi All, For past few days, I am observing spam ( some exams site) posting content on the forum. Tried deleting the content for 2-3 times so that concerned person desist from doing again but I have today finally deleted the user. Any kind of spam will not be entertained on this forum. Regards Amit dinilocp on "ORA-16055" http://www.forum.askdba.org/topic/ora-16055#post-86 Fri, 11 Sep 2009 07:18:15 +0000 dinilocp 86@http://www.forum.askdba.org/ how can we solve this error: regularly comes in alertlog file of primary database: ora-19502 write error on file"",blockno(blocksize=) ora-16055: FAL REQUEST REJECT Arch: FAL Archive Failed,Archiver continuing. Database : 10g RAC with two nodes. egotah on "Datapump dumpfile with dates" http://www.forum.askdba.org/topic/datapump-dumpfile-with-dates#post-148 Thu, 13 May 2010 20:05:34 +0000 egotah 148@http://www.forum.askdba.org/ Can some one direct me how to generate Datapump Export Dump with Dumpfile name Containing Current Date and Time. I tried this format with error.. dumpfile=myexport-<code>date '+%d%m%Y_%H%M%S'</code>.dmp logfile=myexport-<code>date '+%d%m%Y_%H%M%S'</code>.log Mahesh.G on "DR rebuild- Data restore issue" http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-131 Wed, 10 Mar 2010 11:27:43 +0000 Mahesh.G 131@http://www.forum.askdba.org/ Hi Experts, While doing DR rebuild ( physical standby ), after restoring standby controlfile in DR location, i am getting below error while restoring database. I took backup through RMAN ( hotbackup ) from primary database. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/10/2010 11:58:32 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 28 found to restore RMAN-06023: no backup or copy of datafile 27 found to restore I tried the below options :- 1. Duplicate command :- while using duplicate command also i got the same error 2. " catalog backuppiece " of all backup pieces copied from primary database. 3. I used restore with set until time option also but no luck. In all cases i got same error. How can i restore primary database backup in DR ? Pls help. Mahesh wesguez on "OS Memory issue" http://www.forum.askdba.org/topic/os-memory-issue#post-127 Mon, 22 Feb 2010 19:44:02 +0000 wesguez 127@http://www.forum.askdba.org/ I am having a issue of OS memory crunch.The sever has 16Gb RAM, and hosts 2 db.The total sga+pga combined is ~10.5GB.For one of the database, i see in TOP command, RES column values like 1100M,1245M , though these sessions are inactive and the logon_time is of 9th Feb.The sessions are also having open_cursor.Can this is a bottleneck?Can snipping these sessions be useful? How to find why the cursor is still open for a session.I have a session with a logon date on 29-JAN-2010, which is INACTIVE and has 1 open_cursor.This session is having the maximum cpu usage,though inactive.How do i go ahead for analyzing it. waiting for your response. rtskrajan on "Database Hang" http://www.forum.askdba.org/topic/database-hang#post-124 Tue, 26 Jan 2010 11:14:23 +0000 rtskrajan 124@http://www.forum.askdba.org/ Hi experts, My server ram is 12GB. i installed 10r2 and implemented /3GB also. Eventhough my database is giving problem. Could you please give some valuable advice. Thanks. pratheep on "Database shutdown hangs." http://www.forum.askdba.org/topic/database-shutdown-hangs#post-122 Wed, 20 Jan 2010 04:25:12 +0000 pratheep 122@http://www.forum.askdba.org/ Hi, One of my production database shutdown process hangs every planned shutdown. (Both shutdown immediate and abort options). Database version & OS : 10.2.0.4 on SuSe Linux 10 SP2, All the latest patches, cpus installed. Some of the active database server process are preventing the database from shutdown. I tried to kill the process from OS root user also. But the process are not closing. When I check ps command the process are in 'D' state (uninterruptable sleep). For the particular pid, strace command also stuck. As I verified in v$session before shutdown immediate there is no active sessions or jobs in database. But above mentioned "D" state pid's are exist in v$process. Please suggest me, how to find the history of the process.? like when it is hanged/which session id/which sql statement caused that..? Thank you all, Pratheep nhameed on "SYSASM not granted to sys." http://www.forum.askdba.org/topic/sysasm-not-granted-to-sys#post-118 Sat, 09 Jan 2010 10:22:15 +0000 nhameed 118@http://www.forum.askdba.org/ I have upgraded 10 RAC database to 11g rac, now I cannot connect to ASM instance, in v$pwfile_users, sys dont have SYSASM privilege. How can I manually grant this privilege to SYS user. Saurabh Sood on "RMAN-05001 While Using RMAN Duplicate" http://www.forum.askdba.org/topic/rman-05001-while-using-rman-duplicate#post-102 Thu, 22 Oct 2009 10:40:58 +0000 Saurabh Sood 102@http://www.forum.askdba.org/ RMAN-05001 can occur while cloning if: 1. The target server have same directory structure as of the source i.e you have to use something like: db_file_name_convert=("/u01/app/oracle/1020/","/u01/app/oracle/1020/") and while issuing: RMAN > duplicate target database to aux; RMAN-05001: auxiliary filename /u01/app/1020/fact01.dbf conflicts with a file used by the target database SOLUTION: ========= Use "NOFILENAMECHECK" clause as: RMAN > duplicate target database to aux NOFILENAMECHECK; Cheers!!! Saurabh Sood alok on "Exclude parameter in Import Script??" http://www.forum.askdba.org/topic/exclude-parameter-in-import-script#post-88 Wed, 16 Sep 2009 07:23:52 +0000 alok 88@http://www.forum.askdba.org/ Hi All, I am a junior oracle dba. I know this is one is easy for you all. Just wanted to know whether we can exclude the tables, which we dont want to have the import of? I mean, i have a dump file *.dmp by export script on production db. I have copied the dump file to our development db. There are almost 300 tables in the *.dmp file and i want to exclude some 20 to 25 tables from the dump file. Is it possible to using any EXCLUDE parameter in the import scrip that would exclude the tables. Our db is oracle 9i. Hope i wud get a quick reponse from you guys :) y4chtmaster on "Does such a script exist" http://www.forum.askdba.org/topic/does-such-a-script-exist#post-63 Tue, 09 Jun 2009 18:18:01 +0000 y4chtmaster 63@http://www.forum.askdba.org/ Is there a script that will alert a DBA if a database has been in backup mode for a specified period of time. (Ex. 1 hr, 2hr, etc...) that can be registered in OEM as an alert. JuanCarlosDoohan on "Oracle RAC with many versions" http://www.forum.askdba.org/topic/oracle-rac-with-many-versions-1#post-71 Tue, 14 Jul 2009 09:27:04 +0000 JuanCarlosDoohan 71@http://www.forum.askdba.org/ Hi wisers, I have a project implementation with oracle RAC, the necessities are, Oracle 8, oracle 9 and Oracle 10, because we have deferents front ends, But we need considerate make this implementation in oracle rac, I think that, the solution is oracle rac in virtualization, but yours have another propose, Best regards, Juan Carlos daniesh on "CPU patch and catcpu.sql" http://www.forum.askdba.org/topic/cpu-patch-and-catcpusql#post-58 Tue, 17 Mar 2009 06:58:03 +0000 daniesh 58@http://www.forum.askdba.org/ Hi , I know that I can found this answer on website also however want to clear some of my doubts related to CPU patch and catcpu.sql. I need to know when we need to apply the cpu patch why we need to execute the script catcpu.sql after applying the cpu patch. we catpu.sql when we migrate the database from 9.2.0.6 to some other 9i version. can you please help me in clearing my doubts. Thanks and Regards, Daniesh Anonymous on "Reg Oracle Streams Implementation.." http://www.forum.askdba.org/topic/reg-oracle-streams-implementation#post-56 Tue, 10 Feb 2009 19:41:19 +0000 Anonymous 56@http://www.forum.askdba.org/ --I need to create streams in a single database but between diff schema's. --from schema1 to schema2 ,Then schema2 to schema3 and schema4. --schema1 has 500 table --schema2 has 500(need to replicate 150 tables) -schema3 has 90 tables --schema4 has 100 tables --Schema1 and Schema2 have same structure but i need to select only 150 tables out of 500 tables. --from schema2 to schema3 ,here also structure is same. But i need to replicate 90 tables in schema3 . --from schema2 to schema4 destination tables has extra columns.here iam using dml handlers. My ques are: I included DDL's. But they are not working. Please give me some idea in this situation. Thanks, Ray daniesh on "Adding datafile" http://www.forum.askdba.org/topic/adding-datafile#post-47 Mon, 12 Jan 2009 10:19:48 +0000 daniesh 47@http://www.forum.askdba.org/ Hi All, I need to make two database into one. I have two prod databases esgprod eagprod. the client want to make to merge both the databases. Could you please suggest me the steps? Thanks daniesh on "clone database using Hot backup" http://www.forum.askdba.org/topic/clone-database-using-hot-backup#post-39 Mon, 24 Nov 2008 09:09:57 +0000 daniesh 39@http://www.forum.askdba.org/ Hi , I am an Oracle DBA. I am cloning the development database from production. I have some dount. while cloninng the database using hot backup. do we need to copy redo log to the target location. I am getting an error. I am done with the creation of control file but i have not copied the online redo log file. do i need to do copy it manually. Thanks in advance. Daniesh devkakkar on "Oracle 10g installation with 4GB RAM" http://www.forum.askdba.org/topic/oracle-10g-installation-with-4gb-ram#post-37 Fri, 21 Nov 2008 12:02:38 +0000 devkakkar 37@http://www.forum.askdba.org/ Hi, I have HP DL 380G5 Series Server, RAID 5, 4GB RAM, DUAL QUAD CORE XEON PROCESSOR( 8 CPU COUNTS) with WINDOWS 2003 ENT. I want to install Oracle 10g R1 on this server. Please help me to address memory configruation in a proper manner like using /3GB /PAE switches as OS level and configuring SPFILE/PFILE. Best Regards, DK SERDAR on "ORA-01013: user requested cancel of current operation" http://www.forum.askdba.org/topic/ora-01013-user-requested-cancel-of-current-operation#post-33 Thu, 13 Nov 2008 16:08:04 +0000 SERDAR 33@http://www.forum.askdba.org/ Hi, I use stopdb to close database.I get error ORA-01013: user requested cancel of current operation in alert log.Some active sessions prevents to close database how can I solve this problem My platform is IBM AIX 5L. alancdavis on "Oracle 11g install performance on Sun T5220" http://www.forum.askdba.org/topic/oracle-11g-install-performance-on-sun-t5220#post-31 Wed, 12 Nov 2008 04:50:01 +0000 alancdavis 31@http://www.forum.askdba.org/ I'm installing our first production RAC servers and am flummoxed by how long it's taking to install the db instance using dbca. It takes more than 3 hours to install from the Custom setup in dbca on a 64gb machine using 2gb FCA's to 800gb of ASM storage on an HP EVA SAN array. Any thoughts on why it would take so long? Thanks! ramaral on "Audit SELECT" http://www.forum.askdba.org/topic/audit-select#post-28 Tue, 28 Oct 2008 12:17:21 +0000 ramaral 28@http://www.forum.askdba.org/ How to Audit select's in the database 10g Standard. FGA does not work and triggers only for insert, delete, update. aniruddharp on "Rman duplicate with cold backup" http://www.forum.askdba.org/topic/rman-duplicate-with-cold-backup#post-24 Mon, 29 Sep 2008 18:00:50 +0000 aniruddharp 24@http://www.forum.askdba.org/ Hi, I am trying to clone a database with rman duplicate command.But here I am trying to use Rman backup taken when database was in MOUNT stage.So it's a cold backup. When I am trying to issue duplicate command with this backup it's throwing an error " RMAN-06023:NO BACKUP OR COPY OF DATAFILE 7 FOUND TO RESTORE ". This is happenning with all datafiles in the backup. List backupset command shows me proper and expected results. Note : I am using nocatalog approach for target database backup. Is this not supported in duplicate database command? -Ani monash_aus on "Error while creating of Snapshot" http://www.forum.askdba.org/topic/error-while-creating-of-snapshot#post-9 Wed, 20 Aug 2008 08:23:16 +0000 monash_aus 9@http://www.forum.askdba.org/ Hi, I am trying to create a snapshot in a different schema to that of base table.I have required privileges to create a snapshot on the base tables. The following error occurs when I try to create snapshot with the below syntax. Error: --------- ORA-12018: following error encountered during code generation for "SWCWQTOOL"."RT_DISTSYS" ORA-00942: table or view does not exist Syntax ----------- CREATE SNAPSHOT snapshot1 REFRESH FAST START WITH SYSDATE NEXT SYSDATE+1/24 AS SELECT * FROM table1. But I can query the table1 and view the data. admin on "Ask A Question" http://www.forum.askdba.org/topic/ask-a-question#post-2 Thu, 12 Jun 2008 12:37:46 +0000 admin 2@http://www.forum.askdba.org/ Hi All, You can use this forum for asking any Oracle Database related Questions you might have. We will try our best to clarify your doubts.