Please find the below query:

select count(*) from v$session;

This has to be run on the database every 5 minutes. What is the right way to achieve this? The query has to be run every 5 minutes on the same sql*plus screen. Instead of pressing "/" every minute, I wanted to understand if there is a way. Database/Server details:

SQL> select * from v$version;
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production

SQL> !uname -a
HP-UX ap12121 B.11.11 U 9000/800 ap12121 unlimited-user license

I'm new in "databaase administration" the problem I am facing is that I want to have an exact copy of a table, from MySQL database (website database) to oracle database (a local one). **What I've done till now** Searched for two days. I installed MySQL connector/odbc on the 'oracle machine' and successfully connected to the remote MySQL database Also I can execute queries from the oracle machine like: select * from remote_table; and it shows the expected results, **The problem here is:** Is there a way to sync these two databases (mySQL to oracle), or at least update the local one every midnight.. **About the two machines** Both machines are running Windows OS **local one :** Running Windows XP Oracle 8i **remote one :** Running Windows 8.1 MySql 5.6.17

I'm an intern stuck dealing with a database system that is as old as I am. **The Issue:** I have a perl script pulling data from a server running Oracle 8 (8.1.7) and placing the data into a .csv. The server that runs the script is being decommissioned and I am now need to port that script into a new server running a client for oracle 11 (11.2.0.4.0). The problem is that when I run that script in the new server I get an error: > failed: ORA-03134: Connections to this server version are no longer > supported. (DBD ERROR: OCISessionBegin) *All servers are linux servers* **The questions:** - Documentation reagarding Oracle 8 is scarce but I'm assuming the error is happening because Oracle client 11 dosen't support oracle 8. Assuming I can find a copy of client 8 is it possible to load 2 clients on one machine? - I could easily re-write the script in Java. The issue is figuring out how to find a driver that is compatible with Oracle 8, what is the latest version of OJDBC that supports oracle 8? I'm open to other suggestions as to how to read data from Oracle 8. Using a server running Oracle 10 as an in-between is not an option

Does Visual Studio 2017 Community (.NET Framework 4.6.2) support Oracle 8i? I am trying to connect with .NET Framework 4.6.2 to a production Oracle 8i database. I googled it, but I can not find anything which is related to this topic. I checked also this site but that is for Windows 2008 R2. I tried Oracle 19 and Oracle 18 and it works. But I can't find what the oldest version is that is still compatible with .NET Framework (like Oracle 8 or Oracle 9) . I tried to connect using ODP.NET Managed Driver but it was unsuccessful. I am an Oracle Developer and Web Developer for the organisation. I have been given the task to test it if it's possible to connect on our (TEST) database which is Oracle 8i (I believe). Our main database is Oracle 10, but this data is restricted and I cannot manipulate it. This part is for our DBA.

I want to fetch a Package DDL in Oracle 8i. 8i doesn't support DBMS_METADATA.get_ddl. Can it be done using export?

Oracle version = Oracle 8i (817_312) //Yes I know this is old. Database id = LED OS = Solaris 8 Oracle USERID = oraled Oracle DBA group = dba rman backups to disk. Sorry this is so long. I am not a DBA, I am UNIX/Linux system administrator. We lost our DBA a while ago, and I was told to keep it running. What am I missing or doing wrong? I am trying to restore an oracle database from a good backup and I am getting errors that there is a problem with the controlfiles. The oracle DB is up, mounted and open when this script runs. This is how we are backing up the oracle DB from Oracle's cron. rman target / nocatalog cmdfile=/oracle/admin/led/rman/LEDlvl0 log=$LOGFILE and in /oracle/admin/led/rman/LEDlvl0.sh we have run { set command id to 'LED_rman_test'; allocate channel disk1 type disk format '/apps1/backup/%d.LVL0.%s.%t.%p.dbf'; allocate channel disk2 type disk format '/apps2/backup/%d.LVL0.%s.%t.%p.dbf'; allocate channel disk3 type disk format '/apps3/backup/%d.LVL0.%s.%t.%p.dbf'; allocate channel disk5 type disk format '/apps5/backup/%d.LVL0.%s.%t.%p.dbf'; allocate channel disk6 type disk format '/apps6/backup/%d.LVL0.%s.%t.%p.dbf'; backup incremental level=0 setsize=7000000 database ; backup (current controlfile format '/apps4/backup/%d.%s.%t.%p.ctl'); release channel disk1; release channel disk2; release channel disk3; release channel disk5; release channel disk6; This ran succesfully. I want to restore this backup. I have removed the data files and copied the control file (/apps4/backup/LED.22010.973362972.1.ctl) file back to the the locations specified by the initLED.ora file. As the Oracle user these are the commands I am running. $ rman nocatalog RMAN> connect target sys/********@LED RMAN> startup mount and I get this error RMAN-06196: Oracle instance started RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-06003: ORACLE error from target database: ORA-00205: error in identifying controlfile, check alert log for more info RMAN-06097: text of failing SQL statement: alter database mount RMAN-06099: error occurred in source file: krmk.pc, line: 4192 and the alertLED.log shows: Tue Apr 24 16:57:04 2018 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 LICENSE_MAX_USERS = 0 Starting up ORACLE RDBMS Version: 8.1.7.0.0. System parameters with non-default values: processes = 150 sessions = 170 timed_statistics = TRUE event = 10183 trace name context forever, level 1, 10191 trace name context forever, level 1 shared_pool_size = 400000000 enqueue_resources = 8000 control_files = /oracle/LED/sapdata1/cntrl/cntrlLED.dbf, /oracle/LED/sapdata2/cntrl/cntrlLED.dbf, /oracle/LED/sapdata3/cntrl/cntrlLED.dbf db_block_buffers = 142000 db_block_size = 8192 db_block_lru_latches = 4 compatible = 8.1.0 log_archive_start = TRUE log_archive_dest = /oracle/LED/saparch/R3Parch log_archive_min_succeed_dest= 1 log_buffer = 1048576 log_checkpoint_interval = 300000 log_checkpoint_timeout = 0 db_files = 254 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE control_file_record_keep_time= 45 dml_locks = 2500 row_locking = always replication_dependency_tracking= FALSE transactions_per_rollback_segment= 20 max_rollback_segments = 400 rollback_segments = PRS_0, PRS_1, PRS_2, PRS_3, PRS_4, PRS_5, PRS_6, PRS_7, PRS_8, PRS_9 transaction_auditing = FALSE remote_os_authent = TRUE remote_login_passwordfile= EXCLUSIVE db_domain = world audit_trail = TRUE sort_area_size = 2097152 sort_area_retained_size = 0 db_name = LED open_cursors = 800 optimizer_mode = choose optimizer_index_cost_adj = 10 cursor_space_for_time = FALSE parallel_max_servers = 20 hash_join_enabled = FALSE background_dump_dest = /oracle/LED/saptrace/background user_dump_dest = /oracle/LED/saptrace/usertrace core_dump_dest = /oracle/LED/saptrace/background PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Tue Apr 24 16:57:07 2018 ARCH: STARTING ARCH PROCESSES ARC0 started with pid=8 Tue Apr 24 16:57:07 2018 ARCH: STARTING ARCH PROCESSES COMPLETE Tue Apr 24 16:57:07 2018 ARC0: Archival started Tue Apr 24 16:57:07 2018 alter database mount Tue Apr 24 16:57:07 2018 ORA-00202: controlfile: '/oracle/LED/sapdata1/cntrl/cntrlLED.dbf' Tue Apr 24 16:57:10 2018 ORA-205 signalled during: alter database mount... and oerr 205 give me this: $ oerr ora 205 00205, 00000, "error in identifying controlfile, check alert log for more info" // *Cause: The system could not find a controlfile of the specified name and // size. // *Action: Check that ALL controlfiles are online and that they are the same // files that the system created at cold start time. So I check the controlfiles: $ ls -l /oracle/LED/sapdata1/cntrl/cntrlLED.dbf /oracle/LED/sapdata2/cntrl/cntrlLED.dbf /oracle/LED/sapdata3/cntrl/cntrlLED.dbf -rw-r----- 1 oraled dba 29876736 Apr 23 23:19 /oracle/LED/sapdata1/cntrl/cntrlLED.dbf -rw-r----- 1 oraled dba 29876736 Apr 23 23:19 /oracle/LED/sapdata2/cntrl/cntrlLED.dbf -rw-r----- 1 oraled dba 29876736 Apr 23 23:19 /oracle/LED/sapdata3/cntrl/cntrlLED.dbf So I try and restore the controlfile. $ rman nocatalog RMAN> connect target sys/********@LED RMAN> startup nomount RMAN-06196: Oracle instance started Total System Global Area 1609240736 bytes Fixed Size 73888 bytes Variable Size 444837888 bytes Database Buffers 1163264000 bytes Redo Buffers 1064960 bytes RMAN> run { 2> allocate channel ch1 type disk; 3> allocate channel ch2 type disk; 4> allocate channel ch3 type disk; 5> allocate channel ch5 type disk; 6> allocate channel ch6 type disk; 7> 8> restore controlfile to '/apps6/backup/jimt.ctl'; 9> } RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch1 RMAN-08500: channel ch1: sid=10 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch2 RMAN-08500: channel ch2: sid=11 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch3 RMAN-08500: channel ch3: sid=12 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch5 RMAN-08500: channel ch5: sid=13 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch6 RMAN-08500: channel ch6: sid=14 devtype=DISK RMAN-03022: compiling command: restore RMAN-03022: compiling command: IRESTORE RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: ch1 RMAN-08031: released channel: ch2 RMAN-08031: released channel: ch3 RMAN-08031: released channel: ch5 RMAN-08031: released channel: ch6 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure during compilation of command RMAN-03013: command type: restore RMAN-03002: failure during compilation of command RMAN-03013: command type: IRESTORE RMAN-06003: ORACLE error from target database: ORA-01507: database not mounted ORA-06512: at "SYS.X$DBMS_RCVMAN", line 4461 ORA-06512: at line 1 RMAN-06097: text of failing SQL statement: begin dbms_rcvman . setDatabase ( upper ( :dbname:dbname_i ) , :rlscn , :rltime , :fhdbi:fhdbi_i ) ; end ; RMAN-06099: error occurred in source file: krmk.pc, line: 9196 I am stuck. Any ideas of what I should try next? Thanks JiM T

