Jump to content

All Activity

This stream auto-updates     

  1. Yesterday
  2. Hi Satish and welcome to the forum! I have done this before, but these notes may help: https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1 Good luck!
  3. Last week
  4. I have installed Oracle 12cR2 on Linux (Oracle Linux 7.4). Also created one PDB in database. While doing PDBPIT recovery in LOCAL UNDO Mode, recovery is failing. However, PDB PIT recovery works fine in SHARED UNDO mode. Just to elaborate, I have created one PDB (say X) in database. Now I have changed UNDO mode to LOCAL UNDO for database and I have created one table ( say 'emp') in tablespace which belongs to my PDB X. Here, I took backup of this PDB X only. After that I logged into oracle database and removed the tablespace (using 'drop tablespace' command) from PDB X. Now, I am restoring database for earlier backup which contains earlier deleted tablespace which has table 'emp' . restore successes but when I try to see contents of table , i get below error- SQL> select * from emp; select * from emp * ERROR at line 1: ORA-00376: file 18 cannot be read at this time ORA-01111: name for data file 18 is unknown - rename to correct file ORA-01110: data file 18: '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/MISSING00018' fyi, 18 is datafile number which belongs to tablespace which i have deleted before restore. And Datafile for deleted tablespace is available in required directory. Can anyone please tell me what is the reason for PDB PIT recovery failure in LOCAL UNDO MODE only?
  5. @boobalganesan Hello boobal with t1 as (select 'A+++500+read++' col1 from dual) select regexp_count(substr(col1,1,regexp_instr(col1,'[^\+]+',1,regexp_count(col1,'[^\+]+'))-1),'\+') from t1; This queyr you gave for finding total count of '+' before last value..Here last value is 'read'.So with this query i got total count of '+' before 'read' as 4 which is absolutely right. It was a sample data which i provided u.But in my table data is like this.. '20005465+Mr.++++Delhi+0+Pune When i am running the same query for 'dual',then it works.But when i m running the same query for my real table,then i get error.:-''0 out of range''. Whats solution for this??Due to 0,query is not working.
  6. @boobalganesan You are right boobal.Output will be 1,4,5..For that i have built a procedure & got the result.
  7. I've highlighted the counts in your text. It says 1,4,5 and not 1,3,5. Thanks, Boobal Ganesan
  8. @boobalganesan Hello boobal Here we have to take count of '+' before each value...Before 'A',1 '+' is there,so it will give 1,before '500',total 4 '+' is there from sarting means including '+' before 'A' also,then total count of '+' before '500' will be 4 and total count of '+' before 'read' will be 5 which will include '+' before '500' also & '+' before 'A' also...means count of '+' before each value starting from the start. Then output will be 1,3,5
  9. Hi Sam, If input is "+A+++500+read++", the output will be 1 for "A", 3 for "500" and 1 for "read" isnt it? So the result will be 1,3,1. How are you expecting a result of 1, 3, 5 ? Thank you, Boobal Ganesan
  10. @boobalganesan Thanks boobal for you are response. Bt here 1,5,9 i m getting.I want the position of each value means at which position of '+',value occurs or in other words count of '+' before each value.Here data is 'A+++500+read++'...now i add one more '+' before 'A'..now data looks like '+A+++500+read++'.Now i want count of '+' before each value.Here 3 values namely 'A','500',read' is there.Now i want output as 1,3,5. A+++500+read++
  11. @Sam@11 Sorry for the delayed response Please find the query below. SELECT LISTAGG( regexp_instr( 'A+++500+read++', regexp_substr( 'A+++500+read++', '[^+]+', 1, level ) ), ',' ) WITHIN GROUP(ORDER BY ROWNUM) col1 FROM dual CONNECT BY level <= regexp_count( 'A+++500+read++', '[^+]+' ); The result is, 1,5,9 Oracle counts from 1, not 0. Thank you, Boobal Ganesan
  12. ORA-12170: TNS:Connect timeout occurred

    Hi Gvk, have you try to test your 1521 port on IP address if answer? telnet xx.xxx.xxx.xxx 1521 If the test is successfull then may be some antivirus. Bye
  13. I have ORACLE 12c running on Windows Server 2008 and Oracle client running on Windows 7 .I am able to connect to Oracle server locally i.e. on the windows server machine itself through Oracle SQL Developer as well as SQLPLUS. But I can't connect to Oracle 12c Running on windows server 2008 from Oracle client on windows 7. When I try to connect through Oracle SQL developer, it throws IO Error: The Network Adapter could not establish the connection.But there is connectivity between Server and client. I checked this with ping command. When I try to connect through SQLPLUS through command prompt, it throws error ORA-12170: TNS:Connect timeout occurred. I tried changing sqlnet.ora parameter but didn't work. Please, help me . Thanks oracle connection.odt
  14. Oracle Forms 11g db connectivity issue

    Hi, and welcome to the forum! It sounds like the problem is inside the sqlforms app, and not within the database engine. Try this sqlforms forum: https://community.oracle.com/community/development_tools/forms Good luck!
  15. We are facing issue while accessing master form in forms 11g. Generally, we have have a master form which requires DB credentials, which get successfully verified and the master form is displayed. ISSUE : --> Randomly the users who try to access this master form (the first form) are shown an applet/form window where it prompts user to enter the password of the database user, using which the form session establishes it's connection to the database. So this frustrates the user, because obviously you can't expect a user or anyone to view a login prompt asking password of that particular DB user. Attached document will help everyone understand better. Since we are approaching month end, it will be fantastic if someone can come up with useful suggestion or solution. STEPS WHICH ARE FOLLOWED FOR LOGGING ONTO THE FORMS APPLICATION.docx
  16. Hi Pratik, and welcome to the forum! i have never used the Erickson application, but there is no way to disable Oracle logins unless there were too many password attempts. you cannot login via sqlplus? You can also lock and unlock users with these commands: http://www.dba-oracle.com/t_passwords_locking_changing_expiring.htm http://www.dba-oracle.com/concepts/alter_users.htmI I would contact the application vendor for support. Good luck!
  17. Earlier
  18. Ericsson switch application has end users on application and they are open on oracle database however i have been told no user including DBA can login on database. Any change is made through packages. How do i check this setting? Please help urgently
  19. DBUA to upgrade from 10gR2 to 12cR2

    Hi, And welcome to the forum! To be safe, I always go through each intermediate release. Each release has data dictionary updates, and the safe way is to migrate to 11g and then 12c: However, there are tricks for upgrading with multiple releases: This may help: https://gavinsoorma.com/2014/12/minimal-downtime-database-upgrade-from-oracle-10g-to-oracle-12c/ http://www.dba-oracle.com/t_goldengate_upgrade_to_oracle12c.htmGood luck!
  20. @boobalganesan Kindly Help..
  21. @boobalganesan One more thing i wna ask,if for the same data A+++500+read++ ,i want to capture position for each value means at which '+' postion value occurs or in other words count of '+' before each value,what should i do?? In this data,for 'A',position should be 0,for '500' position should be 3,for 'read,it should be 4.Output should be 0,3,4.Or i concatenate +||A+++500+read++ and then find count of '+' before each value and get that output as 1,4,5.What should be the query for this?
  22. DBUA to upgrade from 10gR2 to 12cR2

    Can we use GUI tool DBUA to upgrade from 10gR2 to 12.2.x.x? Well, I have gone through https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-BBF591A5-EB02-405A-9F99-572429838C73 but exactly did not find the answer. It seems to me had the direct upgrade been possible from 10.2.x.x to 12.2.x.x, upgrade through DBUA could have been possible. Kindly validate my understanding as I am new to DBUA. Thanks....
  23. Hello Ganesan

     

    Thanks for your response..One more requirement is there n i need you are help..

  24. @boobalganesan Hello Ganesan Thanks for your solution.Both is working fine according to my need. One more thing i wna ask,if for the same data A+++500+read++ ,i want to capture position for each value means at which '+' postion value occurs or in other words count of '+' before each value,what should i do?? In this data,for 'A',position should be 0,for '500' position should be 3,for 'read,it should be 4.Output should be 0,3,4.Or i concatenate +||A+++500+read++ and then find count of '+' before each value and get that output as 1,4,5.What should be the query for this?
  25. My bad! First Answer, with t1 as (select 'A+++500+read++' col1 from dual) select regexp_count(substr(col1,1,regexp_instr(col1,'[^\+]+',1,regexp_count(col1,'[^\+]+'))-1),'\+') from t1; Second Answer, with t1 as (select 'A+++500+read++' col1 from dual) select regexp_count(col1,'[^\+]+') from t1; Let me know how this goes for you. Thanks Boobal Ganesan
  26. @boobalganesan Hello Boobal Here 3rd value is 'read' bt its not like that we will always get 'read' value only..We can get different values. Just like A++++++USA+ A+++++++London+++++Newyork In every case,occurence of last '+' at which value occurs is needed.Here just for sample,i gave last value 'read' but last values can be different. & in second case bettween two '+',even if .(dot) occurs just like A+++++.++,we have to consider .(dot) as value.Anythng apart from '+' will be considered as value..
  27. Hi Sam, To your second question, we can quickly achieve by using REGEXP_COUNT as below, with t1 as (select 'A+++500+read++' col1 from dual) select regexp_count(col1,'[[:alnum:]]+') from t1; Here we are just checking for alpha numeric words. Thanks, Boobal Ganesan
  1. Load more activity
×