1 person found this helpful
I would expect you have both a Primary and Standby INIT file and you are showing the correct one.
From the information you posted I'm guessing either you did not try to start the database with a user with SYSDBA for example SYSTEM won't work. Or you set your SID incorrectly.
As of now I do not have standby INIT file and one which INIT file which I am showing here that's for my primary database i.e mydb. I would like to let you know I am planning to implement dataguard where mydb would be my primary database ad orcl would be my stabd by database. Before creating standby database I am preparing all initilization parameter in my primary database.
I have started my database with SYSDBA but still getting the same error. Please check below:
[oracle@localhost ~]$ . oraenv
ORACLE_SID = [oracle] ? mydb
The Oracle base for ORACLE_HOME=/u01/home/oracle/product/11.2.0/db_1 is /u01/app/oracle
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 220.127.116.11.0 Production on Sun Jan 5 00:15:12 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
ORA-01506: missing or illegal database name