1 2 3 4 5 6 Previous Next 78 Replies Latest reply: Jan 6, 2013 8:34 AM by 955912 Go to original post RSS
      • 30. Re: sqlnet.ora Network Configuration File " parameters  missing"
        955912
        Hi Steve ;

        Thanks to reply. I could n't explain with my juniors ... kindly help me ..

        create user OPS$SCOTT identified by TIGER;

        This will create a user named OPS$SCOTT as a regular user. However, the use of OPS$ in the name makes it externally identifiable too. The OS user SCOTT can login as

        sqlplus ops$scott/tiger
        Or
        sqlplus /

        Note that the account can be accessed either way ..

        Ref :  http://www.dba-oracle.com/security/local_os_authentication.htm

        Note : I have problem with this task with my trainees.
        Please leave ops$sham account , Any one account what's the clear procedure to connect with DB only using " sqlplus /"
        • 31. Re: sqlnet.ora Network Configuration File " parameters  missing"
          JustinCave
          what's the clear procedure to connect with DB only using " sqlplus /"
          1) Create an operating system account FOO whose profile is set up to be able to use SQL*Plus and to have the appropriate Oracle environment variables set.
          2) Set the OS_AUTHENT_PREFIX to something if it is not already set. We'll assume this is set to OPS$
          3) Create the operating system authenticated account
          CREATE USER ops$foo AUTHENTICATED EXTERNALLY;
          GRANT CONNECT TO ops$foo
          4) Log in to the Unix server as the operating system user FOO
          5) Connect to Oracle
          sqlplus /
          Tim Hall (as usual) also has a nice demo here

          Justin
          • 32. Re: sqlnet.ora Network Configuration File " parameters  missing"
            955912
            Hi Justin ;

            Given link really usefu to me ... Now i have clarity about os authentication

            Please help me to troubleshoot following error when connecting sqlplus /

            [root@localhost ~]# su - foo
            [foo@localhost ~]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
            [foo@localhost ~]$ export PATH=$PATH:$ORACLE_HOME/bin
            [foo@localhost ~]$ export ORACLE_SID=test
            *[foo@localhost ~]$ sqlplus /*
            sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
            • 33. Re: sqlnet.ora Network Configuration File " parameters  missing"
              955912
              My bash_profile settings


              # User specific environment and startup programs

              PATH=$PATH:$HOME/bin

              export PATH
              unset USERNAME
              # Oracle Settings
              TMP=/tmp; export TMP
              TMPDIR=$TMP; export TMPDIR

              ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
              ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
              ORACLE_SID=test;export ORACLE_SID
              ORACLE_TERM=xterm; export ORACLE_TERM
              PATH=/usr/sbin:$PATH; export PATH
              PATH=$ORACLE_HOME/bin:$PATH; export PATH

              LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
              CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
              #LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL

              if [ $USER = "oracle" ]; then
              if [ $SHELL = "/bin/ksh" ]; then
              ulimit -p 16384
              ulimit -n 65536
              else
              ulimit -u 16384 -n 65536
              fi
              fi
              • 34. Re: sqlnet.ora Network Configuration File " parameters  missing"
                955912
                Hi to all ;

                Kindly help me to troubleshoot following error .. How can troubleshoot ?

                help me to troubleshoot following error when connecting sqlplus /

                [root@localhost ~]# su - foo
                [foo@localhost ~]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
                [foo@localhost ~]$ export PATH=$PATH:$ORACLE_HOME/bin
                [foo@localhost ~]$ export ORACLE_SID=test
                [foo@localhost ~]$ sqlplus /
                sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

                Even i set , following commands ,

                [foo@localhost ~]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
                [foo@localhost ~]$ export PATH=/usr/sbin:$PATH;
                [foo@localhost ~]$ export PATH=$PATH:$ORACLE_HOME/bin; export PATH
                [foo@localhost ~]$ export ORACLE_SID=test
                [foo@localhost ~]$ sqlplus /
                sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
                • 35. Re: sqlnet.ora Network Configuration File " parameters  missing"
                  sb92075
                  post results from LONG running OS command below

                  find / -name libsqlplus\* -ls 2>/dev/null
                  • 36. Re: sqlnet.ora Network Configuration File " parameters  missing"
                    955912
                    Hi ;

                    **as oracle user ;**

                    $ find / -name libsqlplus\* -ls 2>/dev/null
                    854895 1028 -rw-r----- 1 oracle oinstall 1047293 Jun 22 2005 /u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.so
                    854890 1296 -rw-r----- 1 oracle oinstall 1319436 Jun 22 2005 /u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.a
                    [oracle@localhost ~]$ whoami
                    oracle
                    [oracle@localhost ~]$

                    from foo user :-

                    No reply ..
                    • 37. Re: sqlnet.ora Network Configuration File " parameters  missing"
                      EdStevens
                      952909 wrote:
                      Hi ;

                      **as oracle user ;**

                      $ find / -name libsqlplus\* -ls 2>/dev/null
                      854895 1028 -rw-r----- 1 oracle oinstall 1047293 Jun 22 2005 /u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.so
                      854890 1296 -rw-r----- 1 oracle oinstall 1319436 Jun 22 2005 /u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.a
                      [oracle@localhost ~]$ whoami
                      oracle
                      [oracle@localhost ~]$

                      from foo user :-

                      No reply ..
                      What do you see int the permissions on the two files returned when you ran the "find" as oracle? Don't you see that the permissions are "rw" for oracle and "r" for members of the oinstall group, and no permissions at all for anyone else? I'll bet a Christmas cookie that os user foo is not a member of the os group 'oinstall'.

                      --- on checking my own standard, right out of the box sandbox installation, I see that those libsqlplus.* files should be rw-r--r--. Why does yours not have the 'read' bit set for 'other'? Looks more like whoever installed this did something, uh, non-standard. I'd investigate that before just jumping in to thinking all your ops$ users should be a member of the dba or oinstall group.

                      And while we're on the subject, why are you even messing with OS authentication? I've been at this since oracle 7.3 and have never used OS authentication for any account except 'oracle'. Others may disagree and I welcome their arguments, but my thinking has always been that very, VERY few people should have an OS account on the db server, so one should think long and hard about proliferating os authenticated accounts.

                      Edited by: EdStevens on Dec 22, 2012 2:59 PM

                      Edited by: EdStevens on Dec 22, 2012 3:01 PM
                      • 38. Re: sqlnet.ora Network Configuration File " parameters  missing"
                        955912
                        Hello Edstevens and Justin ;

                        Sorry for distrubing again and again ;

                        $ find / -name libsqlplus\* -ls 2>/dev/null

                        854895 1028 -rwxr-xr-x 1 oracle oinstall 1047293 Jun 22 2005 /u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.so
                        854890 1296 -rwxr-xr-x 1 oracle oinstall 1319436 Jun 22 2005 /u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.a

                        Trying to conect as foo

                        [oracle@localhost ~]$ su - foo
                        Password:
                        su: warning: cannot change directory to /home/foo: Permission denied
                        -bash: /home/foo/.bash_profile: Permission denied
                        -bash-3.00$
                        • 39. Re: sqlnet.ora Network Configuration File " parameters  missing"
                          EdStevens
                          952909 wrote:
                          Hello Edstevens and Justin ;

                          Sorry for distrubing again and again ;

                          $ find / -name libsqlplus\* -ls 2>/dev/null

                          854895 1028 -rwxr-xr-x 1 oracle oinstall 1047293 Jun 22 2005 /u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.so
                          854890 1296 -rwxr-xr-x 1 oracle oinstall 1319436 Jun 22 2005 /u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.a

                          Trying to conect as foo
                          And why did you make the permissions rwxr-xr-x? Didn't I tell you they should be rw-r--r-- ?
                          And did you find out WHY they were wrong in the first place? Most likely if those files were wrong, a boat-load of others is wrong also, just waiting to bite you.

                          [oracle@localhost ~]$ su - foo
                          Password:
                          su: warning: cannot change directory to /home/foo: Permission denied
                          -bash: /home/foo/.bash_profile: Permission denied
                          -bash-3.00$
                          Well, that one certainly isn't oracle's issue. That is purely an OS issue. What did you discover when you googled "su: warning: cannot change directory to /home/foo: Permission denied"?
                          • 40. Re: sqlnet.ora Network Configuration File " parameters  missing"
                            955912
                            Hi Evens ;

                            I spent much time because of need to say correct answer to my Juniors ..
                            what should i do ? I googled but i got links for different kind of problems ..

                            I spent  nearly 16 hours .. but  i need to resolve this ..
                            • 41. Re: sqlnet.ora Network Configuration File " parameters  missing"
                              955912
                              Hi Edevens ;

                              I want to confiirm only one ..
                              if i add user to oinstall group .. is it enough ?
                              As usual i will set set up environment variables to connect SQL*Plus.

                              If so , Already i did but getting Error. OS issue , what do you mean ?
                              • 42. Re: sqlnet.ora Network Configuration File " parameters  missing"
                                EdStevens
                                952909 wrote:
                                Hi Edevens ;

                                I want to confiirm only one ..
                                if i add user to oinstall group .. is it enough ?
                                As usual i will set set up environment variables to connect SQL*Plus.

                                If so , Already i did but getting Error. OS issue , what do you mean ?
                                "OS issue"
                                "OS"= means "Operating System"
                                The error was issued by the operating system shell command processor. It has nothing to do with oracle.

                                Surely if you googled "su warning cannot change directory permission denied" you would get some useful hits. In fact I know you would because I just did it myself.

                                Aside from that, what do you THINK would cause the OS to say "cannot change directory ... permission denied"? Don't you suppose it would indicate a problem with permissions on a directory, or one of its parent directories? What directory do you think is being accessed when you try to 'su - foo'?

                                When we looked at the problem with libsqlplus, didn't I say that there was a clear indication that you have a messed up installation? Did you do anything to follow up on that?

                                You keep mentioning that you need to give correct information to your "junior". What exactly is your job and your relationship to your "junior"? What is his job?
                                • 43. Re: sqlnet.ora Network Configuration File " parameters  missing"
                                  955912
                                  Hi ;

                                  We have 5 Databases for junior trainers . I tried to set OS authentication externally.
                                  End of the session , I down my DB , but i couldn't startup my database.
                                  In Testing(local server Databases) Audit dump not enabled. All database reflecting same error here ..
                                  what's the procedure to startup testdb.

                                  Error Details
                                  SQL> conn /as sysdba
                                  ERROR:
                                  ORA-09925: Unable to create audit trail file
                                  Linux Error: 13: Permission denied
                                  Additional information: 9925
                                  ORA-09925: Unable to create audit trail file
                                  Linux Error: 13: Permission denied
                                  Additional information: 9925
                                  • 44. Re: sqlnet.ora Network Configuration File " parameters  missing"
                                    sb92075
                                    952909 wrote:
                                    Hi ;

                                    We have 5 Databases for junior trainers . I tried to set OS authentication externally.
                                    End of the session , I down my DB , but i couldn't startup my database.
                                    In Testing(local server Databases) Audit dump not enabled. All database reflecting same error here ..
                                    what's the procedure to startup testdb.

                                    Error Details
                                    SQL> conn /as sysdba
                                    ERROR:
                                    ORA-09925: Unable to create audit trail file
                                    Linux Error: 13: Permission denied
                                    Additional information: 9925
                                    ORA-09925: Unable to create audit trail file
                                    Linux Error: 13: Permission denied
                                    Additional information: 9925
                                    UNIX: Checklist for Resolving Connect AS SYSDBA Issues NOTE: 69642.1.