This discussion is archived
1 2 3 4 6 Previous Next 78 Replies Latest reply: Jan 6, 2013 6:34 AM by 955912 Go to original post RSS
  • 15. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Hi JUSTIN ;

    Not able to  connect to the database without entering a user name and password.

    +[oracle@localhost ~]$ . .bash_profile+
    +[oracle@localhost ~]$ sqlplus /+

    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 19 03:56:59 2012

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

    ERROR:
    ORA-01017: invalid username/password; logon denied

    Enter user-name:

    Edited by: 952909 on Dec 18, 2012 2:30 PM
  • 16. Re: sqlnet.ora Network Configuration File " parameters  missing"
    Justin Cave Oracle ACE
    Currently Being Moderated
    Right. Because, as I said previously, you created an operating system authenticated account and then altered that account to be a database authenticated account. If you really want to end up with a database authenticated account, there is no need to create it as an operating system authenticated account initially. If you really want to end up with an operating system authenticated account, there is no reason to alter the user after it is created to make it a database authenticated account.

    Justin
  • 17. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Hi Justin ;

    I  am  getting confused , Can you provide little demo , Please ....
  • 18. Re: sqlnet.ora Network Configuration File " parameters  missing"
    Justin Cave Oracle ACE
    Currently Being Moderated
    A demo of what, exactly? I linked to an AskTom article that includes a demo of creating an operating system authenticated user.

    Is your intention to create an operating system authenticated user? If so, and assuming that everything else is configured correctly, simply stop before you alter the user to make it a database authenticated user
    SQL> drop user ops$sham
    2 /
    User dropped.
    
    SQL> CREATE USER ops$sham IDENTIFIED EXTERNALLY;
    User created.
    
    SQL> GRANT CONNECT TO ops$sham;
    Grant succeeded.
    
    SQL> grant dba to ops$sham;
    Grant succeeded.
    Justin
  • 19. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Thanks Justin to clarify. Every reply i am getting new things ..

    From Your answer :

    If i won't  use alter user command =  i  can't into ORACLE DB.
    Without username & password =   i  can't into ORACLE DB.

    If i cant enter , what is the need to create  database authenticated user.

    Same error  like my previous reply

    +[oracle@localhost ~]$ sqlplus /+

    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 19 04:52:54 2012
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    ERROR:

    ORA-01017: invalid username/password; logon denied
    Enter user-name: ops$sham
    Enter password:

    ERROR:
    ORA-01017: invalid username/password; logon denied

    What i know from your reply ( AS i did from local SERVER DB)
    Database authenticated user can't enter into DB.

    Thanks JUSTIN !!
  • 20. Re: sqlnet.ora Network Configuration File " parameters  missing"
    Justin Cave Oracle ACE
    Currently Being Moderated
    What is your OS_AUTHENT_PREFIX?

    Justin
  • 21. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Is this your expectation ?

    SQL> show parameter OS_AUTHENT_PREFIX

    NAME TYPE VALUE
    os_authent_prefix string ops$

    Edited by: 952909 on Dec 18, 2012 3:55 PM
  • 22. Re: sqlnet.ora Network Configuration File " parameters  missing"
    Justin Cave Oracle ACE
    Currently Being Moderated
    And you are sure that you have set your SQLNET.AUTHENTICATION_SERVICES to ALL? Do you have multiple Oracle Homes on the machine?

    I'm also assuming that you are logged in to the Unix server as the Unix user sham.

    Justin

    Edited by: Justin Cave on Dec 18, 2012 7:03 PM
  • 23. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Hi JUSTIN ;

    SQLNET.ORA  CONTENT

    # sqlnet.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DIRECTORY_PATH= (LDAP)
    SQLNET.AUTHENTICATION_SERVICES=all
    ~

    +[oracle@localhost ~]$ whoami+
    oracle

    +[oracle@localhost ~]$ echo $ORACLE_HOME+
    +/u01/app/oracle/product/10.2.0/db_1+

    only 10g installed but having 5 databases. Still  only test database is running.
  • 24. Re: sqlnet.ora Network Configuration File " parameters  missing"
    Justin Cave Oracle ACE
    Currently Being Moderated
    You're logged in to the database server as the Unix user "oracle". If you want to create an externally authenticated account ops$foo, you would need to be logged in to the database server as the Unix user "foo" in order for the externally authenticated account to work.

    Justin
  • 25. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Hi JUSTIN ;


    Getting ERROR

    Creating foo user in oracle DB

    SQL> CREATE USER ops$foo IDENTIFIED EXTERNALLY;
    User created.

    SQL> GRANT CONNECT TO ops$foo;
    Grant succeeded.

    SQL> grant dba to ops$sham;
    Grant succeeded.

    Creating foo user  by ROOT  in linux

    [oracle@localhost ~]$ su -
    Password:

    [root@localhost ~]# passwd foo
    Changing password for user foo.
    New UNIX password:
    BAD PASSWORD: it's WAY too short
    Retype new UNIX password:
    passwd: all authentication tokens updated successfully.

    Setting bash_profile as oracle user

    [foo@localhost ~]$ su - oracle
    Password:
    [oracle@localhost ~]$ . .bash_profile

    Enter as foo user

    [oracle@localhost ~]$ su - foo
    Password:

    *[foo@localhost ~]$ sqlplus /*
    -bash: sqlplus: command not found

    Edited by: 952909 on Dec 18, 2012 4:37 PM

    Edited by: 952909 on Dec 18, 2012 4:38 PM
  • 26. Re: sqlnet.ora Network Configuration File " parameters  missing"
    EdStevens Guru
    Currently Being Moderated
    952909 wrote:
    Hi JUSTIN ;


    Getting ERROR

    Creating foo user in oracle DB

    SQL> CREATE USER ops$foo IDENTIFIED EXTERNALLY;
    User created.

    SQL> GRANT CONNECT TO ops$foo;
    Grant succeeded.

    SQL> grant dba to ops$sham;
    Grant succeeded.

    Creating foo user  by ROOT  in linux

    [oracle@localhost ~]$ su -
    Password:

    [root@localhost ~]# passwd foo
    Changing password for user foo.
    New UNIX password:
    BAD PASSWORD: it's WAY too short
    Retype new UNIX password:
    passwd: all authentication tokens updated successfully.

    Setting bash_profile as oracle user

    [foo@localhost ~]$ su - oracle
    Password:
    [oracle@localhost ~]$ . .bash_profile

    Enter as foo user

    [oracle@localhost ~]$ su - foo
    Password:

    *[foo@localhost ~]$ sqlplus /*
    -bash: sqlplus: command not found
    Sigh!

    There is no executable file by the name of 'sqlplus' located in any directory listed in the current value of the environment variable named PATH.
    Connect to the server as os user 'oracle" and issue the following
    {code}
    id
    env |grep ORA| sort
    env |grep PATH
    su - foo
    id
    env |grep ORA| sort
    env |grep PATH
    {code}

    Compare and contrast the results for 'oracle' vs. the results for 'foo'
    Ask yourself "how do I make 'foo' look like 'oracle'"?
    Edited by: 952909 on Dec 18, 2012 4:37 PM

    Edited by: 952909 on Dec 18, 2012 4:38 PM
  • 27. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Hi EdStevens

    Not able to connect to the database without entering a user name and password.

    [oracle@localhost ~]$ sqlplus /

    SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 22 19:12:30 2012
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
    ERROR:
    ORA-01017: invalid username/password; logon denied

    but i can connect like this ,

    [oracle@localhost ~]$ sqlplus

    SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 22 19:12:17 2012
    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Enter user-name: ops$sham
    Enter password:
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options

    Note : Most of the web links saying either we can choose to connect with DB.
    I want to know the difference why this command sqlplus /  showing error
  • 28. Re: sqlnet.ora Network Configuration File " parameters  missing"
    sb92075 Guru
    Currently Being Moderated
    952909 wrote:
    Hi EdStevens

    Not able to connect to the database without entering a user name and password.

    [oracle@localhost ~]$ sqlplus /

    SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 22 19:12:30 2012
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
    ERROR:
    ORA-01017: invalid username/password; logon denied

    but i can connect like this ,

    [oracle@localhost ~]$ sqlplus

    SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 22 19:12:17 2012
    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Enter user-name: ops$sham
    Enter password:
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options

    Note : Most of the web links saying either we can choose to connect with DB.
    I want to know the difference why this command sqlplus /  showing error
    ORA-01017: invalid username/password; logon denied
    you are NOT providing valid username/password & OS user is NOT member of correct OS group
  • 29. Re: sqlnet.ora Network Configuration File " parameters  missing"
    EdStevens Guru
    Currently Being Moderated
    952909 wrote:
    Hi EdStevens

    Not able to connect to the database without entering a user name and password.
    Yes, we know. You've said that in almost every post you've made to this thread. We got that. Believe me, we understand that. Can we move on to solving your problem?

    [oracle@localhost ~]$ sqlplus /

    SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 22 19:12:30 2012
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
    ERROR:
    ORA-01017: invalid username/password; logon denied
    Because whatever OS account you are logged on as does not have a matching OS AUTHENTICATED account in the database.
    but i can connect like this ,

    [oracle@localhost ~]$ sqlplus

    SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 22 19:12:17 2012
    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Enter user-name: ops$sham
    Enter password:
    Connected to:
    Because, in spite of the 'ops$' ... ops$sham is NOT an OS authenticated account. It is a database authenticated account. It is a database authenticated account because you gave it a password. From your earlier post to Justin:

    --- begin quote of earlier post ----

    SQL> CREATE USER ops$sham IDENTIFIED EXTERNALLY;
    User created.
    --- suspend quote ---

    ok, at this point you have an os authenticated account "ops$sham".

    --- continue quote ---
    SQL> GRANT CONNECT TO ops$sham;
    Grant succeeded.
    --- suspend quote ---

    Now, the os account "sham" should be able to connect with a simple "sqlplus /"


    --- continue quote ---
    SQL> grant dba to ops$sham;
    Grant succeeded.
    --- suspend quote ---

    Now, anyone using the os account "sham" can connect without a password and have all the privileges listed in the role "dba"

    --- continue quote ---
    SQL> alter user ops$sham identified by shamos;
    User altered.
    --- end quote ---

    But now you altered your account 'ops$sham' and gave it a password. ops$sham is no longer an os authenticated account. It is now a database authenticate account, albeit one with a rather deceptive name. From this point forward, if you attempt to connect as 'ops$sham', you will have to supply a password.


    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options

    Note : Most of the web links saying either we can choose to connect with DB.
    I want to know the difference why this command sqlplus /  showing error
    Because you are tying to use os authentication with an os account that does not have an os authenticated account in the database. Putting "ops$" on the account name is NOT what makes it an os authenticated account. What makes it os authenticated is defining the account as "identified externally". If you create it as "identified by somepassword", OR if you ALTER it to "identified by somepassword" then it is NOT os authenticated.
1 2 3 4 6 Previous Next

Legend

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