Reputation
894
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 9
Newest
 Caucus
Impact
~45k people reached

  • 0 posts edited
  • 1 helpful flag
  • 35 votes cast
Aug
25
comment Opening an Oracle database with a corrupted redo log
There are ways how to bypass media recovery phase, and open an inconsistent database. But this is beyond SO questions. You should contact Oracle support.
Aug
3
comment Oracle data dictionary, tell built-in roles apart from custom roles
there is a note on Metalink describing list of all Oracle's build-in usernames and roles.
Jul
27
awarded  Caucus
Jul
23
comment Is it possible to install oracle 12c without X window system
All you need are X window system client libs. If you have xauth and xclock installed on your Linux server you should be able run the GUI installation. Simply connect via SSH from windows and install X Windows system(server) from Cygwin.
Jul
21
comment What is the best way to take backup for Remote DB Server
How does you question relate to backup? There is no way how to effectively backup the database without databases native tools.
Jun
30
comment How do I determine the appropriate size for my tablespace when importing a .dmp file?
maybe offtopic, but usually it is helpfull to execute the rman command "report schema" on source db, to get report about datafile sizes. Also you can use imp option show=yes to get ddls for tablepsaces (is its full database export).
Jun
30
answered Is possible do an online snapshot backup , without archive logs at Oracle Database?
Jun
30
comment Getting milliseconds elapsed during a stored PL/SQL procedure
Maybe OT: do you really need such a precision on PL/SQL level? Usually most of the time is spent in SQL execution and Oracle offers tools to collect performance data for each SQL - for example per sql_id.
Jun
12
comment Causing ORA errors in a program using JDBC. How can I find what's causing them?
@a1ex07 it won't apper in the v$sql view, but it should be read from ora_sql_txt function. It is the attribute passed to even trigger.
Jun
12
answered Causing ORA errors in a program using JDBC. How can I find what's causing them?
Jun
9
answered Purge ARCHIVELOG automatically
Jun
5
comment How can we get the table and the column name of known data value?
@miracle173 AFAIK I saw somewhere a PL/SQL script doing that, I'm not 100% sure who was the author. But such a requirement is quite common: stackoverflow.com/questions/208493/…
Jun
5
answered How can we get the table and the column name of known data value?
May
26
comment What is the appropriate GCC version I should use for building my External Procedure?
Gcc version is specified as prerequisite for database installation. In case of stored procedures threre are probably no requirements. But at least glibc version should be the same and Oracle libraries version must be the same. Theoretically you shloud recompile the stored procedure anytime you patch the database.
May
26
comment What is the appropriate GCC version I should use for building my External Procedure?
I do not think so. Oracle while being installed uses gcc/ld/make from OS. Do you have root access to the database server? The usual trick is to write own PID to a file, and then use kill(2) to send SIGSTOP to yourself. Then you can debug that process. But extproc(when configured properly) runs with privs of user nobody. When not configured it runs with oracle:dba privs.
May
26
comment What is the appropriate GCC version I should use for building my External Procedure?
Usally when you build something on Linux with particular version, your binary will also depend on glibc of particular version. This can be problem when you build something on Ubuntu(or some desktop distribution) and then you try to run that binary on RHEL/SLES.
May
26
comment What is the appropriate GCC version I should use for building my External Procedure?
What are those weird issues? I had no problems with gcc on AIX eventhough only Xlc was certified. Which libraries are you using to link the stored procedure? Are you using pure C OCI (libclntsh.so)? Or do you also use C++ OCCI, in this case I can imagine some problems with ABI changes. If you look at Oracle installtion prerequisities you will find which gcc version is preffered. Earlier this was really crutial, especially version of binutils (ld) was important.
May
26
comment Deferrable Foreign Key Constraints
Developers are creating tools. I saw many faulty SW where developers forgot to wrap commit into begin ... exception when ... end; block or into try-catch. Simply because nobody expected that commit can throw an exception. When you do ETL then you usualy do some DDL (disable constraints, disable indexes, drop unique indexes, ...) and then you load data. Whenever I saw deffered constraints in some schema it was implemented because company was using some crazy in-house ORM tool, which was unable serialize SQL properly.
May
24
answered Deferrable Foreign Key Constraints
May
22
comment Oracle - Slow queries without prepending schema name or providing hint
what about alter session set current_schema=schema;? Are you using performance baselines on your database?