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 Antwort
2
Akzeptierte Antwort

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
EXPERTE
beantwortet vor 7 Monaten
profile pictureAWS
EXPERTE
überprüft vor 7 Monaten
  • 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?

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen