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 Respuesta
2
Respuesta aceptada

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
EXPERTO
respondido hace 7 meses
profile pictureAWS
EXPERTO
revisado hace 7 meses
  • 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?

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas