This discussion is archived
1 2 3 6 Previous Next 78 Replies Latest reply: Jan 6, 2013 6:34 AM by 955912 RSS

sqlnet.ora Network Configuration File " parameters  missing"

955912 Explorer
Currently Being Moderated
Hello Gurus;

Just now i create sqlnet,ora  through NETCA
My  SQLNET.ora contains following informations only..


# 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= (TNSNAMES)


*>> Help me >>*
why it did n't display all parameters ? Anything wrong here ?
I need to set SQLNET.AUTHENTICATION_SERVICES = NONE
  • 1. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Hello to all;

    Using netca i could n't create "sqlnet.ora" , Any other way to create sqlnet.ora file.
  • 2. Re: sqlnet.ora Network Configuration File " parameters  missing"
    IBarr Explorer
    Currently Being Moderated
    You can manually add the parameters you need to the sqlnet.ora file.

    regards,

    Iain Barr
    Ategrity Solutions Ltd.
  • 3. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Hi IBarr ;

    i want to include this one SQLNET.AUTHENTICATION_SERVICES=all.

    Should i include any thing except my required parameter ?

    I included that parameter , actually i tried to set OS authentication for local database server.

    SQL> CREATE USER ops$sham IDENTIFIED by shamos
    SQL> GRANT CONNECT TO ops$sham;
    SQL> GRANT DBA TO ops$sham;

    *$ . .bash_profile*
    sqlplus /

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 18 20:53:43 2012
    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory

    Enter user-name: ops$sham
    Enter password:
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory
  • 4. Re: sqlnet.ora Network Configuration File " parameters  missing"
    EdStevens Guru
    Currently Being Moderated
    952909 wrote:
    Hi IBarr ;

    i want to include this one SQLNET.AUTHENTICATION_SERVICES=all.

    Should i include any thing except my required parameter ?

    I included that parameter , actually i tried to set OS authentication for local database server.

    SQL> CREATE USER ops$sham IDENTIFIED by shamos
    SQL> GRANT CONNECT TO ops$sham;
    SQL> GRANT DBA TO ops$sham;

    *$ . .bash_profile*
    sqlplus /

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 18 20:53:43 2012
    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory

    Enter user-name: ops$sham
    Enter password:
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory
    And what did you discover when you googled "ORA-01034" and "ORA-27101"?

    From a shell command prompt, enter the following:
    id
    env | grep ORA | sort
    ps -ef|grep pmon
    sqlplus / as sysdba
    copy the entire session, commands and responses, and past back here.


    -- edit
    added check of processes to requested info (ps -ef)

    Edited by: EdStevens on Dec 18, 2012 12:01 PM
  • 5. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Hi to all;

    I tried  to set authentication externally  :

    I created sham  user for OS authentication (LOCAL SERVER DB ):

    SQL> CREATE USER ops$sham IDENTIFIED by shamos
    SQL> GRANT CONNECT TO ops$sham;
    SQL> GRANT DBA TO ops$sham

    then normally i shut test DB.


    $ . .bash_profile
    $ sqlplus /

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 18 20:53:43 2012

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

    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist

    Linux Error: 2: No such file or directory
    Enter user-name: ops$sham
    Enter password:
    ERROR:

    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory

    TO EdStevens

    $ id
    uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)

    [oracle@localhost ~]$ env | grep ORA | sort
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
    ORACLE_SID=test
    ORACLE_TERM=xterm

    [oracle@localhost ~]$ ps -ef|grep pmon
    oracle 5508 5348 0 23:43 pts/1 00:00:00 grep pmon

    [oracle@localhost ~]$ sqlplus / as sysdba
    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 18 23:45:18 2012
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
    Connected to an idle instance.
  • 6. Re: sqlnet.ora Network Configuration File " parameters  missing"
    Justin Cave Oracle ACE
    Currently Being Moderated
    If you shut down the database then, naturally, you cannot connect to the database as a normal user. The Oracle error message is reasonably clear-- the database is not available because the instance has been shut down. You would need to start up the database before you could connect (and you really shouldn't have shut the database down in the first place).

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

    I am n't clear . Sorry for disturbing You. As a normal user i can't startup my DB.
    I  connected as sysdba and started up my DB.

    SQL> show user;
    USER is "SYS"

    SQL> select username from all_users;

    USERNAME
    ------------------------------
    OPS$SHAM
    +............+
    +............+


    Already i  done  before shut my DB.

    SQL> CREATE USER ops$sham IDENTIFIED by shamos
    SQL> GRANT CONNECT TO ops$sham;
    SQL> GRANT DBA TO ops$sham;


    Step 2:
    I opened another terminal.
    Why i cant enter into DB as ops$sham

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

    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 19 01:04:17 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

    Enter user-name:

    Note : password corretly given , then why oracle ignored ?

    Thanks for nice reply..

    Edited by: 952909 on Dec 18, 2012 11:37 AM
  • 8. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Hi to all;

    Should i update anything in sqlnet.ora file but
    already i set SQLNET.AUTHENTICATION_SERVICES =ALL in sqlnet.ora file ..
  • 9. Re: sqlnet.ora Network Configuration File " parameters  missing"
    Justin Cave Oracle ACE
    Currently Being Moderated
    First off,
    SQL> CREATE USER ops$sham IDENTIFIED by shamos
    does not create an externally authenticated user. It creates an Oracle authenticated user that happens to be named ops$sham. If you want to create an externally authenticated user
    SQL> CREATE USER ops$sham IDENTIFIED EXTERNALLY
    And this assumes that you have set your OS_AUTHENT_PREFIX to OPS$.

    See, for example, this askTom thread

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

    Thanks for kind reply .. I done it !!

    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.

    SQL> alter user ops$sham identified by shamos;
    User altered.


    STEP2:
    OPENED another terminal :

    $ . .bash_profile

    [oracle@localhost ~]$ sqlplus
    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 19 01:48:37 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

    SQL>show user;
    USER is "OPS$SHAM"
  • 11. Re: sqlnet.ora Network Configuration File " parameters  missing"
    955912 Explorer
    Currently Being Moderated
    Hello GURUS

    However i done os authentication to DBA.

    but one more yet not finished ... i.e.   "SQLNET.ORA"
    MAY I know another one type of authentication  i.e.

    If i set , SQLNET.AUTHENTICATION_SERVICES =all

    Please  guide me , how can i  do that  ....
  • 12. Re: sqlnet.ora Network Configuration File " parameters  missing"
    Justin Cave Oracle ACE
    Currently Being Moderated
    Are you trying to create an operating system authenticated account? You create an operating system authenticated account then you change that account to be a database authenticated account. Then you verify that you can log in to the database authenticated account. This doesn't show anything related to an operating system authenticated account.

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

    Really i tried to set authentication like this .,

    Facts About Operating System Authentication
    Syntax is used while OS Authentication

    sqlplus / as sysdba

    2. A SQLNET.AUTHENTICATION_SERVICES controls the operation system authentication.
    eg : SQLNET.AUTHENTICATION_SERVICES=(ALL) will allow the OS authentication

    SQLNET.AUTHENTICATION_SERVICES=(NONE) will fail the OS authentication
    " Connect internal " is not supported now , instead of which one should use " connect / as sysdba " to authenticated to the database .

    PLEASE SEE this LINK :
    REF link : http://oradbastuff.blogspot.in/2011/03/ora-01031-insufficient-privilege-while.html

    So  i updated "sqlnet.ora"  i  faced problems so i  started  this thread

    NOTE : ARE YOU GETTING WHAT's MY CURRENT GOAL ?

    Thanks  JUSTIN
  • 14. Re: sqlnet.ora Network Configuration File " parameters  missing"
    Justin Cave Oracle ACE
    Currently Being Moderated
    952909 wrote:
    NOTE : ARE YOU GETTING WHAT's MY CURRENT GOAL ?
    I'm not sure. That's why I asked you if your intention is to create an operating system authenticated account. That's why I explained that I was confused when you created an operating system authenticated account and then altered that account so that it became a database authenticated account.

    I'm guessing that you want to create an operating system authenticated account so that you can log in to your Unix account on the database server, run the command
    sqlplus / 
    and be connected to the database without entering a user name and password. That's not what you did, though, and you indicated that you were successful in doing whatever you were attempting to do so perhaps my guess at what you are attempting to do is incorrect.

    Justin
1 2 3 6 Previous Next

Legend

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