Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 436
  • Last Modified:

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

/proc/sys/posix_aio
oracle@puccdstaxst01:/proc/sys/posix_aio[OTPSP1]:
===> ls
active|             maxreqs/            maxservers/         minservers/         server_inactivity/
oracle@puccdstaxst01:/proc/sys/posix_aio[OTPSP1]:
0
tonydba
Asked:
tonydba
  • 3
  • 2
  • 2
  • +2
3 Solutions
 
DavidSenior 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.
0
 
Wasim Akram ShaikCommented:
Login with oracle user and do the following

CD $TNS_ADMIN

IN CASE OF ERROR TRY

CD $ORACLE_HOME/network/admin

Type CD in small.. coz my mobile editing is not so good.. caps are coming automatically
0
 
Wasim Akram ShaikCommented:
You should find the file in those paths mentioned above
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
slightwv (䄆 Netminder) 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.
0
 
tonydbaAuthor Commented:
any way we can find using ps - eaf | grep

and using kill

but
wht we will type ps - eaf | grep ??
0
 
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?
0
 
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.
0
 
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..........
0
 
DavidSenior 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."
0
 
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.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now