My Tech Lab

Step 1: Download the Wallet from ATP database console. Step 2: Launch SQL Developer. Step 3: Click on File > New > Database Connection Step 4: Enter the details

You receive the following errors when trying to make new connections using SQL Developer or any other client: ORA-00018: maximum number of sessions exceeded Resolution: Login as sysdba  $ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 28 03:32:48 2020 Copyright (c) 1982, 2014, Oracle.   All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production SQL>   Check the resource limit SQL> set lines 256 SQL> set trimout on SQL> set tab off SQL> select * from v$resource_limit; RESOURCE_NAME                   CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION                       LIMIT_VALUE                                   CON_ID ----------------------...

For the cloud enthusiast who wants to explore and start the journey to the Oracle Cloud, Oracle offers free version of various IaaS and PaaS services. In this post, I will discuss how to provision Autonomous Database, VM and Load Balancer on Oracle Cloud. What is Free Trial Oracle provides you with $300 of cloud credits that are valid for up to 30 days when you sign-up. You may spend these credits on any eligible Oracle Cloud Infrastructure service (OCI). After your trial ends, your account remains active. There is no interruption to the availability of the Always Free Resources you have provisioned. You can terminate and re-provision Always Free resources as needed. Paid resources that were provisioned with your credits during your free trial are reclaimed by Oracle unless you upgrade your account. What is always Free resources All OCI accounts (whether free or paid) have a set of resources that are free of charge for the...

SQL> connect sys as sysdba Enter password: Connected to an idle instance. SQL> startup ORA-44412: XE edition memory parameter invalid or not specified SQL> startup pfile=C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora ORACLE instance started. Total System Global Area 805306368 bytes Fixed Size 1289996 bytes Variable Size 209715444 bytes Database Buffers 591396864 bytes Redo Buffers 2904064 bytes Database mounted. Database opened. SQL> create spfile from pfile='C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora'; File created. SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 805306368 bytes Fixed Size 1289996 bytes Variable Size 209715444 bytes Database Buffers 591396864 byt...