How can we help you today? How can we help you today?
DOKMANC2
Activity overview Badges (0) Posts (2) Comments (14)

Comments

Sort by recent activity
I attached the verbose log / comments
  1. Community
  2. Schema Compare for Oracle
  3. ORA-01008 not all variables bound error when trying to connect to Oracle 19c
I attached the verbose log
0 votes
What do you think? / comments
  1. Community
  2. Schema Compare for Oracle
  3. ORA-01008 not all variables bound error when trying to connect to Oracle 19c
What do you think?
0 votes
if I have any further questions, I'll be sure to contact "Red Gate Support" / comments
  1. Community
  2. Schema Compare for Oracle
  3. ORA-01008 not all variables bound error when trying to connect to Oracle 19c
if I have any further questions, I'll be sure to contact "Red Gate Support"
0 votes
Since I can compare two 19c database as long as I only select one schema at a time but it fails when I select multiple schema, do you accept that this is a product bug instead of a permissions issue? / comments
  1. Community
  2. Schema Compare for Oracle
  3. ORA-01008 not all variables bound error when trying to connect to Oracle 19c
Since I can compare two 19c database as long as I only select one schema at a time but it fails when I select multiple schema, do you accept that this is a product bug instead of a permissions issue?
0 votes
The discovery that run into an issue when I select a 19c db AND more than one schema at a time to compare should help identify the issue, which sounds now more like an app issue than a permissions issue. What do you think? / comments
  1. Community
  2. Schema Compare for Oracle
  3. ORA-01008 not all variables bound error when trying to connect to Oracle 19c
The discovery that run into an issue when I select a 19c db AND more than one schema at a time to compare should help identify the issue, which sounds now more like an app issue than a permissions ...
0 votes
What do you think? / comments
  1. Community
  2. Schema Compare for Oracle
  3. ORA-01008 not all variables bound error when trying to connect to Oracle 19c
What do you think?
0 votes
Question: In theory, Is this product compatible with Oracle 19c (patch 19.10)?  The thing that confused me is that I got the the error message ' table or view does not exist" above in an upgraded env where the compare failed but I also could not query these table in a db where the Schema Compare program worked correctly.  I confirmed that my user id belonged to the SELECT_CATALOG_ROLE in all envs.  When I compared 3 schemas simultaneously, the comparison failed. However, I was able to successfully compare them individually. i can send the entire verbose log to you if you like, or I can post it here, but it's long. Would you like me to mail it to you? / comments
  1. Community
  2. Schema Compare for Oracle
  3. ORA-01008 not all variables bound error when trying to connect to Oracle 19c
Question: In theory, Is this product compatible with Oracle 19c (patch 19.10)? The thing that confused me is that I got the the error message ' table or view does not exist" above in an upgraded en...
0 votes
My Red Gate Oracle Schema compare version is 14.07.13517.  Re: Does it contain info that may identify the cause of the error? The file that I think that you are referring to has an extension "saencryptedreport." when I opened it up, I was not surprised to see that it was encrypted. Is this the log file that you wanted me to check? Many times when the error has occurred in  the UI, I select the option to send it to Red Gate.  I have sent it about 8 times, approx, most recently today. I referenced this post in the Description. My email address was included in all. / comments
  1. Community
  2. Schema Compare for Oracle
  3. ORA-01008 not all variables bound error when trying to connect to Oracle 19c
My Red Gate Oracle Schema compare version is 14.07.13517. Re: Does it contain info that may identify the cause of the error?The file that I think that you are referring to has an extension "saencry...
0 votes
Eddie, Yes, I did misread your reply. Sorry about that. I do see these errors in the verbose log. I know that we've seen other permissions issues related to the upgrade but to my knowledge, they were "all" fixed. I will forward these to the DBA in hopes that he does not tell me that I should not have access to these views. This is the expected default reply. Let's see what he says... SELECT s.sowner as owner, s.vname as mview_name, decode(bitand(s.flag, 262144), 262144, 'Y', 'N') as reduced_precisions    FROM sys.snap$ s WHERE ((s.sowner = 'FDS_MAINT' OR s.sowner = 'FDS_APPS' OR s.sowner = 'FDS_BASE') );   --1 ORA-00942: table or view does not exist SQL2.sql 2 34  SELECT  u.username as OWNER, o.NAME as TABLE_NAME, p.periodname as PERIOD_NAME, p.flags as FLAGS, p.periodstart as PERIOD_START, p.periodend as PERIOD_END FROM sys.sys_fba_period p,sys.tab$ t,sys.obj$ o, all_users u, m_owners WHERE p.obj# = t.obj# AND t.obj# = o.obj# AND o.owner# = u.user_id AND u.username = m_owners.owner; --ORA-00942: table or view does not exist SELECT     u.username as OWNER,     o.NAME as TABLE_NAME,     c.NAME as COLUMN_NAME,     c.property,     decode(bitand(c.property, 137438953472 + 274877906944), 137438953472, 'YES', 274877906944, 'YES', 'NO') AS IDENTITY_COLUMN,     decode(bitand(c.property, 68719476736), 68719476736, 'YES','NO') AS IDENTITY_ONNULL,     decode(bitand(c.property, 137438953472), 137438953472, 'YES','NO') AS IDENTITY_ALWAYS,     decode(bitand(c.property, 274877906944), 274877906944, 'YES', 'NO') AS IDENTITY_DEFAULT,     'NO' AS IDENTITY_FAIL FROM     sys.col$ c,     sys.tab$ t,     sys.obj$ o,     all_users u,     m_owners WHERE c.obj# = t.obj#     AND t.obj# = o.obj#     AND o.owner# = u.user_id     AND u.username = m_owners.owner     AND decode(bitand(c.property, 137438953472 + 274877906944), 137438953472, 'YES', 274877906944, 'YES', 'NO') = 'YES'; -- ORA-00942: table or view does not exist SQL2.sql 38 3  / comments
  1. Community
  2. Schema Compare for Oracle
  3. ORA-01008 not all variables bound error when trying to connect to Oracle 19c
Eddie,Yes, I did misread your reply. Sorry about that. I do see these errors in the verbose log. I know that we've seen other permissions issues related to the upgrade but to my knowledge, they wer...
0 votes
I was expecting that if I set db comparability to an old version that it would work. It did not / comments
  1. Community
  2. SQL Source Control
  3. Error: A duplicate object name has been found
I was expecting that if I set db comparability to an old version that it would work. It did not
0 votes
Total activity
18
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2