0

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 i can set ORACLE_HOME for DB1 and other parameters in pfile ?

Also i can avoid the error

ORA-45301: XE Edition single instance violation error
2

Oracle Database XE Installation and Execution Restrictions

Only one installation of Oracle Database XE can be performed on a single computer. This does not affect any existing installation or new installations of Oracle Database 11g Standard Edition, Oracle Database 11g Standard Edition One, or Oracle Database 11g Enterprise Edition. In addition, users can run only one instance of the Oracle Database XE database on each individual computer. To run more than one Oracle Database server instance or install more than one copy of the database software, upgrade to Oracle Database 11g Standard Edition, Oracle Database 11g Standard Edition One, or Oracle Database 11g Enterprise Edition.

  • how to identify installed database is express or standard edition? – azardin Mar 10 '17 at 13:34
  • 1
    It is Express Edition. Other editions do not throw that error. – Balazs Papp Mar 10 '17 at 15:48
  • i want to install 11g database on linux. let me know how to install the Oracle 11gR2 on linux (Ubuntu). – azardin Mar 16 '17 at 15:12
  • 1
    @azardin Ubuntu is not supported by Oracle. You should install Oracle Linux in a virtual machine and install Oracle database on that. Yes, it is possible to install on Ubuntu with some workarounds, but I would not go that way. – Balazs Papp Mar 16 '17 at 16:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.