DBA Blogs

Errors during iPod touch iOS update

Tom Kyte - Fri, 2016-07-08 21:46
My IPod touch iOS update keeps saying that an error has accured and when i tap on settings it asks me to update it! I'm trying to update to iOS 8.14. Please help!!
Categories: DBA Blogs

Revert 12.1.0.2.0 CDB to stand alone non-CDB with same product version

Tom Kyte - Fri, 2016-07-08 21:46
Hello Team, We have installed Oracle 12c version 12.1.0.2.0 to be pluggable. However, many scripts would require the stand alone non pluggable mode of oracle. Can you please guide to convert CDB to non-CDB without downgrading to older versions. ...
Categories: DBA Blogs

datapump export - ORA-39126 / ORA-12838

Tom Kyte - Fri, 2016-07-08 21:46
HTP0#>expdp system/***** full=y DIRECTORY=data_pump_dir4bos dumpfile=EZTAG_UiAT.dmp logfile=myfullexp.log job_name=eztag_uat_ex5 Export: Release 11.2.0.4.0 - Production on Fri Jul 8 06:46:18 2016 Copyright (c) 1982, 2011, Oracle and/or its affi...
Categories: DBA Blogs

How to get database name in oracle db node js

Tom Kyte - Fri, 2016-07-08 21:46
<b>How to get database name in oracle db in node js without query using connection object</b> <code> var oracledb = require('oracledb'); oracledb.getConnection( { user: 'c##root', password: 'root', connectString: ...
Categories: DBA Blogs

How to load a xlsx file in to a table

Tom Kyte - Fri, 2016-07-08 21:46
I have a xlsx file ,and i am using sql loader in toad to load in to table.I also have created control file for the same. the file content is given below: ID Name Employee name Designation Status 0000700 John,Sam John sam (000070) Sr.Developer, ...
Categories: DBA Blogs

Partner Webcast - Oracle Mobile Cloud Service for Developers: Updates and Features

The Oracle Mobile Cloud Service (MCS) goal is to easily enable mobile application developers that are continually looking for new ways to accelerate development of apps to meet their consumer’s...

We share our skills to maximize your revenue!
Categories: DBA Blogs

How to get access to the Oracle Public Cloud

&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;span...

We share our skills to maximize your revenue!
Categories: DBA Blogs

GATHER_TABLE_STATS difference between 11g and 12c (DBMS_STATS.flush_database_monitoring_info)

Tom Kyte - Fri, 2016-07-08 03:26
Hi Tom, So we are looking to be refreshing stats when the stats become stale while a lot of DML is happening on a table, and were testing how to handle this. FLUSH_DATABASE_MONITORING_INFO is the right procedure as it updates the dictionary. We ...
Categories: DBA Blogs

Anyway to Access Data in a Table That Has Been Made Invalid By Dropping an XMLSchema

Tom Kyte - Fri, 2016-07-08 03:26
Is here anyway to make a table valid again if it has an XMLType column with an XMLSchema associated it which has been deleted via dbms_xmlschema.deleteSchema with a DELETE_INVALIDATE parameter? I cannot even successfully drop the XMLType column from...
Categories: DBA Blogs

LEFT JOIN on nested table and TABLE function: unexpected results

Tom Kyte - Fri, 2016-07-08 03:26
Hi! This is my first question here, so don't hesitate to tell me if I am unclear or if key information is missing. I have been getting unexpected results while trying a LEFT JOIN on a nested table. Here's my tables: <code>CREATE OR REPLACE ...
Categories: DBA Blogs

utl_http results to ORA-12541: TNS:no listener

Tom Kyte - Fri, 2016-07-08 03:26
Hi, I have 11g DB and I have url below that I can open in the browser displaying pdf. This is pdf report generated from Jasper server. http://serv-ora11g:8081/jasperserver/flow.html?_flowId=viewReportFlow&j_username=jasperadmin&j_password=jaspe...
Categories: DBA Blogs

utl_htp is begin_request is resulting to ORA-29263: HTTP protocol error

Tom Kyte - Fri, 2016-07-08 03:26
Hi, I have URL that I can access with a browser and this displays the PDF http://serv-ora11g:8081/jasperserver/flow.html?_flowId=viewReportFlow&j_username=jasperadmin&j_password=jasperadmin&reportUnit=/KVS/Collection/col1190&output=pdf I c...
Categories: DBA Blogs

Cross Platform "Endian" Conversion from Solaris to Linux Intel-Based Exadata -- Mounting NFS to Exadata Machine

Tom Kyte - Fri, 2016-07-08 03:26
Hi, Is it possible for a Solaris NFS to be mounted on a Linux Intel-Based Exadata machine? This approach seems (at least to me) to be alluded to in this section of Oracle Database Backup and User's Guide: https://docs.oracle.com/cd/E11882_01/back...
Categories: DBA Blogs

Creating tables (maybe)

Tom Kyte - Fri, 2016-07-08 03:26
How to create a table for this one. AAA BBB CCC RED 1 2 3 BLUE 4 5 6 GREEN 7 8 9 I tried on SQL DEVELOPER.It's gave me an error. And converted into an out put like.. RED BLUE GREEN AAA 1 4 ...
Categories: DBA Blogs

cursor for loop

Tom Kyte - Fri, 2016-07-08 03:26
Hi, I have a cursor for loop which does some calculation in the cursor query. With in the loop I have insert with commit for every iteration. There are not more statement apart from INSERT & COMMIT inside the loop. Example: DECLARE cursor...
Categories: DBA Blogs

Dba vs Apps DBA

Tom Kyte - Fri, 2016-07-08 03:26
What is different between Oracle DBA and Oracle apps DBA? I so many websites where some of them used term Oracle DBA and some of them Oracle apps DBA?
Categories: DBA Blogs

Undo Table space

Tom Kyte - Fri, 2016-07-08 03:26
Hi Tom, Following are the scenarios and please let me know what will happen in the listed scenarios : 1. I have a Undo table space with least size, i do a deleting of records in a table which is huge in size(a size which undo tablespace ca...
Categories: DBA Blogs

Enable auditing in oracle database

Learn DB Concepts with me... - Thu, 2016-07-07 13:54

ENABLE AUDITING IN ORACLE DATABASE
SERVER SETUP FOR DB AUDITING


Auditing is a default feature available in Oracle server. The initialization parameters that influence its behaviour can be displayed using the SHOW PARAMETER SQL*Plus command.

SQL> SHOW PARAMETER AUDIT

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      C:\ORACLE\PRODUCT\10.2.0\ADMIN
                                                 \DB10G\ADUMP
audit_sys_operations                 boolean     FALSE
audit_trail                          string      NONE

SQL>

Auditing is disabled by default, but can enabled by setting the AUDIT_TRAIL static parameter, which has the following allowed values.

AUDIT_TRAIL = { NONE | os | db | db,extended | xml | xml,extended }

The following list provides a description of each setting (choose one based on your requirement):


NONE or false - Auditing is disabled.
db or true - Auditing is enabled, with all audit records stored in the database audit trial (SYS.AUD$).
db,extended - As db, but the SQL_BIND and SQL_TEXT columns are also populated.
xml - Auditing is enabled, with all audit records stored as XML format OS files.
xml,extended - As xml, but the SQL_BIND and SQL_TEXT columns are also populated.
OS - Auditing is enabled, with all audit records directed to the operating system's audit trail.


To enable auditing and direct audit records to the database audit trail, we would do the following.
SQL> ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE;
System altered.

SQL> SHUTDOWN
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> STARTUP
ORACLE instance started.

Total System Global Area  289406976 bytes
Fixed Size                  1248600 bytes
Variable Size              71303848 bytes
Database Buffers          213909504 bytes
Redo Buffers                2945024 bytes
Database mounted.
Database opened.

SQL>

Note : Enabling and Disabling the auditing in database will only take affect after a db restart.
Categories: DBA Blogs

Website validation using regexp_like.

Tom Kyte - Thu, 2016-07-07 09:06
Hi, Could you please help to get website validation query using regexp_like. e.g. www.google.com https//:www.google.com both should get validated. Thanks in advance.
Categories: DBA Blogs

Datatype issue.

Tom Kyte - Thu, 2016-07-07 09:06
Hi all, I have an issue with column datatype.Can you please look at this issue. I have two tables emp1 and emp2 with empno column in both tables in table emp1 column empno is nvarchar2 and in table emp2 column empno is number datatype I am tryin...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs