Feed aggregator

Unlock user shell script for Oracle

Tom Kyte - Fri, 2019-02-08 13:26
Hello, We have so many user ID locks from the front-end users. We need to provide a shell script to the user which they can run on OS level and unlock the ID themselves when the DBA is not present. The sys password needs to be decrypted during ...
Categories: DBA Blogs

Join all_tables to a normal table

Tom Kyte - Fri, 2019-02-08 13:26
Hi Is it possible to join ALL_TABLES and normal table? I like make dynamic SQL and select columns that shown after selected from list. Something like this: <b>select * from table1 a where a.columns in (SELECT DISTINCT A...
Categories: DBA Blogs

Select from view with where clause

Tom Kyte - Fri, 2019-02-08 13:26
Hi, I cant find so I'd like to ask: I have view myView: <code>create view myView as select * from myTable;</code> and what is the difference between <code>select * from myTable where myTable.id = 12345;</code> and <code>select * from ...
Categories: DBA Blogs

Guidelines for chossing Database Vs Schema. Also One Schema on multiple schema on Oracle Exadata

Tom Kyte - Fri, 2019-02-08 13:26
Hi, This is my first experience with Oracle Exadata. Trying to provide solution for client. 1) Do you have any guidelines for when to go for database against schema. Pros and Cons 3) We have to load data from 100+ sources so any guidelines f...
Categories: DBA Blogs

Log Recovery in Dataguard alert log

Tom Kyte - Fri, 2019-02-08 13:26
Hi all, I am using Oracle 11g Active Dataguard in maximum performance mode. I notice 2 general pattern of log recovery in the database alert log. ===================== Pattern1 <code>RFS[7]: Selected log 11 for thread 2 sequence xxxxx Arc...
Categories: DBA Blogs

Database migration

Tom Kyte - Fri, 2019-02-08 13:26
Hi All, We have 70 TB Database sitting in Solaris Sparc . We are migrating oracle from Solaris to RHEL 7. i am looking for best approach for moving data from Solaris to rhel with minimal downtime. Could you please let me know what would be ...
Categories: DBA Blogs

“Oracle Indexing Internals and Best Practices” Seminar – Berlin 8-9 May: DOAG Website

Richard Foote - Fri, 2019-02-08 00:55
Just a short note to say that DOAG have now a registration page for my upcoming “Oracle Indexing Internals and Best Practices” seminar running in Berlin, Germany on 8-9 May 2019. For all the details regarding this acclaimed educational experience and how to book your place, please visit: https://www.doag.org/de/eventdetails?tx_doagevents_single[id]=577320 Please mention you heard this seminar […]
Categories: DBA Blogs

Exposing Spinnaker UI endpoint from a helm based spinnaker install on PKS with NSX-T

Pas Apicella - Thu, 2019-02-07 22:50
I previously blogged about "Installing Spinnaker on Pivotal Container Service (PKS) with NSX-T running on vSphere" and then quickly invoking the UI using a "kubectl port-forward" as per this post.

http://theblasfrompas.blogspot.com/2019/02/installing-spinnaker-on-pivotal.html

That will work BUT but it won't get you too far so his what you would need to do so the UI works completely using the spin-gate API endpoint.

Steps (Once Spinnaker is Running)

1. Expose spin-deck and spin-gate to create external LB IP's. This is where NSX-T with PKS on prem is extremely useful as NSX-T has LB capability for your K8's cluster services you create making it as easier then using public cloud LB with Kubernetes.

$ kubectl expose service -n default spin-deck --type LoadBalancer --port 9000 --target-port 9000 --name spin-deck-public
service/spin-deck-public exposed

$ kubectl expose service -n default spin-gate --type LoadBalancer --port 8084 --target-port 8084 --name spin-gate-public
service/spin-gate-public exposed

2. That will create us two external IP's as shown below

$ kubectl get svc

...

NAME                 TYPE                 CLUSTER-IP     EXTERNAL-IP  PORT(S) AGE
spin-deck-public  LoadBalancer    10.100.200.200   10.195.44.1,100.64.128.15  9000:30131/TCP ..
spin-gate-public   LoadBalancer    10.100.200.5       10.195.44.2,100.64.128.15  8084:30312/TCP ..

...

3. Exec into hal pod using a command as follows

$ kubectl exec --namespace default -it myspinnaker-spinnaker-halyard-0 bash

4. Run these commands in order on the hal pod. Make sure you use the right IP address as per the output at #2 above. UI = spin-deck-public where API = spin-gate-public

$ hal config security ui edit --override-base-url http://10.195.44.1:9000
$ hal config security api edit --override-base-url http://10.195.44.2:8084
$ hal deploy apply

5. Port forward spin-gate on your localhost. Shouldn't really need to do this BUT for some reason it was required I suspect at some point this won't be required.

$ export GATE_POD=$(kubectl get pods --namespace default -l "cluster=spin-gate" -o jsonpath="{.items[0].metadata.name}")
$ echo $GATE_POD
$ kubectl port-forward --namespace default $GATE_POD 8084
spin-gate-85cc7465bd-v2q2l
Forwarding from 127.0.0.1:8084 -> 8084
Forwarding from [::1]:8084 -> 8084

