Reputation
1,970
Next tag badge:
132/400 score
37/80 answers
Badges
1 8 18
Newest
 Nice Answer
Impact
~704k people reached

Apr
22
awarded  Nice Answer
Mar
2
comment How to troubleshoot ORA-00333 with NOARCHIVELOG mode
It will need more detail there too though; have you looked at the trace file that error refers to? Has the database or server crashed recently? etc. It would also be preferable to have the error message in English.
Feb
26
comment What is non-CDB @ Oracle ?
Yes, they have different processes. Each is a separate instance so has its own full set of pmon, smon etc., identified by the SID as usual (pmonSID etc.) There is no sharing between them. (Other than a listener, optionally).
Feb
26
comment What is non-CDB @ Oracle ?
@jblad - you could, they were just independent. They were all created standalone, they started and stopped independently, and were unaware of each other. I have a development environment running four 11g databases, i.e. 'stacked'; which isn't ideal, and not something I'd do in production.
Feb
26
answered What is non-CDB @ Oracle ?
Feb
8
awarded  Yearling
Jan
13
awarded  Critic
Jan
13
comment Result on execution of any SQL is number 2
Also see Running SQL*Plus Commands, and more specifically Ending a SQL Command
Dec
21
comment create incremental number in oracle sql query
Why all the casting between strings and numbers? Not entirely sure what this adds to the existing answers as it isn't something the OP seemed to be looking for.
Nov
20
comment Creating pluggable database using dbca
Isn't this what you asked earlier, and got an answer to?
Nov
13
comment Why a oracle database needs a minimum of two on-line Redo Log Groups for normal database operation?
Sees the docs. So one is always available for writing while the other is being archived (or checkpointed in NOARCHIVELOG mode).
Nov
5
comment Can't create a Database on Oracle 11g
You gave full permissions to which user - your own account, or the one that Oracle is running under? Seems like an odd location for the ADR base anyway; why not somewhere under \Oracle?
Oct
21
comment Where is Oracle home user being stored
Did the things you already read include this and this?
Sep
10
comment Getting an error “ORA-00093: pga_aggregate_target must be between 10M and 4096G-1” on Oracle DB startup
Manually editing an spfile doesn't seem like a great idea; changing the values with alter commands, or creating a pfile from the spfile, editing that, and starting up from that pfile sound safer. Curious how you got the invalid value there in the first place though.
Sep
9
answered Remote connection issue from windows machine
Sep
9
comment Remote connection issue from windows machine
Are you trying to telnet to the default port (23), or the listener port (1522)? What about tnsping, if you have that on machine B? What error do you get from SQL Developer? If your database is actually up, what is its local_listener parameter set to?
Aug
5
comment Oracle Temp Table Space - Alias clean up ORA-01119
Your edit is making things even less clear - what did you really run? What temporary file name was allocated by the CREATE TEMPORARY TABLESPACE TEMPRM_TEMP statement?
Aug
5
comment Oracle Temp Table Space - Alias clean up ORA-01119
You can see you're using two file names, right? Some other temporary TS is using, or has used, TEMPRM_TEMPFILE_1.dbf. Maybe you tried to create it before with a different TS name? What does dba_temp_files show? Or you created and dropped it with that name previously, but without including datafiles?
May
27
comment Why is there a difference in CSV Export Results of Oracle SQL Developer and SQL Plus Spool
Because they are different commands? You can spool from SQL Developer, which would be much more similar. What exactly is different between the outputs? Just saying it is very different isn't very helpful. You haven't shown the query you're running, either, which might be relevant.
Mar
19
awarded  Nice Answer