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 réponse
2
Réponse acceptée

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
EXPERT
répondu il y a 7 mois
profile pictureAWS
EXPERT
vérifié il y a 7 mois
  • 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?

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions