Wednesday , April 24 2024

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

RMAN : ORA-01008: not all variables bound

dbtut August 15, 2018 ORACLE

Error:

When trying to connect with rman “ORA-01008: not all variables bound” error is occured.

Reason:

Bug 10306699

Solution:

You need to set the cursor_sharing parameter to EXACT.

SQL> alter system set cursor_sharing=EXACT scope=both;

1	SQL> alter system set cursor_sharing=EXACT scope=both;

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.