Hi, lay person here who was told someone on this forum might be able to answer my questions for me. I'm looking for some advice on getting old text messages back for two separate situations. It may be impossible, but they're important to me so I would like to try. First, I have an old phone with a broken screen. There's a text thread I'd like to pull from it. I tried downloading some services like Dr. Fone to retrieve them, but it's a government phone, a Moxee m2160 MH-T6000, and none of those work with that phone. How can I connect my phone to my laptop to use my laptop as the phone screen ..read more

I have installed the unix on windows and followed the steps given in how to run Linux Commands on Windows 10? And also I have installed the Oracle DB on same windows machine. Now I have to access the sqlplus from unix box. I am getting sqlplus: command not found when i type sqlplus in unix screen. I have done sudo ln -s /mnt/d/Oracle/bin/sqlplus /bin/sqlplus but still it says command not found. So this unix package which i installed does not have SQLPLUS ? Thanks, Ramesh Selvam ..read more

Hi A customer has provided us with a datapump file of their schema for import into a new environment for them. They have created service users which we don't require and have grants assigned to them, which generates a lot of errors in the import log. Obviously, I can just create a user/role of the same name and then drop it at the end, but is there a way to exclude this during the import - our IT team will be doing this in the future so want to make this process as simple as possible (since I have to document how to login to SQLPLUS, scary I know!) Will EXCLUDE=SCHEMA:"='FRED'" stop privileg ..read more

SQLs that run smoothly from time to time suddenly slow down. When we investigate, we see that the SQL Plan has changed. Now, what I want from you is how to determine the efficient plan_hash_id and how to apply it again. Do you have any nice SQL scripts to do that ..read more

Is there any way to speed up the execution time of the full RMAN backup? With device tape I can use the rman parameter "configure backup optimization on;" ? It would appear not: http://pages.di.unipi.it/ghelli/dida...mconc1008.html To check the RMAN backup bottleneck, should I run 'backup validate' or are there other faster checks? If the time for the BACKUP VALIDATE to tape is about the same as the time for a real backup to tape, then reading from disk is the likely bottleneck. If the time for the BACKUP VALIDATE to tape is significantly less than the time for a real backup to tape, then wr ..read more

Hello, Needs some guidance i have open the case with support but i guess they taking their time and needs some help to resolve this issues: I am getting following error messages in alert log: ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-4] [2] [1] [] [] [] [] [] the processes run on app server it has oracle 19 client with 19.3 odac as well. but when process finishes it gets error in alert log: here is some of the message from trc file: ==== FRAME [1] (ksedst()+89 -> ksedst1()) ==== defined by frame pointers 0xe9a9fb5b30 and 0xe9a9fb5b30 CALL TYPE: CALL??? ERROR ..read more

I should check the progress of the full rman backup. The following query does not extract any records. Percentage rman backup select sid ,start_time ,totalwork ,sofar ,case totalwork when 0 then round((sofar/1) * 100,2) else round((sofar/totalwork) * 100,2) end pct_done from v$session_longops where totalwork > sofar order by start_time desc; The last extracted records are from 6 days ago and opname='Gather Table's Index Statistics'. select * from v$session_longops order by start_time desc; The full rman backup is running: is there a reason why no records are being extracted? Until last w ..read more

I have a Oracle application developped in Forms 6.0 & Oarcel 12g Database, Aplication is running very well in windows 32bit perfectly, when it comes to Windows 64, it throughs error " \Orant\DBS\FMCUS.MSB not found". Is there any windows 32/64 dependency?Error.jpg Attached Images Error.jpg (85.0 KB ..read more

Good morning, I randomly receive ORA-12514 errors on several scheduled tasks. There are no errors in the listener log files listener.log and og.xml. There are no errors in the alertlog and trace files. The hostname is correctly configured in the file listener.ora. The ping responds correctly with the hostname . The lsnrctl services command responds correctly. There are several cases in which the ORA-12514 error occurs 1) the database listener is not reachable due to errors in the configuration --> this is not the case 2) the database listener is temporarily unavailable for some reason ..read more

Oracle DBAs in my oraganization have been told by security compliance folks not to use any tools including SQL Developer and other lincensed tools out there in the market to access DB. They are asking us to stick to SQLPlus. :confused: Any thoughts? Thanks ..read more