ORA-01078 error example: SID case-insensitive Error

Repeat the case:

Dbca database creation, SID: metro-metro with lower-case Instance name when manual database creation

......

[Oracle @ org54 ~] $ Export ORACLE_SID = METRO -- manually inject SID because no environment variable is set

[Oracle @ org54 ~] $ Sqlplus '/as sysdba' -- log on to sqlplus

SQL * Plus: Release 10.2.0.1.0-Production on Thu Jun 12 09:15:16 2014

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup -- start the database. The following error is returned, indicating that the pfile file cannot be found.

ORA-01078: failure in processing system parameters

LRM-00109: cocould not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initMETRO. ora'

[Oracle @ org54 ~] $ Cd/u01/app/oracle/product/10.2.0/db_1/dbs -- go to the parameter file directory to view

[Oracle @ org54 dbs] $ ls -- The spfile file is found, but the database prompt is not found. Note that the SID settings are case sensitive in environment variable configuration, because the manual database creation is performed in lower case, the environment variables must be configured in lower case.
Hc_metro.dat initdw. ora init. ora lkMETRO orapwmetro spfilemetro. ora

[Oracle @ org54 dbs] $ export ORACLE_SID = metro -- reset the environment variable and inject the lowercase SID
[Oracle @ org54 dbs] $ sqlplus '/as sysdba'

SQL * Plus: Release 10.2.0.1.0-Production on Thu Jun 12 09:18:33 2014

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup -- start Database
ORACLE instance started.

Total System Global Area 343932928 bytes
Fixed Size 1219328 bytes
Variable Size 109053184 bytes
Database Buffers 230686720 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.

Database startup complete

Summary:

The SID entered during dbca database creation must be exactly the same as the SID When system environment variables are configured, including case sensitivity.