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?

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