I'm an intern stuck trying to retrieve data from Oracle 8i (a database that is as as I am) **The problem:** I need to write a java script that pulls data from Oracle 8i into a newer server. The last client that is compatible with Oracle 8i is Oracle client 10g (10g instant client is still available for free on Oracle's website). Documentation is scarce about 10g client compatibility. My server currently does not have java installed and my question is what version of java is compatible with 10g client?

I have some backup files for an old Oracle 8i data that was created years ago. I need to be able to view this data and export it to a csv file. The backup directory includes .dbf, .ctl , .arc and a few other file formats. My initial thought is to obtain an installation of this DB so I can try to restore it. Is there anyway I can obtain it? (Any OS would be fine) Any suggestions on how to do this would be great.

We have an old application which we need data and reports from. The application is configured to retrieve data from Oracle DB and the login username and password are hardcoded in the application. However, we do not have the source code as it was lost, we only have the exe. We have recovered a database dump and were able to successfully point the app to the database, but we are getting wrong password errors and we cannot find out the old password to change the password to. Is there anyway Oracle can accept login requests using **any** password provided so the application can log in successfully?

I'm writing query to select students with their Program, Country and Teacher. So far, I have the following query: SELECT H.STUDENT_CODE, H.FIRSTNAME, H.LASTNAME, H.PROGRAM, H.TEACHER_CODE, H.COUNTRY_CODE, AC.COUNTRY_NAME, P.PROGRAM_NAME, T.TEACHER_NAME FROM HTUD H, PROGRAM P, TEACHER T, AP_COUNTRY AC WHERE H.FIRSTNAME LIKE '%ark%' AND H.PROGRAM = P.PROGRAM AND H.TEACHER_CODE = T.TEACHER_CODE AND H.COUNTRY_CODE = AC.COUNTRY_CODE ORDER BY H.STUDENT_CODE ASC These two columns H.TEACHER_CODE and H.COUNTRY_CODE have some empty values. If I run the query above, it returns only students that have data in these two columns H.TEACHER_CODE and H.COUNTRY_CODE. However, I want to select all students wether they have data in these two columns or not. If they have data in H.TEACHER_CODE and H.COUNTRY_CODE column, then return Teacher and Country also, if they don't have, just return students without Teacher or Country. So, how do I select all students with or without Teacher or Country?

