DBA Blogs

How solve incident Error?

Tom Kyte - Sun, 2017-06-11 06:06
I search incident error suddenly and my database immediate down and show error message client connect could not hand-off. And I see alter log file and search on internet also but i can't able to find information for first argument mention in the or...
Categories: DBA Blogs

Unable to install Oracle 11g on Windows 10

Tom Kyte - Sun, 2017-06-11 06:06
Hello Oracle Experts, I am unable to install Oracle 11g on Windows 10 (64 Bit). Error Encountered : ORA 12631 UserName retrieval failed Database instance is created but the .DBF files are not created including the control files. Please note...
Categories: DBA Blogs

Why I can't get the user role when I logon the database?

Tom Kyte - Sun, 2017-06-11 06:06
Hello everyone I'm trying to solve a little problem that I have everytime I connect as another user on the database. First of all let me explain what I want to do. When the user connect on the database I want to know his role and just show on o...
Categories: DBA Blogs

Oracle 12C Database Running on 11G Grid/ASM

Tom Kyte - Sun, 2017-06-11 06:06
Hello all, I have a client who is currently running on an 11.2.0.3 DB and Grid/ASM. They want me to stand up a new database as 12.2.0.1 to export into while the current database is still running. I've gone over the documentation for upgrading but ...
Categories: DBA Blogs

Unable to run the job which is already created

Tom Kyte - Fri, 2017-06-09 17:06
Hi Tom, I need your help in fixing this. I have created the job which should call a shell script when triggered. But unfortunately I am getting error as test_job must be a job. Below are the scripts which I have used to create the job. Let ...
Categories: DBA Blogs

Query to get the count of records every two hours

Tom Kyte - Fri, 2017-06-09 17:06
I have a record creation time stamp in my table . I need to write a query to get the count of records every two hours between two specific dates. Starting from 1st January 2017 till today. I have the following table USER USER_ID CREATION_D...
Categories: DBA Blogs

Failed to CREATE tablespace or pfile to NFS (or NAS who was believed correctly configured) on Windows

Tom Kyte - Thu, 2017-06-08 22:46
Hi Team, We plan to deploy 2 Oracle labs whose datafiles are resident on NFS (or NAS). And we met a strange situation about CREATING pfile/datafile to NFS(or NAS) on Windows Server: 1) on Windows, we <u>failed to CREATE pfile(or tablespace) to NFS(...
Categories: DBA Blogs

ERROR Creating a VIEW that has a FUNCTION in a WITH CLAUSE

Tom Kyte - Thu, 2017-06-08 22:46
I am able to run a query that contains a FUNCTION inside of a WITH clause, which is a new 12c feature, but I get an error when I try to use the same SQL inside a VIEW. I tried using LiveSQL, but I cannot even get the SQL below to run, which does wor...
Categories: DBA Blogs

PipeLine function in Package

Tom Kyte - Thu, 2017-06-08 22:46
Hi Tom, Good Day! I have some doubts on pipeline functions.I created pipeline function in Package. i need to declare types within package to return a pipeline function. is possible to create objects in package to return a pipeline function is ...
Categories: DBA Blogs

Compile file *.fmb, *.mmb wih unicode!

Tom Kyte - Thu, 2017-06-08 22:46
Hi Tom! I'm have been an issue with unicode when compile file *.fmb to *.fmx and *.mmb to *.mmx (OS: linxux). I set NSL_LANG=AMERICAN_AMERICA.UTF8; NLS_LENGTH_SEMANTICS=CHAR.When I execute the command below it's successful but the unicode fonts...
Categories: DBA Blogs

Script to kill sessions prior to shutdown

Tom Kyte - Thu, 2017-06-08 22:46
We have an issue during a monthly shutdown of the database in preparation to be refreshed, it hangs due to active calls. We then have to manually kill the sessions. If possible, will you provide a script that can kill processes prior to a shutdo...
Categories: DBA Blogs

Optimal PCTFREE, PCTUSED and INITTRANS settings.

Tom Kyte - Thu, 2017-06-08 22:46
Hello Tom We have a online transaction database with huge volumes of inserts/updates. Initially we have set a value of PCTFREE 40, PCTUSED 50 and INITTRANS 100 on all the tables in the database schema. However now we know that there are some ta...
Categories: DBA Blogs

Connect By with multiple tables - what clauses are needed?

Tom Kyte - Thu, 2017-06-08 04:26
I have a question on something that I always get confused on. Most of the demo's on "Connect By" feature a single table and the "Connect" Clause is simply <code>Connect By Prior emp_id = mgr_id </code> or similar. However I have a situation whe...
Categories: DBA Blogs

ASM Discovery of Larger LUN

Tom Kyte - Thu, 2017-06-08 04:26
Can Oracle ASM use the additional space of a LUN assigned to a disk group where the LUN has been grown at the array level?
Categories: DBA Blogs

Peculiar behavior of REGEXP_REPLACE

Tom Kyte - Thu, 2017-06-08 04:26
Hi Tom, Here's something I observed and couldn't make anything out of it. Considering the below two queries: (To summarize, I took a string of 9 repeating characters, and replacing the nth character (3rd in the example) with another character. ...
Categories: DBA Blogs

SQLNET encryption between an Oracle 32bit client and a 64bit Server

Tom Kyte - Thu, 2017-06-08 04:26
Can an Oracle 32 bit client securely communicate with and Oracle 64 bit server via SQLNET encryption? I cannot find this scenario specifically documented in the 12c documentation. Our DBA is telling us that this will not work. Any help guidance yo...
Categories: DBA Blogs

Fast extract from oracle to TEXT/CSV file

Tom Kyte - Thu, 2017-06-08 04:26
Hi Oracle Gurus! We have encountered strange speed issue and need your assistance... Setting: 1) Oracle 11.2 Exadata machine, 4 nodes, 2) several linux servers which need large amounts of data (10-s of gigabytes) from Oracle extracted to tex...
Categories: DBA Blogs

Connection Pool from App Server and RAM usage in Database Server

Tom Kyte - Thu, 2017-06-08 04:26
Hi Tom, Configuration:- --------------------- 1) Oracle weblogic app server is used 2) The connection pool in side weblogic is set as MIN=1200 INITIAL=1200 MAX=1200 3) 8 managed + 1 admin servers inside weblogic 4) so total number sessions es...
Categories: DBA Blogs

trace files location

Tom Kyte - Thu, 2017-06-08 04:26
Tom right now every time I trace my session Iam having to ask my dba to email my trace file and the tkprof outputfile to me, as I dont have access to the files on the database server (os-unix,a nd my client is on windows 2000) side. is there a...
Categories: DBA Blogs

Unable to drop tables from a database

Tom Kyte - Wed, 2017-06-07 10:06
Hi We have recently created a new database from an existing database via RMAN incremental backup level 1. We have created a user and provided all the privileges to it. But, we are currently facing an issue, we are unable to drop any tables...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs