sqlnet.ora file

Mine is Aix Sunsoloris.

I am trying to change the SQLNET.EXPIRE_TIME=20
 ===> pwd

I cannot find here
In an Aix server where can I find

===> ls
active|             maxreqs/            maxservers/         minservers/         server_inactivity/
Who is Participating?
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
I'm not clear on your question, but the SQLNET parameters are in the SQLNET.ORA file, which in turn defaults to the ORACLE_HOME/network/admin folder.  You may also find it with 'cd $TNS_ADMIN' if that variable is set.
Wasim Akram ShaikCommented:
Login with oracle user and do the following



CD $ORACLE_HOME/network/admin

Type CD in small.. coz my mobile editing is not so good.. caps are coming automatically
Wasim Akram ShaikCommented:
You should find the file in those paths mentioned above
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

slightwv (䄆 Netminder)Connect With a Mentor Commented:
I should also point out that the sqlnet.ora file is a client side file.  Even if the database server is AIX and you are trying to troubleshoot a newwork issue from some remote client to the AIX server, you need to change the sqlnet.ora file on the client machine not the database server.
tonydbaAuthor Commented:
any way we can find using ps - eaf | grep

and using kill

wht we will type ps - eaf | grep ??
slightwv (䄆 Netminder) Commented:
>>any way we can find using ps - eaf | grep

Did you post this in the correct question?  If so, I'm confused.  What are you trying to find with the ps command?
DavidSenior Oracle Database AdministratorCommented:
Tony, please review my comment above.  the SQLNET... is a parameter within the file sqlnet.ora.  The file sqlnet.ora is found in the Oracle HOME directory under the subdirectory network/admin.  

There is no reason to parse for an OS process.
tonydbaAuthor Commented:
Let me ask you this just add a line  'SQLNET.EXPIRE_TIME=20' in the file
/network/admin/sqlnet.ora is enough.

Please advice..........
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
Yes, the order is not significant.  If you prefer, however, to use the network manager GUI, you may follow Bursleson's advice at:  http://www.dba-oracle.com/t_connect_time_idle_expire_timeout.htm

"To set up these advanced features, simply edit your sqlnet.ora file.  If you are a beginner, follow this procedure:

    Start the Oracle Network Manager GUI.
    In the GUI navigator pane, expand the icons Local > Profile.
    From the list on the right hand pane, select General.
    Click on the Advanced tab.
    Next, enter the values for the fields or options you want to set.
    When you are finished, choose File > Save Network Configuration to write your changes to the sqlnet.ora file."
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.