Upgrading to Application Express 5.0 in Your Oracle Database Release 12.1 Multitenant Container Database (CDB)April 30, 2015 at 8:48 am | Posted in Oracle Developement | Leave a comment
This is a reblog from Jason Straub’s blog Application Express Nuggets, discussing how to upgrade APEX in CDB$ROOT of your Oracle 12.1 Container DB.
Get OS authentication to work with the Dev. Days VM
Reblogged from Stojan’s Oracle Blog.
Tags: apex, application express, enterprise, linux, linux 7, oracle, redhat, rhel, rhel7
I typically prefer htop to the regular top command. Here are the steps I took to install htop on the Oracle Developer Day VM:
- Change to tmp direcoty
- Download epel repository:
- Install epel repository:
sudo yum install epel-release-7-5.noarch.rpm
- Install htop:
sudo yum install htop
Enjoy the enhanced process viewer
Tags: 12c, apex, application express, database, oracle, pluggable
- Log in as sys
- Change to CDB$ROOT and verify container:
SQL> alter session set container = cdb$root; Session altered. SQL> show con_name CON_NAME ------------------------------ CDB$ROOT
- Create plugable database from seed (this command also adds the new pdb2 directory):
create pluggable database pdb2 admin user pdb2_admin identified by secret_password file_name_convert =( '/home/oracle/app/oracle/oradata/cdb1/pdbseed/', '/home/oracle/app/oracle/oradata/cdb1/pdb2/' );
- At this point the database is created and mounted. Open new database:
SQL> alter pluggable database pdb2 open read write;
- List pluggable databases:
alter session set container=CDB$ROOT; col pdb_name for a30 col status for a10 col status for a10 select a.pdb_name,a.status,b.open_mode from dba_pdbs a, v$pdbs b where a.pdb_name = b.name(+) order by 1 / PDB_NAME STATUS OPEN_MODE ------------------------------ ---------- ---------- ORCL NORMAL READ WRITE PDB$SEED NORMAL READ ONLY PDB2 NORMAL READ WRITE
- Create a new tnsnames.ora entry for the database:
PDB2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb2) ) )
- Log in as pdb2_admin:
- Log in as sys to pdb2:
sqlplus sys@pdb2 as sysdba;
sqlplus sys as sysdba; alter session set container = pdb2;
The new database will have three tablespaces;
SQL> select tablespace_name,contents from dba_tablespaces;
TABLESPACE_NAME CONTENTS ------------------------------ --------- SYSTEM PERMANENT SYSAUX PERMANENT TEMP TEMPORARY
For more information see the Oracle-Base article.
Tags: apex, appliance, bashrc, developer day, linux 7, oracle, oracle 12c, virtual box, vm
I just installed the Oracle Developer Day – Database VirtualBox Appliance and noticed I wasn’t able to scp from my host to the VM. Thanks to Mauro Pagano, who suggested removing the banner from the login script, I was able to fix it.
To remove the banner, edit the /home/oracle/.bashrc file and comment out the following line
This prevents the banner to show up, and allows scp to work.
Patrick Wolf of Oracle, was kind enough to provide me with an explanation for this:
Thanks to Patrick for the detailed explanation.
I have a comma delimited string:
Now I want to extract the 3rd element (is) from it inside a select statement:
select regexp_substr('Hello,this,is,my,string', '[^,]+', 1, 3) from dual;
To count the elements in my string I can use:
select regexp_count('Hello,this,is,my,string', ',', 1, 'i')+1 regexp_count from dual;
Originally posted on TED Blog:
Teens, tweens and kids are often referred to as “digital natives.” Having grown up with the Internet, smartphones and tablets, they’re often extraordinarily adept at interacting with digital technology. But Mitch Resnick, who spoke at TEDxBeaconStreet, is skeptical of this descriptor. Sure, young people can text and chat and play games, he says, “but that doesn’t really make you fluent.”
[ted_talkteaser id=1657]Fluency, Resnick proposes in this TED Talk, comes not through interacting with new technologies, but through creating them. The former is like reading, while the latter is like writing. He means this figuratively — that creating new technologies, like writing a book, requires creative expression — but also literally: to make new computer programs, you actually must write the code.
The point isn’t to create a generation of programmers, Resnick argues. Rather, it’s that coding is a gateway to broader learning.“When you learn to read, you…
View original 567 more words