Questions tagged with RDS Custom for SQL Oracle

Content language: English

Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

  • 1
  • 12 / page
So, have some DMP files that was exported from a oracle on premise, using expdp. And now from the linux EC2 instance i need import those dumps that is already there if is possible using the impdp but since there is no access to directory in the RDS instance how to do that? On linux i hace oracle installed and i can connect by sqlplus in the target db.
3
answers
0
votes
28
views
asked 10 days ago
Suppose a MySQL RDS instance was created with engine version 5.7.33 and a backup of it was taken today, with plans to retain the backup for seven years. After seven years, if AWS no longer supports version 5.7.33 and the user wants to restore the snapshot, can they do so? Additionally, will the data be recoverable even if the database engine version is no longer supported? Furthermore, if restoring from the snapshot is not possible, what are some alternative methods for storing backups of an RDS instance for long-term retention?
1
answers
0
votes
39
views
asked a month ago
The heading pretty much describes it all, here are some more information on the Amazon RDS I am using. * Engine: MySQL Community 8.0.28 * Class db.r6g.large * Multi-AZ no. The data volume is very small, not even a few megs, as I am just doing some PoC to test the connectivity. On the client side, I am using the following stack * Ubuntu 22.04 * Python 3.10 * SQL Alchemy 1.4.44 ```python3 #!/usr/bin/env python3 # encoding:utf-8 uri:str = 'mysql+mysqlconnector://della:random_password@tensorflow-dump.apj-xjge.ap-southeast-1.rds.amazonaws.com:3306/convnet' with create_engine(url=uri).connect() as out_client: logging.info(msg=f'Connected to {uri}.') results.to_sql(name='machine_name', con=out_client, if_exists='append', index=False) logging.info(msg=f'Pushed data.') ``` So, I am encountering the operational error on a sporadic basis, once every 3-4 attempts of running the above code. It is not reproducible, but certainly this makes the database unsuitable for production usage. Here is the stacktrace. ``` Traceback (most recent call last): File "/home/della/supply-chain-dev/clustering_results_postprocess/src/push.py", line 119, in <module> asyncio.run(main=main()) File "/usr/lib/python3.10/asyncio/runners.py", line 44, in run return loop.run_until_complete(main) File "/usr/lib/python3.10/asyncio/base_events.py", line 646, in run_until_complete return future.result() File "/home/della/supply-chain-dev/clustering_results_postprocess/src/push.py", line 111, in main with create_engine(url=out_dbase_uri).connect() as out_client: File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3315, in connect return self._connection_cls(self, close_with_result=close_with_result) File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 96, in __init__ else engine.raw_connection() File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3394, in raw_connection return self._wrap_pool_connect(self.pool.connect, _connection) File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3364, in _wrap_pool_connect Connection._handle_dbapi_exception_noconnection( File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2198, in _handle_dbapi_exception_noconnection util.raise_( File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 210, in raise_ raise exception File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3361, in _wrap_pool_connect return fn() File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 325, in connect return _ConnectionFairy._checkout(self) File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 888, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 491, in checkout rec = pool._do_get() File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 145, in _do_get with util.safe_reraise(): File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 210, in raise_ raise exception File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get return self._create_connection() File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 271, in _create_connection return _ConnectionRecord(self) File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 386, in __init__ self.__connect() File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 684, in __connect with util.safe_reraise(): File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 210, in raise_ raise exception File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 680, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 578, in connect return dialect.connect(*cargs, **cparams) File "/home/della/.local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 598, in connect return self.dbapi.connect(*cargs, **cparams) File "/home/della/.local/lib/python3.10/site-packages/mysql/connector/pooling.py", line 293, in connect return CMySQLConnection(*args, **kwargs) File "/home/della/.local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 118, in __init__ self.connect(**kwargs) File "/home/della/.local/lib/python3.10/site-packages/mysql/connector/abstracts.py", line 1178, in connect self._open_connection() File "/home/della/.local/lib/python3.10/site-packages/mysql/connector/connection_cext.py", line 293, in _open_connection raise get_mysql_exception( sqlalchemy.exc.OperationalError: (mysql.connector.errors.OperationalError) 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 104 (Background on this error at: https://sqlalche.me/e/14/e3q8) ``` I have already opened the necessary port in the security group to allow access from my client machine. So is this a resource issue or code/credential issue? Do I need to fire up a bigger database somehow, or resort to multi-zone deployment etc.? Additional info: Said it in the comment already, but to make it clear, my client is a Dell Inspiron Laptop running Linux Mint, the security group (of the RDS instance) is configured to accept connection, and from the same laptop, I can connect to the ```mysql>``` prompt without any problem. It is the sqlalchemy client that is refusing to connect _sometimes_.
0
answers
0
votes
24
views
della
asked a month ago
¡Hi!, I created a RDS ORACLE MULTITENANT ver. 19, but i have a question... AWS multitenant provide by default a PDB (ORCL) if you dont specify any when i try to create another one PDB I Couldn't, cause i only have access to the PDB by default created, how i can create another PDB'S or use the CDB commands. or perhaps another way to create a multi-tenant ambient whit oracle.
1
answers
0
votes
27
views
profile picture
asked a month ago
I would like to reduce costs by allowing RDS Custom to use an existing trail rather than create a new one. Is this possible?
1
answers
0
votes
13
views
AWS
light
asked a month ago
  • 1
  • 12 / page