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

I was recently creating a database VM (Oracle Linux 6 Update 3 on Oracle VM) on my laptop and encountered this issue. I have created a Virtual Disk for the database of 12 GB size and when I tried to install my schema using RCU I ran out of space. Solution was to create another Virtual Disk and move the database data files (.dbf) to this new drive. After few google search and looking at the blogs these are the steps I followed: Login to the database sqlplus / as sysdba Get the data file location  select file_name from dba_data_files; Shutdown the database shutdown immediate Shutdown the listener lsnrctl stop Shutdown the VM Guest OS. Created a new Virtual Disk of 20 GB. Start the Guest OS. Mount the drive. My mount point is u02. Move the dbf files under oradata/SID folder to the new disk. You will find the oradata folder under your Oracle home. E.g. move DEV_soainfra.dbf from /u01/app/oradata/soa to /u02/app/oradata. Start the database using command startup mount...

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