Hello guys, I'm hoping someone can share additional tips and steps with me on how to resolve the space issue.
I have a development / training environment setup in the oracle cloud environment with dbaas/ jcs.
i've looked at this https://community.oracle.com/message/13902819#13902819 but recommended solution isn't quite what i'm hoping for.
Dbaas instance was provisioned with default config though minor db config has been updated. however my data storage volume u01 is nearly out of space which hosts my main datafile. (I'm not so savy with oracle db administration, i'm a core apps developer). running ls on my box gives me details below
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/xvdb3 26198448 14357356 10487280 58% /
tmpfs 3698528 2100232 1598296 57% /dev/shm
/dev/xvdb1 487652 151198 306758 34% /boot
/dev/xvde1 61795324 9608252 49025012 17% /u01
/dev/mapper/dataVolGroup-lvol0 103077152 97818096 0 100% /u02
The dataVolGroup-lvol0 is totally out of space or nearly, and as one of the default storage volumes, I want to increase it's capacity.
Note: from the web console, there's a chance to increase storage but additional processors (at least 1) would need to be added.
My requirement is to scale up the storage (CLI or UI controls), without adding more processors to the db instance.
Many thanks,