sometimes the oracle profile is not prepared correctly and this give so many errors and you should go direct to directory of SqlPlus to start DB
/u01/app/oracle/product/11.2.0/dbhome_1/bin
./sqlplus sys/password as sysdba;
the following error will arises
ORA-12162 TNS:net service name is incorrectly specified
Cause
This arises if you have not set ORACLE_HOME and ORACLE_SID.
Solution
you can fix it by setting the ORACLE_HOME and ORACLE_SID as following
> export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 > export ORACLE_SID=ECMTEST and try to start the DB ./sqlplus sys/password as sysdba; sql> startup force;
Advertisements
Thanks for the quick fix.
thanks, for the quick fix, you are the best