This discussion is archived
1 2 Previous Next 28 Replies Latest reply: Apr 18, 2012 4:42 PM by EdStevens Go to original post RSS
  • 15. Re: TNS error adaplter
    923096 Newbie
    Currently Being Moderated
    OracleOraDb11g_home1TNSListener is running and OracleOraDb11g_home1ClrAgent is running. That is all.
  • 16. Re: TNS error adaplter
    sb92075 Guru
    Currently Being Moderated
    user8894354 wrote:
    OracleOraDb11g_home1TNSListener is running and OracleOraDb11g_home1ClrAgent is running. That is all.
    The Agent Service can be ignored.
    A Service for the Database itself need to be running.

    research the "oradim" utility

    what is ORACLE_SID for the database?
  • 17. Re: TNS error adaplter
    923096 Newbie
    Currently Being Moderated
    ORACLE_SID=orcl
    ORADIM -NEW -SID orcl

    Edited by: user8894354 on 2012-04-17 13:24
  • 18. Re: TNS error adaplter
    sb92075 Guru
    Currently Being Moderated
    user8894354 wrote:
    ORACLE_SID=orcl
    ORADIM -NEW -SID orcl

    Edited by: user8894354 on 2012-04-17 13:24
    did the new Service Start?
    open Command Window & type as below

    sqlplus
    / as sysdba
    startup
    exit

    COPY commands & results then PASTE all back here
  • 19. Re: TNS error adaplter
    923096 Newbie
    Currently Being Moderated
    C:\Documents and Settings\Mariano>sqlplus

    SQL*Plus: Release 11.2.0.1.0 Production on Wt Kwi 17 22:37:02 2012

    Copyright (c) 1982, 2010, Oracle. All rights reserved.

    Proszŕ podaŠ nazwŕ u┐ytkownika: / as sysdba
    Po│╣czono z nieaktywn╣ instancj╣. -connect with no active instance

    SQL> startup
    ORA-01078: failure in processing system parameters
    LRM-00109: nie mo?na otworzy? pliku parametr?w 'F:\APP\MARIANO\PRODUCT\11.2.0\DB - can not open file with parameters 'F....'
    HOME_1\DATABASE\INITORCL.ORA'
    SQL> exit
    Roz│╣czono - disconnect

    C:\Documents and Settings\Mariano>

    Edited by: user8894354 on 2012-04-17 13:45
  • 20. Re: TNS error adaplter
    sb92075 Guru
    Currently Being Moderated
    user8894354 wrote:
    C:\Documents and Settings\Mariano>sqlplus

    SQL*Plus: Release 11.2.0.1.0 Production on Wt Kwi 17 22:37:02 2012

    Copyright (c) 1982, 2010, Oracle. All rights reserved.

    Proszŕ podaŠ nazwŕ u┐ytkownika: / as sysdba
    Po│╣czono z nieaktywn╣ instancj╣. -connect with no active instance

    SQL> startup
    ORA-01078: failure in processing system parameters
    LRM-00109: nie mo?na otworzy? pliku parametr?w 'F:\APP\MARIANO\PRODUCT\11.2.0\DB - can not open file with parameters 'F....'
    HOME_1\DATABASE\INITORCL.ORA'
    SQL> exit
    Roz│╣czono - disconnect

    C:\Documents and Settings\Mariano>

    Edited by: user8894354 on 2012-04-17 13:45
    Progress has been made! No longer throwing SQL*Net related errors.

    Does file below exist?
    'F:\APP\MARIANO\PRODUCT\11.2.0\DBHOME_1\DATABASE\INITORCL.ORA'
    the pathname above may be incorrect
    does %ORACLE_HOME%\DATABASE\INITORCL.ORA file exist?
    If so post its content
    FIND file alert_ORCL.log & post tail end of the file showing the startup errors
  • 21. Re: TNS error adaplter
    923096 Newbie
    Currently Being Moderated
    I haven't got that file- it isn't exist.
  • 22. Re: TNS error adaplter
    sb92075 Guru
    Currently Being Moderated
    user8894354 wrote:
    I haven't got that file- it isn't exist.
    post a long directory listing of the \DATABASE folder
  • 23. Re: TNS error adaplter
    923096 Newbie
    Currently Being Moderated
    In database's folder I have only one empty folder: archive
  • 24. Re: TNS error adaplter
    EdStevens Guru
    Currently Being Moderated
    user8894354 wrote:
    In database's folder I have only one empty folder: archive
    Have you actually created a database? It's looking like all you did was install the oracle software.
  • 25. Re: TNS error adaplter
    923096 Newbie
    Currently Being Moderated
    Yes, I have only installed Oracle sofware. OK but I can't login so can't create new database...
  • 26. Re: TNS error adaplter
    sb92075 Guru
    Currently Being Moderated
    user8894354 wrote:
    Yes, I have only installed Oracle sofware. OK but I can't login so can't create new database...
    use the "dbca" utility to CREATE DATABASE
  • 27. Re: TNS error adaplter
    923096 Newbie
    Currently Being Moderated
    Yes of course. When I install 11.1 it is create automaticlly so I even don't think about create database here. Sorry.
    OK.It is works. Thanks for everybody for posts. And sorry for the problem.

    Edited by: user8894354 on 2012-04-18 12:57
  • 28. Re: TNS error adaplter
    EdStevens Guru
    Currently Being Moderated
    user8894354 wrote:
    Yes of course. When I install 11.1 it is create automaticlly
    Only if you make the selection to as you are running the installer. Creating a 'starter' database at software installation time has been a user-selectable option since at least v. 7

    so I even don't think about create database here. Sorry.
    OK.It is works. Thanks for everybody for posts. And sorry for the problem.

    Edited by: user8894354 on 2012-04-18 12:57
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points