asked on

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]:

ASKER CERTIFIED SOLUTION

David VanZandt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Wasim Akram Shaik

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

Wasim Akram Shaik

You should find the file in those paths mentioned above

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tonydba

ASKER

any way we can find using ps - eaf | grep

and using kill

but
wht we will type ps - eaf | grep ??

slightwv (䄆 Netminder)

>>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?

David VanZandt

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.

tonydba

ASKER

Let me ask you this just add a line 'SQLNET.EXPIRE_TIME=20' in the file
/network/admin/sqlnet.ora is enough.

Please advice..........

SOLUTION

David VanZandt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Steve Wales

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.