How to run SQL on the deployment server local Oracle database.

Have you ever needed to connect directly to the local Oracle Planner database on the deployment server? Maybe you need to change server names or update the ESU list. It's actually pretty easy when you remember one simple step.

But first - Did you know that the planner database is a full version of Oracle Enterprise Edition (EE)? Yes, it's true. It does have a significant restriction though: You can only use it for the E1 planner database. If you want to put anything on that database that is not the planner metadata you will have to pay $47,000 for a full EE license.

Now, how do you get logged in to the local Planner database to run some SQL? To get started, let's try logging in to a planner DB without doing anything special. Open a command window and enter the following command:

sqlplus / as sysdba

In this example, the ORA-01031 error means you are not in the Windows “Oracle DBA Group”. To fix this, you need to add your user to the group. Open up Server Manager and go to Configuration/Local Users and Groups/Groups.

Find the group ora_dba and double click it:

In there click Add, find your name, and click OK. You’ll see your name in the Members: list now. Click OK

Close out of the command window you were using before and open a new one. Try to connect to sqlplus again:

There you go! You’re now connected to the planner database.