Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to change oracle sid name in 19c database

SQL> STARTUP MOUNT

ORACLE instance started.

Total System Global Area 8754618368 bytes
Fixed Size 4646288 bytes
Variable Size 3556776560 bytes
Database Buffers 5033164800 bytes
Redo Buffers 160030720 bytes
Database mounted.
SQL> select name,open_mode from v$database;

NAME OPEN_MODE
--------- --------------------
P2PRMD2 MOUNTED
Source by dbaclass.com #
 
PREVIOUS NEXT
Tagged: #change #oracle #sid #database
ADD COMMENT
Topic
Name
2+2 =