Reputation
626
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
6 16
Newest
 Taxonomist
Impact
~39k people reached

  • 0 posts edited
  • 1 helpful flag
  • 38 votes cast
Aug
19
comment Add an additional listener to Oracle Database Appliance
The link you've provided for the walk-through isn't valid any longer (the domain doesn't appear to be online). Is there an updated link that you can provide? I'd like to configure our ODA to have a second SCAN name on a separate subnet and enable client connections from both sources, but I'm being told this isn't possible by somebody who has worked with the ODA before (but it may be the case of not being possible through the wizard, but possible through manual config). Thanks!
Jun
25
awarded  Taxonomist
Jun
15
accepted Does SA account need to be called “SA” or can I rename it safely?
Jun
15
comment Does SA account need to be called “SA” or can I rename it safely?
@AaronBertrand Agreed that's what's best, but the code isn't under my control and the team responsible is dragging their feet on fixing it (from their perspective, nothing is wrong and it works now). I'm trying to ensure that things don't break when we move to a new server, but that I gain the control of security and stability that I've been wanting for a while.
Jun
12
comment Does SA account need to be called “SA” or can I rename it safely?
@AaronBertrand Normally it wouldn't gain anything, but in this case there are applications that run using the SA account but which don't need SA rights (previous bad habits from developers) and I'd like to give them an "SA" account with the password they expect but limied rights, and move the actual sysadmin account to a new name where I can disable it. I just can't disable the account called SA because then their deployed applications break (getting this to fix this is another fight, but looking for what's under my control).
Jun
12
awarded  Yearling
Jun
11
revised Does SA account need to be called “SA” or can I rename it safely?
changed title to clarify a bit
Jun
11
asked Does SA account need to be called “SA” or can I rename it safely?
Feb
11
awarded  Nice Question
Jan
29
awarded  Citizen Patrol
Jan
21
awarded  Popular Question
Dec
10
awarded  Notable Question
Oct
2
comment “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
@BrandonWilliams I updated the question to add my T-SQL code, generated by the publication wizard. All the pre-steps execute without issue, and it's the final step that actually adds the article to the Oracle publication that gives me the error.
Oct
2
revised “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
added code that causes the issue
Sep
30
comment “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
@RLF: There's isn't any code, as I'm using the SSMS "Add Oracle Publisher" wizard rather than using T-SQL directly. That said, the error seems to occur when the wizard executes sp_addarticle, which is turn executes sp_ORAaddarticle, from which the code is hidden (because it's a system stored proc). This, in turn, executes a package deployed to the oracle database called "MYUSERNAME.HREPL" where the error is actually occurring. I know that's not much help, but we're sifting through that package now to see if can find the statement.
Sep
30
asked “ORA-00936: missing expression” setting up Oracle Publisher in SQL Server
Jul
28
awarded  Popular Question
Jul
2
awarded  Curious
Jul
1
awarded  Popular Question
May
23
comment Modify an Oracle Dataguard destination database
It's not one trigger - it's one on every table. We're using it as a step to replicate the data to an MSSQL Server, which requires their DDL trigger on every table. Even if it was supported, I don't want to potentially slow down the operations by introducing this kind of load on the production server if I can do it on a native Oracle replica of some kind.