How edit RDS oracle server file

0

Hi

I have an older windows client utility that requires an update on this oracle server file "oracle/network/admin/sqlnet.ora" and add the following pramaeter

SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8

Is there a way to do this on an RDS instance using parameters somehow since I dont have access to operating system or have SYS access?

thanks,

1 回答
2
已接受的回答

Hello.

As far as I can see from the document below, the parameter group "sqlnetora.sqlnet.allowed_logon_version_client" appears to be the parameter you want to change.
We have confirmed that it is registered as a parameter that can be changed in the Oracle parameter group.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ModifyInstance.Oracle.sqlnet.html
r

profile picture
专家
已回答 7 个月前
profile pictureAWS
专家
已审核 7 个月前
  • Great Answer! The RDS is using the default oracle 19c parameter group and it does not seem you can change any parameter for that. Do I need to create a new parameter group and then add all the default ones in defined in original one and then edit the value for this parameter and assign the RDS to it?

    Thanks,

  • Yes, the default parameter group cannot be changed, so you need to create a custom parameter group and change the settings.

  • Does the custom parameter group inherit or include all the parameters included in default parameter group or I have to create all the entries myself?

  • There is no difference in the parameters set in both custom and default parameter groups.

  • Hi Do you mean that the custom parameter group will be initially identical to default parameter group before any edits?

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则