5 Replies Latest reply: Jul 20, 2011 12:17 AM by 876653 RSS

    Connection Failed

    RRA
      Hi all,
      i 've oracle db 10g , Reports builder 10g(Report Builder 9.0.4.0.33) in my machine, having OS Windows Vista Ultimate.
      my db is running. but when i try to connect from Report builder to db, error is coming.

      Rep-0501: Unable to connect to specified database.
      Ora-12154: TNS :could not resolve the connect identifier specified.

      I also opened Devhome>Configuration & Migration Tools>NET MANAGER & specified the SERVICE NAME : orcl ,which is my db instance.
      finally specified the listerner locations.

      wt adjustment need to set? kindly help me.

      regards,
        • 1. Re: Connection Failed
          DC
          did you add orcl into your Reports Builder intalled tnsname.ora?
          • 2. Re: Connection Failed
            RRA
            hi,
            no i didnot? how i set this and where this tnsname.ora file located in my machine?

            regards
            • 3. Re: Connection Failed
              RRA
              Hi,
              i ve put the tnsnames.ora & sqlnet.ora file in 'oradevhome->network->admin' folder. In tnsnames.ora i provided the connection information for my 'orcl' instance.
              but fm connecting to Form Builder again another error is coming -

              Rep-0504: Unable to connect to specified database
              Ora-00604: Error occurred at recursive SQL LEVEL
              • 4. Re: Connection Failed
                DC
                What do you get from "tnsping orcl" on Wibndows commander Prompt?
                • 5. Re: Connection Failed
                  876653
                  Hi ,

                  One of my friend got the same problem in rwconverter.sh .. SO set the below environment as mention in DOC ID:444248.1

                  unset EVENT_10932
                  unset DE_DISABLE_PLS_512
                  Open $ORACLE_HOME/bin/reports.sh in a text editor and comment out the following lines.

                  TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
                  NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_

                  and run the rwconverter.sh command. It's sloved his problem.

                  Surya