Connecting to Oracle Autonomous Database from SQL Developer

-
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


Comments

Post a Comment

Popular posts from this blog

ORA-44412: XE edition memory parameter invalid or not specified

-
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...
Read more

ORA-00018: maximum number of sessions exceeded

-
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 ----------------------...
Read more

How to mount a WD Book Live as NFS in OEL6U3

-
Scenario : I have a Windows 8 (Host) laptop on which I am running two OEL6U3 (Guest) machines in a Virtual Box. I want to have a shared mount between the two Linux machine which will allow me to read/write from both the machines concurrently. Its a very common scenario for a High Availability Environment. Virtual Box provides a facility of creating sharable VDI disks which can be mounted on multiple machines, but it doesn’t allow concurrent read/write access from multiple machines. If you are installing RAC database then its still achievable, because ASM will provide the feature of concurrent read/writes, but if you want to install a WebLogic cluster with High Availability the recommended approach would be to have a Shared Mount. Step to create a shared nfs mount is fairly simple. I am using a WD My Book Live, and will mount the Public folder as shared mount 1. Get the hostname/ip of the WD device. 2. On the Linux Machine 1 create the folder where you want to mount the nfs ...
Read more