6. Access UI using IP of spin-deck-public


If it worked you should see screen shots as follows showing that we can access the tabs and "Create Application" without errors accessing the gate API endpoint







Categories: Fusion Middleware

Pivot on a query with multiple data columns

Tom Kyte - Thu, 2019-02-07 19:06
I have an SQL query written against view sys.dba_audit_session to retrieve initial logon and final logoff times for users across a range of days. So the basic query is <code> SELECT DISTINCT username, action_name, ...
Categories: DBA Blogs

Parsing through a Long Character with 255 characters and Stripping out Words

Tom Kyte - Thu, 2019-02-07 19:06
Hi, I have a long character field for every one of my 10,000 rows and I need to write a PL/SQL that goes through every row a parses this long field for any WORD (Mix of Alpha and Numeric) up to 6 characters and spits it out and Save it to a differ...
Categories: DBA Blogs

Generating output file using spool is very slow when compared to UTL_FILE

Tom Kyte - Thu, 2019-02-07 19:06
Hello Team, We have to extract huge data from EBS tables. We have tried two approaches Approach1 (Using SQL and Spool command) --------- We have created a script to generate the output using SPOOL command but this is taking 12 hours of time ...
Categories: DBA Blogs

Identify when a function is executed in a SQL Query or in a PL/SQL procedure

Tom Kyte - Thu, 2019-02-07 19:06
Is there any way to identify when a pl/sql function is executed in SQL Query and when is executed in a procedure or PL/SQL anonymous block? (I don't want to pass any parameter for manual identification) The main reason I need that is when a functi...
Categories: DBA Blogs

How to convert ROWS to COLUMNS

Tom Kyte - Thu, 2019-02-07 19:06
Hi, I have data as given below in table <code>create table chart( SERIES varchar2(10), LABEL date, VALUE number(5,2) ); insert into chart values('A',to_date('13-DEC-18','DD-MON-YY'),83.55); insert into chart values('B',to_date('13...
Categories: DBA Blogs

Impact on EBS of Browser Desupport of TLS 1.0 and TLS 1.1

Steven Chan - Thu, 2019-02-07 09:31

Many browsers (including Firefox, Chrome, Internet Explorer and Safari) will soon no longer support either TLS 1.0 or 1.1.  Most likely, many of you have already migrated from SSL to TLS for Oracle E-Business Suite 12.2 and 12.1: however, you should also make certain that you have configured Oracle E-Business Suite properly for TLS 1.2.

What Do You Need to Do?
  1. Understand desupport notices for TLS 1.0 and TLS 1.1 for browsers used by your organization. 
  2. Follow our documentation to meet the requirements for using TLS 1.2 with Oracle E-Business Suite Release 12.2 or 12.1:

You have the option to configure Oracle E-Business Suite to work with TLS 1.2 only, or to be backward compatible with TLS 1.2, 1.1, and 1.0.  Either of these configurations will allow Oracle E-Business Suite to function properly with browsers that have desupported TLS 1.0 and 1.1. 

Related Articles References
Categories: APPS Blogs

[Blog] High-level Steps to Protect an On-premises Application with IDCS by Using WebGate

Online Apps DBA - Thu, 2019-02-07 04:02

WebGate can now interact with Oracle Identity Cloud Service: Protect the on-premises web application by using cloud service to authenticate users to access the web application. Visit: https://k21academy.com/idcs14 to know about How to Protect an On-Premise Application with IDCS by Using Webgate. This Include: ✔ Why IDCS to protect an On-Premise Applications ✔ How does […]

The post [Blog] High-level Steps to Protect an On-premises Application with IDCS by Using WebGate appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Partner Webcast – Connect and Extend SaaS with Oracle Autonomous Integration Cloud Service

Oracle Autonomous Integration Cloud helps to simplify application integration and process automation to let you rapidly connect SaaS and on-premises application across, both Oracle and non-Oracle,...

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

Index creation slow - lots of direct path write/temp waits

Tom Kyte - Thu, 2019-02-07 00:46
I have a table on which I'm trying to index a column. This happens as part of an ETL process, however I have run this process directly to reproduce. The table in question has about 15M rows and I am trying to index a single column. create index x...
Categories: DBA Blogs

Created file using UTL_FILE. How to prevent file from being picked up before it has been fully created

Tom Kyte - Thu, 2019-02-07 00:46
We have an integration where the file is being created in oracle ebs using utl_file utility. The file is placed on the server where biztalk pings every 60 sec and picks it up. In one scenario the file was picked up before it was written out resulting...
Categories: DBA Blogs

When are partition statistics beneficial?

Tom Kyte - Thu, 2019-02-07 00:46
Tom, When are partition-level statistics used by the optimizer in 9iR2 and 10g? The only thing I've found in the docs so far (trying to avoid RTFM) is that they're used when a query fit the form SELECT ... FROM MYTABLE PARTITION (PTN_NAME). Specif...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator