How can Oracle change the SID?

F

FX-Mercury2015-03-30 09:03:58

Database

FX-Mercury, 2015-03-30 09:03:58

I am using Oracle Database 10g Express Edition. You need to change SID = XE to SID = ORCL
And another error occurs: ora - 12505, when connecting to the database from a program written in Delphi
Before installing Oracle 10g, I had Oracle 11g. I could not set up Apex in it, so I demolished it.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

R

Roman_ Outside, 2015-04-03
@FX-Mercury

the ORACLE_SID variable is set in the terminal via set ORACLE_SID=orcli, so you can work in the terminal window with an ORCLI instance (case insensitive). You can view the current ORACLE_SID using sqlplus / as sysdba - log in with DBA rights and execute the select instance from v$thread query. And how to change the SID is described here - baks.gaz.ru/oradoc/ora/ora353.htm