0

I installed Oracle 11g, with ad instance called orcl.

And I want to create another instance, called for example orcl1.

How could I do that? Do I nead to re-install another database like I did the first time?

Improve this question
7
  • Why do you think you need a second instance? What problem are you trying to solve with that? Commented Jun 17, 2020 at 17:30
  • I have a project devided in two under projects that use two databases. When I imported the second database in the same instance, I had some error of connecting with database. So I wanted to create two instances, instance 1 for the database 1, and instance 2 for the database 2. Commented Jun 17, 2020 at 17:36
  • If we knew more about "some error of connecting with database" perhaps that could/should be addressed. Especially since you appear to be wanting to create a second instance purely as a work-around. But to answer your specific question - Installing the software is not the same as creating a database/instance. YOu don't need to reinstall, any more than you would "re-install" MS Office just because you want to create another Word document. Commented Jun 17, 2020 at 17:44
  • 1
    Would it be enough if you just use another schema, instead of another database? Commented Jun 17, 2020 at 18:10
  • 1
    We don't know the "everything" that you tried, or why "nothing" seemed to work. If we knew the details of a specific "something" you tried, and the details of "didn't work", we could probably fix you right up. I, and I think others, suspect that your concept of 'schema', 'database', and 'instance' are incorrect and leading you down a rabbit hole. They don't mean the same thing in oracle as they do in MSSQL) Commented Jun 18, 2020 at 1:06

1 Answer 1

Reset to default
1

You need either to use :

  1. DBCA : recommended because easier. See example (this assumes that Oracle executables have already been installed).

or

  1. CREATE DATABASE SQL statement with SQL*Plus: more complex.
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.