I have already created a database XE on my linux desktop.Please find the below information about the database.
ORACLE_SID=XE
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
I have to create another database,eg: database name is DB1. My question is how canI set ORACLE_HOME for DB1 and other parameters in pfile ?
Also how can I avoid the error ORA-45301: XE Edition single instance violation error?
Oracle Express Edition is a free (as in "free beer") version of the Oracle database. As such it comes with various limitations compared to the paid for versions. These are covered in the documentation.
"I have to create another database"
You cannot do this with XE. From the Installation guide:
"Only one installation of Oracle Database XE can be performed on a single computer..... In addition, users can run only one instance of the Oracle Database XE database on each individual computer. "
This is why you get the ORA-45301 error. If you need a second XE database you need a second computer. Or upgrade to Standard Edition.
