› Fóruns › Banco de dados Oracle › ORA-12154: TNS:could not resolve the connect identifier spec › ORA-12154: TNS:could not resolve the connect identifier spec
11 de março de 2009 às 3:42 pm
#85719
Participante
Aconteceu comigo:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Resolvi assim:
export ORACLE_SID=mydb ###Unix/Linux
sqlplus sys as sysdba
SQL> startup mount