7 Replies Latest reply: May 12, 2013 9:21 PM by Karan Kukreja RSS

    Unable to connect as user u1

    Biswaranjan
      Hi All,

      Unable connect as user u1 however after opening the "/u01/app/oracle/product/11.2.0/db_1/sqlplus" trhere were no /demo/demobld.sql file.

      SQL> grant connect,resource to u1;

      Grant succeeded.

      SQL> conn u1/u1;
      Connected.
      SQL> select * from tab;

      no rows selected

      SQL> @?/sqlplus/demo/demobld
      SP2-0310: unable to open file "/u01/app/oracle/product/11.2.0/db_1/sqlplus/demo/demobld.sql"


      Please help me out with this..

      Thanks and Regards,
      Biswaranjan
        • 1. Re: Unable to connect as user u1
          sb92075
          Biswaranjan wrote:
          Hi All,

          Unable connect as user u1 however after opening the "/u01/app/oracle/product/11.2.0/db_1/sqlplus" trhere were no /demo/demobld.sql file.

          SQL> grant connect,resource to u1;

          Grant succeeded.

          SQL> conn u1/u1;
          Connected.
          SQL> select * from tab;

          no rows selected

          SQL> @?/sqlplus/demo/demobld
          SP2-0310: unable to open file "/u01/app/oracle/product/11.2.0/db_1/sqlplus/demo/demobld.sql"


          Please help me out with this..

          Thanks and Regards,
          Biswaranjan
          issue OS command below (which will take a long time to complete)

          find / -name demobld.sql -ls 2>/dev/null

          post results back here
          • 2. Re: Unable to connect as user u1
            Biswaranjan
            [oracle@localhost ~]$ find / -name demobld.sql

            Permission denied

            Edited by: Biswaranjan on May 12, 2013 2:34 PM
            • 3. Re: Unable to connect as user u1
              sb92075
              Biswaranjan wrote:
              [oracle@localhost ~]$ find / -name demobld.sql -ls 2>/dev/nu
              -bash: /dev/nu: Permission denied
              It appears that COPY & PASTE are broken for you.

              Please maintain at least 2 meter separation between you & any keyboard until repairs have been completed.
              • 4. Re: Unable to connect as user u1
                Biswaranjan
                i didn't get u what do u mean.
                • 5. Re: Unable to connect as user u1
                  Biswaranjan
                  find: /proc/2535/task/2535/fd: Permission denied
                  find: /proc/2535/task/2535/fdinfo: Permission denied
                  find: /proc/2535/fd: Permission denied
                  find: /proc/2535/fdinfo: Permission denied
                  find: /proc/2536/task/2536/fd: Permission denied
                  find: /proc/2536/task/2536/fdinfo: Permission denied
                  find: /proc/2536/fd: Permission denied
                  find: /proc/2536/fdinfo: Permission denied
                  find: /proc/3028/task/3028/fd: Permission denied
                  find: /proc/3028/task/3028/fdinfo: Permission denied
                  find: /proc/3028/fd: Permission denied
                  find: /proc/3028/fdinfo: Permission denied
                  find: /proc/3103/task/3103/fd: Permission denied
                  find: /proc/3103/task/3103/fdinfo: Permission denied
                  find: /proc/3103/fd: Permission denied
                  find: /proc/3103/fdinfo: Permission denied
                  find: /proc/3123/task/3123/fd: Permission denied
                  find: /proc/3123/task/3123/fdinfo: Permission denied
                  find: /proc/3123/fd: Permission denied
                  find: /proc/3123/fdinfo: Permission denied
                  find: /proc/3195/task/3195/fd: Permission denied
                  find: /proc/3195/task/3195/fdinfo: Permission denied
                  find: /proc/3195/fd: Permission denied
                  find: /proc/3195/fdinfo: Permission denied
                  find: /proc/3221/task/3221/fd: Permission denied
                  find: /proc/3221/task/3221/fdinfo: Permission denied
                  find: /proc/3221/fd: Permission denied
                  find: /proc/3221/fdinfo: Permission denied
                  find: /proc/3230/task/3230/fd: Permission denied
                  find: /proc/3230/task/3230/fdinfo: Permission denied
                  find: /proc/3230/fd: Permission denied
                  find: /proc/3230/fdinfo: Permission denied
                  find: /proc/3241/task/3241/fd: Permission denied
                  find: /proc/3241/task/3241/fdinfo: Permission denied
                  find: /proc/3241/fd: Permission denied
                  find: /proc/3241/fdinfo: Permission denied
                  find: /proc/3244/task/3244/fd: Permission denied
                  find: /proc/3244/task/3244/fdinfo: Permission denied
                  find: /proc/3244/fd: Permission denied
                  find: /proc/3244/fdinfo: Permission denied
                  find: /proc/3246/task/3246/fd: Permission denied
                  find: /proc/3246/task/3246/fdinfo: Permission denied
                  find: /proc/3246/fd: Permission denied
                  find: /proc/3246/fdinfo: Permission denied
                  find: /proc/3249/task/3249/fd: Permission denied
                  find: /proc/3249/task/3249/fdinfo: Permission denied
                  find: /proc/3249/fd: Permission denied
                  find: /proc/3249/fdinfo: Permission denied
                  • 6. Re: Unable to connect as user u1
                    sb92075
                    there is no evidence that demobld.sql exists on your system.
                    demobld.sql does not exist on my system.
                    it appears that it is no longer included with the basic installation.
                    • 7. Re: Unable to connect as user u1
                      Karan Kukreja
                      Hi ,

                      Incase you are looking for this script , just google it and the second link will bring you this script.

                      Something like this :
                      www.cs.utexas.edu/users/cannata/dbms/Downloads/demobld.sqlCached
                      Regards
                      Kk