This discussion is archived
1 2 3 4 5 6 Previous Next 78 Replies Latest reply: Jan 6, 2013 6:34 AM by 955912 Go to original post RSS
  • 30. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    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"
    Justin Cave Oracle ACE
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

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