RE: Oracle 9i installation - Basic Qs
Try executing the xhost command as root first. Then you should be able to execute xhost + command. Nancy -Original Message- VIVEK_SHARMA Sent: Tuesday, November 26, 2002 8:39 AM To: Multiple recipients of list ORACLE-L Oracle 9i installation on Solaris being attempted # xhost + Message - unable to open display : export DISPLAY=PC Client IP address:0.0 # xhost + Xlib : connection to client refused PC Client IP Address Xlib : cannot set display to PC Client IP Address NOTE - Installation being initiated from a laptop using Exceed Hummingbird software to simulate Xwindows Console Any Solutions ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Wait Event PX Deq: Execution Msg
I failed to mention this is an 8.1.7.3 database. Sorry about that. Nancy -Original Message- McCormick Sent: Thursday, May 16, 2002 7:53 PM To: Multiple recipients of list ORACLE-L Hello, I am hoping someone can help me with an elusive wait event called 'PX Deq: Execution Msg'. As you can see from the statspack Top 5 Wait Events this event accounts for almost 75% of the wait time. I have been looking in past Oracle-L posts, Google, Oracle FAQ, OTN, Metalink, Oracle manuals, etc. I can find almost nothing about this event. What I did find leads me to believe may be an idle event and that it is the second event 'PX Deq Credit: send blkd' that may be the more troublesome one. However I am still confused about both. Can someone help set me straight or tell me where there might be some more information about these 2 events? Thanks, Nancy Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time - -- PX Deq: Execution Msg 42,1448,639,803 74.48 PX Deq Credit: send blkd 15,3392,878,443 24.81 log file parallel write41,934 30,787 .27 db file parallel write 8,776 25,046 .22 db file sequential read24,767 18,255 .16 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Wait Event PX Deq: Execution Msg
Hello, I am hoping someone can help me with an elusive wait event called 'PX Deq: Execution Msg'. As you can see from the statspack Top 5 Wait Events this event accounts for almost 75% of the wait time. I have been looking in past Oracle-L posts, Google, Oracle FAQ, OTN, Metalink, Oracle manuals, etc. I can find almost nothing about this event. What I did find leads me to believe may be an idle event and that it is the second event 'PX Deq Credit: send blkd' that may be the more troublesome one. However I am still confused about both. Can someone help set me straight or tell me where there might be some more information about these 2 events? Thanks, Nancy Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time - -- PX Deq: Execution Msg 42,1448,639,803 74.48 PX Deq Credit: send blkd 15,3392,878,443 24.81 log file parallel write41,934 30,787 .27 db file parallel write 8,776 25,046 .22 db file sequential read24,767 18,255 .16 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT - Unix Script to get file name and size from remote server
This may be a little off topic so I apologize in advance. But I have seen some good Unix scripting help come across lately so I thought I would go ahead and send this. I am trying to setup a Unix script that will logon to a remote server, get the name and size of all the files in a remote directory and write the results to a local directory. I need to do this to ensure that all the source files for loading our data warehouse have been received and are complete. The list of files to be received changes nightly and I don't have the ability to add a record to the files that would provide an end of file marker. I have tested ftp using ls but it only allows a short list of file names, not the long listing with file sizes. I have also tried nlist, size and dir from ftp but those commands don't allow printing the results to the local server. I have tried rsh and rlogin but these commands just sit there with no response. I have to use an ip address, not the hostname, so I don't know if this is the problem or not. I have the SA looking into this for me. I could probably setup a cron job on the remote server to do the long listing of the directory and then ftp the results to my local server, but then this would be outside the control of my load process. I would prefer to do everything from the local server if possible. Any ideas? Thanks, Nancy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT - Unix Script to get file name and size from remote server
I finally got the ls -l command with ftp working. It didn't like having the remotedirectory specified so I just do a cd to the remote directory and then ls -l with the local file name. Here is a snippet from the script I am running right now # set variables SITE_DIR=$1; export SITE_DIR . DWH.ENV . $SITE_DIR.ENV # # generate ftp command list rm $KSH_DIR/ftp_$SITE_DIR.ksh echo 'ftp -n -v *EOI ' $KSH_DIR/ftp_$SITE_DIR.ksh echo 'open '$RSRV $KSH_DIR/ftp_$SITE_DIR.ksh echo 'user '$FTPU' '$FTPP $KSH_DIR/ftp_$SITE_DIR.ksh echo 'cd '$RDIR $KSH_DIR/ftp_$SITE_DIR.ksh echo 'get report.nite.list' $KSH_DIR/ftp_$SITE_DIR.ksh echo 'ls -l '$SITE_DIR'_files.lst' $KSH_DIR/ftp_$SITE_DIR.ksh echo 'bye ' $KSH_DIR/ftp_$SITE_DIRksh echo '*EOI ' $KSH_DIR/ftp_$SITE_DIR.ksh chmod 744 $KSH_DIR/ftp_$SITE_DIR.ksh # # execute ftp command cd $KSH_DIR $KSH_DIR/ftp_$SITE_DIR.ksh I am going to continue to look at the rsh options as the commands I can execute via rsh may produce more reliable results. Thanks to everyone who responded for your help and suggestions. Nancy -Original Message- McCormick Sent: Friday, March 01, 2002 9:09 AM To: Multiple recipients of list ORACLE-L This may be a little off topic so I apologize in advance. But I have seen some good Unix scripting help come across lately so I thought I would go ahead and send this. I am trying to setup a Unix script that will logon to a remote server, get the name and size of all the files in a remote directory and write the results to a local directory. I need to do this to ensure that all the source files for loading our data warehouse have been received and are complete. The list of files to be received changes nightly and I don't have the ability to add a record to the files that would provide an end of file marker. I have tested ftp using ls but it only allows a short list of file names, not the long listing with file sizes. I have also tried nlist, size and dir from ftp but those commands don't allow printing the results to the local server. I have tried rsh and rlogin but these commands just sit there with no response. I have to use an ip address, not the hostname, so I don't know if this is the problem or not. I have the SA looking into this for me. I could probably setup a cron job on the remote server to do the long listing of the directory and then ftp the results to my local server, but then this would be outside the control of my load process. I would prefer to do everything from the local server if possible. Any ideas? Thanks, Nancy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix Book
O'Reilly has a CD Bookshelf of 6 Unix books. Very good and priced right. It has the books already mentioned as well as others like Learning the Korn Shell and sed awk. I have found it very useful. Nancy -Original Message- Lembark Sent: Friday, February 01, 2002 11:25 AM To: Multiple recipients of list ORACLE-L -- Hamid Alavi [EMAIL PROTECTED] Hi, Anybody knows any good book for Unix Beginner people, If yes Please let me know I really appreciate O'Reilly Press has several, Learning Unix is probbly a good place to start. Learning to Use the VI Editor is probbly another good item. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
I believe that schema changes are only automatically propagated to all sites by using the Replication Manager orthe DBMS_REPCAT package. Nancy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ALEMU AbiySent: Monday, November 12, 2001 1:40 AMTo: Multiple recipients of list ORACLE-LSubject: Replication question I'm setting up a basic replication on a 8.1.7 oracle database and I'm wondering if a schema change is also replicated along with data changes. If I modify the structure of a table on the master site, is that modification is propagated to my snapshot site ? Please help
RE: Standby vs. Adv. Replication (Multi-master)
I too have had the wonderful experience of supporting multi-master replication. We had 3 sites and there was a lot of work maintaining it. I have not had the opportunity to implement a standby-database yet but from talking with those who have setting up and maintaining a standy-by database would be less painful that setting up advanced replication. Either way you need to evaluate your network. One of the killers for our initial advanced replication environment was network speed. There just wasn't enough 'umph' to replicate the data real-time (every 60 seconds) between 3 sites. We used our environment to split workload as well as provide availability when one of the servers was down (either voluntarily or involuntarily). The failover was fairly straight forward, change the DNS information to point the clients to another server and break the push jobs related to the down server. Getting the database back in sync afterwards was a different matter. We were pushing approximately 10,000 database calls an hour. The transaction queue would get so full that many times we simply had to do a complete refresh of the database. I could keep going on but I guess what I am trying to say is that if you are going to be using the secondary database strictly for failover then it seems to me that the standby-database solution would be easier to implement and maintain. Nancy -Original Message- Sent: Friday, May 25, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Hi, I'm looking for feedback on setting up a high-availability architecture for our production database. In a nutshell, we are a 24-hour shop and I need to be able to keep a secondary database (failover) in sync with the primary in case the primary fails. I have supported advanced replication (asynchronous) in the past but it was a single master relationship not multi-master. I'm leaning towards a standby database setup because my experience with advanced replication is less than favorable if/when transactions get out of sync. Also, one of the tables contains a LONG RAW. This column may go away or may be converted to a CLOB in the very near future but still needs to be kept in consideration when selecting a solution. The platform is Sun (SunOS 5.7) with 8.1.6. The secondary machine and database will most likely be located in another state. The database is small right now (~10Gb) and will continue to grow, but not too fast. What are your opinions? Is there an obvious choice between the two alternatives? Is there another alternative that I should be considering? Thanks VERY much in advance. -w __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Portal Problem
We recently installed the 9iAS and the Portal products on 2 Sun Solaris boxes (1 for the front end, 1 for the back end). For the first couple of weeks the Portal product was working smoothly. However last week the developers started encountering some errors. To my knowledge nothing has changed on the servers or the Oracle products. But I cannot guarantee that since once I installed the product and got the word they were functioning, I went on to other things. What follows is the information I received from the developers about the problems. Can anyone give me a clue as to where to start looking? I have checked for invalid objects on the database and everything appears valid.I also looked in Metalink and go no hits for any of these error messages. I'm not sure what the next step should be in troubleshooting this problem. Thanks in advance, Nancy = Starting Developer's message = We can RUN pages and portlets, we cannot EDIT or CREATE new portlets. If we try to create a new portlet we get what appears to be help text, but no wizard pages. If we try to edit an existing portlet, we get errors similar to the errors below, which are related to packages owned by Portal30. However we get the same errors when we sign on as Portal30 and try to edit a portlet, so it appears to be related to permissions on some other schema's tables that are referenced in the Portal30 package. The packages are in the database and are marked as valid, however since they are wrapped, we cannot determine what table(s) are missing the appropriate permissions. * *** This error occurs when signed on as a non-Portal30 user. * Box Background Color COMBOBOX LOV ERROR: LOV: SYSTEM_COLORS Parse Message: Query not found, unable to parse. Find Message: Security Violation for LOV SYSTEM_COLORS wwv_security.check_comp_privilege: Insufficient privileges. * *** These errors occur when signed on as the Portal30 user. * !--StartFragment--Thu, 24 May 2001 14:37:07 GMT ORA-00942: table or view does not exist ORA-06512: at PORTAL30.WWV_DESCRIBE, line 194 ORA-06512: at PORTAL30.WWV_UIFORM_BUILD, line 5814 ORA-06512: at line 8 DAD name: portal30 PROCEDURE : PORTAL30.wwv_uiform_build.show_right_frame URL: http://server_ip_address:/pls/portal30/PORTAL30.wwv_uiform_build.show_ri ght_frame?p_wizard_mode=TABLEp_module_id=1570228603p_version=2p_section=5 p_save_version=3p_mode=EDITp_step=p_total_steps=3p_last_reqstep=3p_for mlayout_type=STRUCTURED_LAYOUTp_type=formp_owner=MY_HLWp_table_name=HLW_C USTOMERSp_orig_field_names=INSERT_TOP*!UPDATE_TOP*!DELETE_TOP*!QUERY_TOP*!R ESET_TOP*!*TOP_SECTION**!ID*!NAME*!PHONE_NUMBER*!EMAIL_ADDRESS*!ADDRESS_LINE 1*!CITY*!STATE*!POSTAL_CODE*!COUNTRY*!REGION_ID*!*BOTTOM_SECTION**!PREVIOUS* !NEXTp_redirect_url=http%3A%2F%2F172.29.102.180%3A%2Fservlet%2Fpage%3F_ pageid%3D3%2C22%26_dad%3Dportal30%26_schema%3DPORTAL30%26_mode%3D3%26p_rende r%3DLIST%26p_otype%3DAPP%26p_octx%3DMY_HLW.CASEBOOK30_APPLICATION%26p_action %3D%26p_caller%3DPORTLET%26p_domain%3Dwwc%26p_sub_domain%3Dappexp%26p_rpth%3 D49_APPLICATIONEXPLORER_652602%26p_orderby%3D%26p_request%3D%26p_min_row%3D1 %26p_max_rows%3D49%26p_page_number%3D1 = !--StartFragment--FONT size=2Thu, 24 May 2001 14:33:12 GMT ORA-00942: table or view does not exist ORA-06512: at PORTAL30.WWV_DESCRIBE, line 194 ORA-06512: at PORTAL30.WWV_UIFORM_BUILD, line 2778 ORA-06512: at PORTAL30.WWV_UIFORM_BUILD, line 5647 ORA-06512: at line 8 DAD name: portal30 PROCEDURE : PORTAL30.wwv_uiform_build.show_header URL: http://server_ip_address:/pls/portal30/PORTAL30.wwv_uiform_build.show_he ader?p_wizard_mode=TABLEp_module_id=1564981795p_version=2p_section=5p_sa ve_version=2p_mode=EDITp_step=p_total_steps=3p_last_reqstep=3p_redirect _url=http%3A%2F%2F172.29.102.180%3A%2Fservlet%2Fpage%3F_pageid%3D3%2C22% 26_dad%3Dportal30%26_schema%3DPORTAL30%26_mode%3D3%26p_render%3DLIST%26p_oty pe%3DAPP%26p_octx%3DMY_HLW.CASEBOOK30_APPLICATION%26p_action%3D%26p_caller%3 DPORTLET%26p_domain%3Dwwc%26p_sub_domain%3Dappexp%26p_rpth%3D49_APPLICATIONE XPLORER_652602%26p_orderby%3D%26p_request%3D%26p_min_row%3D1%26p_max_rows%3D 49%26p_page_number%3D1 /FONT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Happy Birthday List !!
Was there a cake and I missed it? -Original Message- Sent: Thursday, April 26, 2001 4:46 PM To: Multiple recipients of list ORACLE-L On Thursday 26 April 2001 12:37, Jenny Jacobson wrote: Jared sent out his notice of the new mailing list on May 26, 1998. And I would still have the archives with that message if I hadn't fat fingered a @#$# rm command. Jared ( who thought he had learned his lesson on backups ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9iAS and Portal 3.0
I have installed Oracle 9iAS and am having problems with the Portal 3.0 install. The 9iAS server is Solaris 8 with 9iAS 1.0.2.1. The database server is Solaris 8 with Oracle 8.1.7. I am very new to Java and Apache so I hope someone can help steer me in the right direction. I am using the metalink document 132444.1 "Common Installation Problems with Portal 3.0 (9IAS)" to help me troubleshoot. My first problem was that the Java Virtual Machine was not properly installed in the database. I ran initjvm.sql and then reinstalled Portal 3.0. That took care of the first set of problems. When I try to connect to the "Portal Page", "Login Server Page" or the "Gateway Settings Page" I get a "Page cannot be Displayed" message. So ... Now I am trying to verify that the Apache Listener and Jserver are set up correctly. I can access http://machine_ip_address: . This page has the "HTTP Components" listed. I can access everything on this page but: "Jserver Demo" http://machine_ip_address:/servlet/IsItWorking/ and "mod_plsql" http://machine_ip_address:/pls/portal30_sso/portal30_sso.wwsso_app_admin .ls_login The document says that if you cannot access the Jserver Demo to verify that JDK 1.2.2 is installed. In my case it was not, so I downloaded the JDK 1.2.2_07 self extracting binary from Sun and installed it. I changed the jserv.properties file to point wrapper.bin to the location where JDK 1.2.2 was installed and added 2 wrapper.classpath lines for the dt.jar and tools.jar. I also modified the PATH variable to have the JDK 1.2.2 location as the first directory in the list. Then I stopped and started the Apache listener. I also verified that I can connect from the 9iAS server to the Database server using sqlplus which was successful. I still cannot access the Jserv Demo. I really don't know what to look at next. Any ideas? Thanks, Nancy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
No Subject
LISTS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: identify which logs are need to start recovery
I believe that it gets the log sequence number by comparing the change# to the change# in the v$log_history table. Nancy -Original Message- Sent: Thursday, March 29, 2001 3:19 AM To: Multiple recipients of list ORACLE-L Lisa/List, when we restore a datafile from a backup, oracle will check the change# in the header of the datafile and will try to match it with the one in the controlfile, correct ? that's how oracle will know that the file is out-of-sync, now oracle will prompt from the change# as well as the log sequence number to apply !! from where does it get the log sequence number ? is it sotred in each datafile ? or oralce queries it from v$log_history ? Rahul -- From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:02 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: identify which logs are need to start recovery Hi Rahul, I'm not sure if there's a v$ view that will tell you, I remember looking for this myself. However if you initiate recovery it will ask for the appropriate arclog, and you can always cancel out. During testing, I found that it will ask for every single one since the backup set from which you restored your datafile, regardless of whether or not it needs it (in this case, the datafile that was lost didn't contain any tables that had changed since the last backup. Go figure). HTH Lisa Rutland Koivu Oracle Database Administrator [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- From: Rahul [ mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 11:13 PM To: Multiple recipients of list ORACLE-L Subject: identify which logs are need to start recovery usually i keep 2-3 previous archived logs, after switching and starting the hotbackup... but is there a v$ view to show which logs are needed to start the recovery ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Scripts -- Scripts -- Scripts (One more time)
Have you seen the book "SQL and PL/SQL Annotated Archives"? I believe this should have what you are looking for. Nancy -Original Message- ksksksk Sent: Tuesday, February 13, 2001 1:31 PM To: Multiple recipients of list ORACLE-L Thanks to all who replied. Thanks all who answered. Mary's script has benn very useful. Unfortunately, this script does not generate the "procedure", "packages" and "triggers" scripts. Does someone have some scripts to do so ? thanks everybody. --- "Ruiz, Mary A (CAP, CDI)" [EMAIL PROTECTED] escribi: Pablo: Hola ! Here is something that was posted to the list that I have found to be extremely useful. This uses a .dmp file produced by exp, and generates ddl for your database. Buena Suerte. Mary Ruiz / Atlanta GA -Original Message- From: Som Priani Sent: Thursday, November 02, 2000 8:12 AM To: Multiple recipients of list ORACLE-L Subject: Life made easier : Scripts to Extract DDL from Export DUMP Hi Listers, Scenario : Build a test/play database from an export dump from Production (those monstrous sizes) but do not have disk space to accomodate all the extents... Rummaging through the dump file and/or precreating tablespaces and objects and then importing the rest is the solution!! Even if all the SQL scripts are available - running them in the order of dependency will be quite tedious and error prone. I have created Korn shell scripts to extract the DDL for objects which need disk space in the database and then to reduce them by a factor or set them to a fixed value. Please find them at http://members.tripod.com/Som_Priani The strategy Create a new database Extract the SQL scripts from the export dump using the utility Resize file and extent sizes ( the editing has been automated ) CREATE TABLESPACES CREATE ROLLBACK SEGMENTS CREATE PROFILES CREATE USERS CREATE ROLES GRANT SYSTEM PRIVS to USERS REVOKE SYSTEM GRANTS /ALTER users CREATE TABLES CREATE INDEXES Import with IGNORE=Y to get all the constraints, stored programs, triggers... Takes a few minutes to run the whole thing - try it out... Bouquets and Brickbats welcome!! Please use backchannel. HTH Som Priani -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Som Priani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) ___ Do You Yahoo!? Enva mensajes instantneos y recibe alertas de correo con Yahoo! Messenger - http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
