Pular para o conteúdo

› 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
paulolot
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