There are 42 threads tagged as oracle8i, none of them answer my question... This is Oracle 8i (8.1.5.0.0) SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production PL/SQL Release 8.1.5.0.0 - Production CORE Version 8.1.3.0.0 - Production TNS for Solaris: Version 8.1.5.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production What I want to know is, is this interrogating the instance, or asking the DB itself? Why I'm asking: I've been asked to upgrade an 8i DB (8.1.5.0.0 -> 8.1.7.4.0) but the server (Solaris 2.6 5/98 on a U60) has both 8.1.5.0.0 & 8.1.7.0.0 on it. and 10 years or so ago, attempts were made to upgrade from 8.1.5 to 8.1.7, and then it may or may not have upgraded and downgraded, etc. The datafiles themselves were actually on the the 8.1.7 filesystem and sym-linked to 8.1.5. the init file has compatible=8.1.5 in it. So I don't know where the instance is at, version wise, or how to find out. I've run the Oracle checks for dictionary corruption that you can get going from 8.1.5 to 8.1.6 and there are no signs of that. When I tried to do an export, (usual story, "it's very important, Why?" "Does that mean we have no backups?") it barfed with an error indicative of the fact that it didn't have the tables/schemas necessary to do an export, so in 8.1.5 I ran the following as Oracle suggested: @?/rdbms/admin/catproc.sql @?/rdbms/admin/catalog.sql @?/rdbms/admin/catexp.sql @?/rdbms/admin/utlrp As system: @?/sqlplus/admin/pupbld Then I quit out, shutdown, startup and I'm apparently golden, I get a valid export with exp. So, it's been messed about with, and I'm not a DBA. I'm a UNIX admin and I dabble with Oracle, I'm comfortable with installs, and building instances and throwing them about, Dataguard, RMAN, etc. I know my Plato. That is I know that I know next to nothing about the internals of an Oracle DB, just enough to know how complex all this stuff is. We don't have a DBA. So what is v$version telling me? Is there anything, which will actually interrogate the instance & schemas to tell me what version they're at? Or is it suck it and see? **[UPDATE]** As an experiment I changed the oracle accounts environment to boot from 8.1.7 (as I duplicated the files, prior to making changes) and this is what I get. Bear in mind that this is the same init scripts & dbf files: SQL> select * from v$instance; INSTANCE_NUMBER INSTANCE_NAME --------------- ---------------- HOST_NAME ---------------------------------------------------------------- VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_ ----------------- --------- ------- --- ---------- ------- ----------- LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ---------- --- ----------------- ------------------ 1 8.1.7.0.0 11-NOV-13 OPEN NO 1 STARTED ALLOWED NO ACTIVE PRIMARY_INSTANCE SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production While this is what it looks like on 8.1.5: SQL> select * from v$instance; INSTANCE_NUMBER INSTANCE_NAME --------------- ---------------- HOST_NAME ---------------------------------------------------------------- VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_ ----------------- --------- ------- --- ---------- ------- ----------- LOGINS SHU DATABASE_STATUS ---------- --- ----------------- 1 8.1.5.0.0 11-NOV-13 OPEN NO 1 STARTED ALLOWED NO ACTIVE SQL> select * from v$version 2 ; BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production PL/SQL Release 8.1.5.0.0 - Production CORE Version 8.1.3.0.0 - Production TNS for Solaris: Version 8.1.5.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production So basically, v$version just reports stuff about the DB, not about the instance, even the CORE information is radically different. So, given that I can't update to newer hardware, or a later & better version of Oracle anyone got a clue? I plan to scrub 8.1.7 and re-install 8.1.7.4 and see what happens. But it would be useful to know if what I plan to do is possible before I get into the world of hurt of a barfed upgrade. :) **[UPDATE 2]** As suggested below the SQL on the running system (8.1.5.0.0) gives: DB Version: 8.1.5.0.0 Compatibility: 8.1.5 PL/SQL procedure successfully completed. While the output of strings on a copy of the dbf files in the 8.1.7 drive is even more interesting: strings TS_SYSTEM__01.dbf |grep "[0-9]\{1,2\}\.[0-9]\{1\}" Gives interesting snippets: 8.0.0.0.0 >@-- GREATEST and LEAST are not yet supported for ADTs in 8.0.2. :new.prop_versid_m := '0.0'; :new.prop_versid_m := '0.0'; 8.1.7.0.0 RDBMS version for NLS parameters, 8.1.5.0.0 RDBMS version for NLS parameters, [...] '/export1/app/oracle/product/8.0.5.0/bin [...] -- no CFILE in 8.0.2 8.1.6, 8.1.5, 8.1.5, 8.1.5 8.1.5 V3.6.2 [...] -- pre 8.1.5 version -- 8.1.5+ version -- pre 8.1.5 version M-- This is a vestigal function that was released to customers in 8.1.3 Beta. ]" -- For compatibility with 8.1 T" -- For compatibility with 8.1 M" -- For compatibility with 8.1 [...] #3-- Recovery Action Kinds (Obsolete as of 8.1.6) -- So it looks like it does have vestiges of the upgrade and roll back in it. Could be interesting.

An old computer with Oracle 8i is dead. We have the daily backup of the database (C:\oradata\). We are unable to install this old Oracle version anywhere because we don't have the install CDs for it. Can we read this database with, for example, Oracle Express? If yes, how?