Reputation
1,745
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 7 16
Newest
 Nice Answer
Impact
~476k people reached

Jul
30
comment ORA-03113: end-of-file on communication channel Can not connect
Is your D: drive mounted? Does the directory path to the online log files exist? Do the online log files exist?
Jul
22
comment Unable to connect oracle as sysdba tables have been dropped
It looks like your instance is being terminated when you open it; you perform flashback database when it's only mounted (see the previous doc link). That might save you, or still might not work. Sounds like you have exports of specific schemas, which is not the same as a backup. If that is all you have, and flashback doesn't work, then I think your only option may be to recreate the database and all the schemas.
Jul
22
comment Unable to connect oracle as sysdba tables have been dropped
You might be able to flashback database to before the drop script ran, but I suspect there might be be too much damage. You have a backup though, right?
Jul
8
comment sql query - table@string meaning
Not sure why this is being marked as off-topic. Managing database links can be a DBA taks, but knowing what they are and how to use them is a programming topic. (This isn't PL/SQL-specific though, DB links are used in plain Oracle SQL too).
Jul
8
answered sql query - table@string meaning
Jun
25
comment sqlplus consuming 99% CPU
OK, I'm way off base then. Kind of missed that it was client only, and it's happening too early to be at the server end. Sorry, and good luck...
Jun
25
comment sqlplus consuming 99% CPU
So it's spinning rather than hanging, from the 99.2% CPU. How many processes are running under the oracle ID, on both boxes? Can you see the ulimit for nproc?
Jun
25
comment sqlplus consuming 99% CPU
Do you have a lot of idle/stuck processes - you could get this effect if you're hitting the nproc limit; or more likely if oracle is hitting it, since you can run other commands as user. Can you log in as oracle and run (any) processes, and is anything reported in the Oracle logs? (If that doesn't highlight anything, is sqlplus aliased, or a function; what does whence -v sqlplus show? What does ps show while it's hanging?)
Jun
16
comment What happens when we create index
The Oracle documentation explains how indexes work and are stored.
Jun
7
comment Oracle remove and place (re-install) database on 10g
... as long as you're really sure you have a good and complete dump of everything you'll need. You'd also need to recreate the user with all its non-table privileges before running the import. You should look at datapump expdp/impdp rather than the older exp/imp though, since you're on 10g.
Apr
30
comment Why Oracle Database trigger can became DISABLED
@evgenyl - well, I said it was very unlikely, but easy to rule out 8-). Happening on several instances still sounds like a security sweep is possible to me; might be done remotely so not necessarily something installed on the DB. But probably only the client can figure that out, at least until you get the trigger audit records back. I would think the DBAs would at least be aware of that happening though, so maybe not.
Apr
30
comment Why Oracle Database trigger can became DISABLED
Is it shown as disabled in dba_triggers, or just doesn't fire? It sounds extremely unlikely but there is a hidden init parameter, _system_trig_enabled, which could stop it firing, but it would have other effects that you or the DBAs ought to be aware of. Much more likely that someone is doing it deliberately, as APC says. One possibility is that the client has a security audit tool that doesn't like it and is disabling it automatically, but then that ought to be logged somewhere; just a wild guess...
Apr
17
comment Exporting and importing a database
Host credentials are for an operating system account (e.g. oracle). SYS is a database account and has to be connected AS SYSDBA (not as 'normal' in the drop-down role when you log in to EM). The message doesn't seem to tally with what you say you're doing?
Apr
15
comment How to check if Oracle DB process is running in Unix and where Oracle DB is installed
The ps commands would only tell you if a database was running, it wouldn't tell you if the software was installed if a DB wasn't up. You can investigate the locate or find commands to search for common files, e.g. sqlplus, but you're probably better off just asking the DBA for the settings to use.
Apr
9
comment Oracle schema import is not importing all the tables present in the schema dump file
Showing the export and import logs might be helpful, or at least edited versions excluding the tables that did transfer; that will at least confirm the tables were exported and if so might indicate why they didn't import. You might also want to consider using data pump rather than the old exp/imp utilities.
Mar
27
comment SYSDBA password in Oracle DB
@user2065083 - they're stored within the DB, the exact location depends on version; but they're stored hashed (of course) so you're not going to be able to get the actual passwords in plaintext (without a lot of time and effort anyway).
Mar
27
comment Oracle insert through dblink performance issue
As far as I can tell from some testing, driving_site is ignored by the insert anyway. MOS note 825677.1 suggests this too: 'a distributed DML statement must execute on the database where the DML target resides. The DRIVING_SITE hint cannot override this', as does not-a-bug 5517609. So, worth investigating, but doesn't work *8-)
Mar
27
comment Oracle insert through dblink performance issue
@andreybavt - it depends which table you give as an argument. If you did insert /*+ driving_site(MARS_SUPERVISORS_PUB) */ ... then yes, it would push it all to the remote side. If you gave it the local table (or one of the aliases in this case) then it might keep it local. That's if it does anything in this case, and if the aliases form the subquery are meaningful to the insert...
Mar
27
answered ORA-01435: user does not exist
Mar
27
comment Oracle insert through dblink performance issue
You could see if the driving_site hint affects the plan; I'm not sure on insert...