Reputation
641
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 6 18
Impact
~47k people reached

  • 0 posts edited
  • 1 helpful flag
  • 38 votes cast
2d
awarded  Famous Question
Nov
18
awarded  Nice Question
Aug
31
awarded  Popular Question
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