The Oracle client software still needs to be installed on the client computer to allow connection to the Oracle database. The database user the SQL.Net which is the Oracle connectivity layer for Oracle database. Download Oracle Client Software Version 8.1 7 Or Greater Free. Download Oracle Client Software Version 8.1 7 Or Greater Free. Oracle client software version 8.1.7. Oracle Network Client is a Shareware software in the category Miscellaneous developed by Amdocs, PC Tech Team. The latest version of Oracle Network Client is 8.1.7, released on. It was initially added to our database on. Oracle Network Client runs on the following operating systems: Windows.

• Oracle Client Software Version 8.1 7 Or Greater Free Download 32-bit
• Oracle Client Software Version 8.1 7 Or Greater Free Download Windows 10
• Oracle Client Software Version 8.1 7 Or Greater free. download full

Related searches

• » oracle client 8.1.7 download free
• » oracle client 8.1.7 free download
• » oracle 8.1.7 client download
• » oracle 8.1.7 client software
• » oracle client 8.1.7下載
• » oracle client 8i 8.1.7
• » скачать oracle client 8.1.7
• » oracle client 8.1.7 下载
• » oracle client 8.1.7
• » downloaad oracle client 8.1.7

oracle client 8.1.7 download

• More

  Oracle8.1.7 191.0

• More

  Oracle Network Client 8.1.7

• More

  Repackaged Oracle Client 8i 8.1.7

• More

  Java Update 8.0.2710.9

  The Java SE Runtime Environment contains the Java virtual machine,runtime class libraries, and Java application launcher that arenecessary to run programs written in the Java programming language.It is not a development environment and … more info..
• More

  Realtek High Definition Audio Driver 6.0.9030.1

  REALTEK Semiconductor Corp. - 168.6MB - Freeware -

  Audio chipsets from Realtek are used in motherboards from many different manufacturers. If you have such a motherboard, you can use the drivers provided by Realtek. more info..
• More

  Internet Download Manager 6.38.15

  Accelerate downloads by up to 5 times, schedule downloads, recover and resume broken downloads. The program features an adaptive download accelerator, dynamic file segmentation, high speed settings technology, and multipart downloading … more info..
• More

  Free Download Manager 6.12.1.3374

  Free Download Manager makes downloading files and videos easier and faster and helps avoid dreaded broken downloads. It is especially useful for those who are required to download files continually. more info..
• More

  VLC media player 3.0.11

  VLC Media Player Foot Pedal allows VLC Media Player to be used as transcription software for transcription of all types of media files with full foot pedal support. more info..
• More

  Microsoft SQL Server Native Client 11.4.7462.6

  Microsoft SQL Server Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. more info..
• More

  Free YouTube Download 4.3.32.1030

  Free YouTube Download. Download video from YouTube to your computer hard drive with one mouse click. Video from YouTube will be saved as AVI file. You'll be able to play it with any video player on your computer. more info..

• More

  Realtek High Definition Audio Driver 6.0.9030.1

  REALTEK Semiconductor Corp. - 168.6MB - Freeware -

  Audio chipsets from Realtek are used in motherboards from many different manufacturers. If you have such a motherboard, you can use the drivers provided by Realtek. more info..
• More

  Microsoft .NET Framework 4.8.3928

  The Microsoft .NET Framework 4 Client Profile redistributable package installs the .NET Framework runtime and associated files that are required to run most client applications.The .NET Framework is Microsoft's comprehensive and consistent … more info..
• More

  Microsoft OneDrive 20.169.0823.0008

  Store any file on your free OneDrive (fromer SkyDrive) and it's automatically available from your phone and computers—no syncing or cables needed. more info..
• More

  Apple Software Update 2.6.3.1

  Apple Software Update is a software tool by Apple that installs the latest version of Apple software. It was originally introduced to Mac users in Mac OS 9. A Windows version has been available since the introduction of iTunes 7. more info..
• More

  Windows Live Essentials 16.4.3528.0331

  Windows Live Essentials (previously Windows Live Installer) is a suite of freeware applications by Microsoft which aims to offer integrated and bundled e-mail, instant messaging, photo-sharing, blog publishing, security services and other … more info..
• More

  iTunes 12.11.0.26

  An audio player for playing and organizing digital music files. Buy music, movies, TV shows, and audiobooks, or download free podcasts from the iTunes Store 24 hours a day, 7 days a week. more info..
• More

  WinRAR 6.00.0

  WinRAR is a 32-bit/64-bit Windows version of RAR Archiver, the powerful archiver and archive manager. WinRARs main features are very strong general and multimedia compression, solid compression, archive protection from damage, processing … more info..
• More

  Microsoft Visual C++ 2010 Redistributable 12.0.30501

  The Microsoft Visual C++ 2010 SP1 Redistributable Package installs runtime components of Visual C++ Libraries required to run applications developed with Visual C++ 2010 SP1 on a computer that does not have Visual C++ 2010 SP1 installed. more info..
• More

  NVIDIA Graphics Driver 457.51

  Supported Products:GeForce 500 series:GTX 590, GTX 580, GTX 570, GTX 560 Ti, GTX 560, GTX 550 Ti, GT 545, GT 530, GT 520, 510GeForce 400 series:GTX 480, GTX 470, GTX 465, GTX 460 v2, GTX 460 SE v2, GTX 460 SE, GTX 460, GTS 450, GT 440, GT … more info..
• More

  VLC media player 3.0.11

  VLC Media Player Foot Pedal allows VLC Media Player to be used as transcription software for transcription of all types of media files with full foot pedal support. more info..

• More

  Internet Download Manager 6.38.15

  Accelerate downloads by up to 5 times, schedule downloads, recover and resume broken downloads. The program features an adaptive download accelerator, dynamic file segmentation, high speed settings technology, and multipart downloading … more info..
• More

  Free Download Manager 6.12.1.3374

  Free Download Manager makes downloading files and videos easier and faster and helps avoid dreaded broken downloads. It is especially useful for those who are required to download files continually. more info..
• More

  Microsoft SQL Server Native Client 11.4.7462.6

  Microsoft SQL Server Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. more info..
• More

  Qualcomm Atheros Client Installation Program 10.0

• More

  HP Touchpoint Analytics Client 4.0.2.1439

Most recent searches

• » logitech e3500 software for windows 10
• » microsoft office professional 2019 en-us
• » deluxe pacman 1.98c
• » download google chrome for free download
• » descargar sorfare tablero buho 21
• » presto pagemanager windows 10 freeware
• » lumia 640 update logiciel
• » ins app
• » sis 103u
• » support centre blazedtv
• » selling team iptv
• » synaptics hd clickpad hp download
• » смарт гага
• » tenorshare 4ddig
• » gry na telefon windows dowland
• » k-lite codec pack 15.9.2
• » free mp3 cutter 2.1 polysoft solutions
• » telecharger cryptotabbrowser
• » quickq download phone
• » andre&hisolive 下载

If you are installing PostGreSQL instead of Oracle, skip thissection.

OpenACS 5.9.0 will install with Oracle 9i but has not beenextensively tested so may still have bugs or tuning issues. SeeAndrew Piskorski's Oracle 9i notes forguidance.

This installation guide attempts to present all of theinformation necessary to complete an OpenACS installation. We tryhard to make all of the steps possible in one pass, rather thanhaving a step which amounts to 'go away and develop a profoundunderstanding of software X and then come back and, in 99% of allcases, type these two lines.' The exception to our rule isOracle production systems. This page describes a set of steps toget a working Oracle development server, but it is unsuitable for production systems.If you will be using OpenACS on Oracle in a production environment,you will experience many problems unless you develop a basicunderstanding of Oracle which is outside the scope of thisdocument. T

Oracle Client Software Version 8.1 7 Or Greater Free Download 32-bit

This document assumes that you'll be installing Oracle onthe same box as AOLserver. For more details on a remote Oracleinstallation, see Daryl Biberdorf's document.

Useful links to find help on how to set up Oracle under Linuxare:

Production Oracle systems should run on certified platforms.Follow the metalink note 223718.1to find certifiedplatforms. If you don't have metalink access, take a look atthe Oracle on Linux FAQ: Which LinuxDistributions Are Directly Supported By Oracle?. In summary,free and inexpensive Linux distributions are not certified.

You can download the Oracle software from the Oracle Downloads page.

Each Oracle release comes with extensive and usually quitewell-written documentation. Your first step should be to thoroughlyread the release notes for your operating system and your Oracleversion. Find the docs here:

Oracle Client Software Version 8.1 7 Or Greater Free Download Windows 10

It is generally useful to run a particular Oracle version withits latest patchset. At the time of writing these were 8.1.7.4 and9.2.0.5, both of which are considered to be very stable.

To be able to download a patchset, you need a (to-pay-for)account on Metalink. You may find the appropriate patchsetby following Andrew's suggestion.

Oracle is very well-documented software, the onlinedocumentation comes with printable PDFs and full-text search.Altogether there is more than 20.000 pages of documentation, so donot expect to understand Oracle within in a few hours. The beststarting pointing into Oracle is the Concepts book. Here's the8i version and the 9.2 version.

To give you an idea of how configurable Oracle is and how muchthought you may need to put into buying the proper hardware andcreating a sane setup, you should thoroughly read CaryMillsap's Configuring Oracle Server for VLDB and theOptimal Flexible Architecture standard.

Throughout these instructions, we will refer to a number ofconfigurable settings and advise certain defaults. With theexception of passwords, we advise you to follow these defaultsunless you know what you are doing. Subsequent documents willexpect that you used the defaults, so a change made here willnecessitate further changes later. For a guide to the defaults,please see the sectioncalled “Defaults”.

In order for OpenACS to work properly you need to set theenvironment appropriately.

For additional resources/documentation, please see thisthread and Andrew Piskorski's mini-guide.

Though Oracle 8.1.7 has an automated installer, we still need toperform several manual, administrative tasks before we can launchit. You must perform all of these steps as the root user. We recommend entering the Xwindow system as a normal user and then doing a su -. This command gives you full rootaccess.

• Login as a non-root user and start X by typing startx

• Open a terminal window type and login as root

• Create and setup the oraclegroup and oracle account

  We need to create a user oracle, which is used to install theproduct, as well as starting and stopping the database.

  You will be prompted for the New Password and Confirmation ofthat password.

• Setup the installation location for Oracle. While Oracle canreside in a variety of places in the file system, OpenACS hasadopted /ora8 as the basedirectory.

  Note: the Oracleinstall needs about 1 GB free on /ora8 to install successfully.

• Set up the oracle user'senvironment

  • Log in as the user oracle bytyping the following:

  • Use a text editor to edit the .bash_profile file in the oracle account home directory.

    You may get this error trying to start emacs:

    If so, open a new terminal window and do the following:

    Now, back in the oracle terminal:

    Try this procedure anytime you get an Xlib connection refusederror.

  • Add the following lines (substituting your Oracle version numberas needed) to .bash_profile:

    Save the file by typing CTRL-XCTRL-S and then exit by typing CTRL-X CTRL-C. Alternatively, use themenus.

  Make sure that you do not add any lines like thefollowing

  These lines will change the Oracle date settings and will breakOpenACS since OpenACS depends on the ANSI date format, YYYY-MM-DDdates.

• Log out as oracle

• Log back in as oracle anddouble check that your environment variables are as intended. Theenv command lists all of thevariables that are set in your environment, and grep shows you just the lines you want(those with ORA in it).

  If it worked, you should see:

  If not, try adding the files to ~/.bashrc instead of .bash_profile. Then logout and log back inagain. Also, be certain you are doing su - oracle and not just su oracle. The - means that .bashrc and .bash_profile will be evaluated.

  Make sure that /bin,/usr/bin, and /usr/local/bin are in your path bytyping:

  If they are not, then add them to the .bash_profile by changing the PATHstatement above to PATH=$PATH:/usr/local/bin:$ORACLE_HOME/bin

• Log in as oracle and start Xif not already running. Start a new terminal:

• Find the runInstallerscript

  • If you are installing Oracle from a CD-ROM, it is located in theinstall/linux path from thecd-rom mount point

  • If you are installing from the tarball, the install script islocated in the Oracle8iR2directory that was created when you expanded the archive.

  Check to make sure the file is there.

  If you don't see runInstaller, you are in the wrongdirectory.

• Run the installer

  A window will open that welcomes you to the 'OracleUniversal Installer' (OUI). Click on 'Next'

  Note

  Some people have had trouble with this step on RedHat 7.3 and8.0. If so, try the following steps before calling ./runInstaller:

  1. Execute the following command: /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.sh

  2. Type exportLD_ASSUME_KERNEL=2.2.5

• The 'File Locations' screen in the OUI:

  • 'Source' path should have been prefilled with'(wherever you mounted the CDROM)/stage/products.jar'

  • 'destination' path says '/ora8/m01/app/oracle/product/8.1.7'

    If the destination is not correct it is because your environmentvariables are not set properly. Make sure you logged on asoracle using su - oracle. If so, edit the ~/.bash_profile as you did in the section called “Pre-InstallationTasks”

  • Click 'Next' (a pop up window will display LoadingProduct information).

• The 'Unix Group Name' screen in the OUI:

  • The Unix Group name needs to be set to 'oinstall' ( we made this Unix groupearlier ).

  • Click 'Next'

  • A popup window appears instantly, requesting you to run a scriptas root:

  • • Debian users need to link /bin/awk to /usr/bin/awk before running the scriptbelow

  • Open a new terminal window, then type:

  • Click 'Retry'

• The 'Available Products' screen in the OUI:

  • Select 'Oracle 8i Enterprise Edition 8.1.7.1.0'

  • Click 'Next'

• The 'Installation Types' screen

  • Select the 'Custom' installation type.

  • Click 'Next'

• The 'Available Product Components' screen

  • In addition to the defaults, make sure that 'Oracle SQLJ8.1.7.0,' 'Oracle Protocol Support 8.1.7.0.0,' and'Linux Documentation 8.1.7.0.0' are also checked.

  • Click 'Next'

  • A progress bar will appear for about 1 minute.

• The 'Component Locations' screen in the OUI

  • Click on the 'Java Runtime Environment 1.1.8' Itshould have the path '/ora8/m01/app/oracle/jre/1.1.8'

  • Click 'Next'

  • A progress bar will appear for about 1 minute.

• The 'Privileged Operation System Groups' screen in theOUI

  • Enter 'dba' for 'Database Administrator (OSDBA)Group'

  • Enter 'dba' for the 'Database Operator (OSOPER)Group'

  • Click 'Next'

  • A progress bar will appear for about 1 minute.

• The 'Authentication Methods' screen

• The next screen is 'Choose JDK home directory'

  • Keep the default path: /usr/local/java

  • Click 'Next'

• The 'Create a Database' screen in the OUI

  • Select 'No' as we will do this later, after someimportant configuration changes.

  • Click 'Next'

• The next screen is 'Oracle Product Support'

  • TCP should be checked with 'Status' listed asRequired

  • Click 'Next'

• The 'Summary' screen in the OUI

  • Check the 'Space Requirements' section to verify youhave enough disk space for the install.

  • Check that '(144 products)' is in the 'NewInstallations' section title.

  • Click 'Install'

  • A progress bar will appear for about 20 - 30 minutes. Now is agood time to take a break.

  • A 'Setup Privileges' window will popup towards the endof the installation asking you to run a script as root

  • Run the script. Switch to the oracle user first to set theenvironment appropriately and then do su to get root privileges, whilekeeping the oracle user's environment.

  • Do not follow the instructions on deleting trace and log files,it is not necessary.

• Go back to the pop-up window and click 'OK'

• The 'Configuration Tools' screen in the OUI

  • This window displays the config tools that will automatically belaunched.

• The 'Welcome' screen in the 'net 8 ConfigurationAssistant'

  • Make sure the 'Perform Typical installation' isnot selected.

  • Click 'Next'

  • The 'Directory Service Access' screen in the 'Net8 Configuration Assistant'

  • Select 'No'

  • Click 'Next'

• The 'Listener Configuration, Listener Name' screen inthe 'Net 8 Configuration Assistant'

  • Accept the default listener name of 'LISTENER'

  • Click 'Next'

• The 'Listener Configuration, Select Protocols' screenin the 'Net 8 Configuration Assistant'

  • The only choice in 'Select protocols:' should be'TCP/IP'

  • Click 'Next'

• The 'Listener Configuration TCP/IP Protocol' screen inthe 'Net 8 Configuration Assistant'

  • Default Port should be 1521 and selected.

  • Click 'Next'

• The 'Listener Configuration, More Listeners' screen inthe 'Net 8 Configuration Assistant'

• The 'Listener Configuration Done' screen in the'Net 8 Configuration Assistant'

  • Click 'Next'

• The 'Naming Methods Configuration' screen in the'Net 8 Configuration Assistant'

• The 'Done' screen in the 'Net 8 ConfigurationAssistant'

  • Click 'Finish'

• The 'End of Installation' screen in the OUI

  • Click 'Exit'

  • Click 'Yes' on the confirmation pop up window.

  • The Oracle Universal Installer window should havedisappeared!

Congratulations, you have just installed Oracle 8.1.7 Server!However, you still need to create a database which can take aboutan hour of non-interactive time, so don't quit yet.

This step will take you through the steps of creating acustomized database. Be warned that this process takes about anhour on a Pentium II with 128 MB of RAM.

• Make sure you are running X. Open up a terminal and su to oracle and then run the dbassist program.

• The 'Welcome' screen in the Oracle DatabaseConfiguration Agent (ODCA)

• The 'Select database type' screen in the ODCA

  • Select 'Custom'

  • Click 'Next'

• The 'Primary Database Type' window in ODCA

• The 'concurrent users' screen of the ODCA

  • Select '60' concurrent users.

  • Click 'Next'

• Select 'Dedicated ServerMode', click 'Next'

• Accept all of the options, and click Next Oracle Visual Information Retrievalmay be grayed out. If so, you can ignore it; just make sure thateverything else is checked.

• For 'Global Database Name', enter 'ora8'; for 'SID', also enter'ora8' (it should dothis automatically). Click 'Change Character Set and selectUTF8. Click 'Next'.

• Accept the defaults for the next screen (control file location).Click 'Next'

• Go to the 'temporary' and 'rollback' tabs,and change the Size (upper-right text box) to 150MB. Click 'Next'

• Increase the redo log sizes to 10000K each. Click 'Next'

• Use the default checkpoint interval & timeout. Click'Next'

• Increase 'Processes' to 100; 'Block Size' to 4096 (better for small Linux boxes; use8192 for a big Solaris machine).

• Accept the defaults for the Trace File Directory. Click'Next'

• Finally, select 'Saveinformation to a shell script' and click'Finish' (We'regoing to examine the contents of this file before creating ourdatabase.)

• Click the 'Save'button. Oracle will automatically save it to the correct directoryand with the correct file name. This will likely be /ora8/m01/app/oracle/product/8.1.7/assistants/dbca/jlib/sqlora8.sh

• It will alert you that the script has been savedsuccessfully.

• Now we need to customize the database configuration a bit. Whilestill logged on as oracle, editthe database initialization script (run when the db loads). Thescripts are kept in $ORACLE_HOME/dbs and the name of the scriptis usually initSID.ora where SID is the SID of your database.Assuming your $ORACLE_HOMEmatches our default of /ora8/m01/app/oracle/product/8.1.7, thefollowing will open the file for editing.

• Add the following line to the end:

• Now find the open_cursorsline in the file. If you're using emacs scroll up to the top of the bufferand do CTRL-S and typeopen_cursors to find the line.The default is 100. Change itto 500.

• Save the file. In emacs, do CTRL-XCTRL-S to save followed by CTRL-X CTRL-C to exit or use the menu.

• At this point, you are ready to initiate database creation. Werecommend shutting down X to free up some RAM unless you have 256MB of RAM or more. You can do this quickly by doing a CRTL-ALT-BACKSPACE, but make sure you havesaved any files you were editing. You should now be returned to atext shell prompt. If you get sent to a graphical login screeninstead, switch to a virtual console by doing CRTL-ALT-F1. Then login as oracle.

• Change to the directory where the database creation script isand run it:

  In some instances, Oracle will save the file to /ora8/m01/app/oracle/product/8.1.7/assistants/dbcaTry running the script there if your first attempt does notsucceed.

• Your database will now be built. It will take > 1 hour - nofooling. You will see lots of errors scroll by (like:'ORA-01432: public synonym to be dropped does not exist')Fear not, this is normal.

  Eventually, you'll be returned to your shell prompt. In themeantime, relax, you've earned it.

For this step, open up a terminal and su to oracle as usual. You should be running Xand Netscape (or other web browser) for this phase.

• You need to download the 'Oracle Acceptance Test'file. It's available here and at http://philip.greenspun.com/wtr/oracle/acceptance-sql.txt.Save the file to /var/tmp

• In the oracle shell, copy the file.

• Once you've got the acceptance test file all set, stay inyour term and type the following:

  SQL*Plus should startup. If you get an ORA-01034: Oracle not Available error, itis because your Oracle instance is not running. You can manuallystart it as the oracleuser.

• Now that you're into SQL*Plus, change the default passwordsfor system, sys, and ctxsys to 'alexisahunk' (or tosomething you'll remember):

• Verify that your date settings are correct.

  If you don't see a date that fits the format YYYY-MM-DD, please read the section called “TroubleshootingOracle Dates”.

• At this point we are going to hammer your database with anintense acceptance test. This usually takes around 30 minutes.

  Many people encounter an error regarding maximum key length:

  This error occurs if your database block size is wrong and isusually suffered by people trying to load OpenACS into apre-existing database. Unfortunately, the only solution is tocreate a new database with a block size of at least 4096. For instructions on how to do this,see the section called “Creating theFirst Database” above. You can set the parameter using thedbassist program or by settingthe DB_BLOCK_SIZE parameter inyour database's creation script.

  If there were no errors, then consider yourself fortunate. YourOracle installation is working.

You will want to automate the database startup and shutdownprocess. It's probably best to have Oracle spring to life whenyou boot up your machine.

• Oracle includes a script called dbstart that can be used to automaticallystart the database. Unfortunately, the script shipped in the Linuxdistribution does not work out of the box. The fix is simple.Follow these directions to apply it. First, save dbstart to /var/tmp. Then, as oracle, do the following:

• While you're logged in as oracle, you should configure theoratab file to load yourdatabase at start. Edit the file /etc/oratab:

  • You will see this line.

    By the way, if you changed the service name or have multipledatabases, the format of this file is:

    Bangla software bijoy 52 download. Bijoy 52 bangla software free download - Ridmik-Keyboard for Windows 10, and many more programs. Dec 26, 2019 bijoy bayanno Bijoy 52 Bangla Typing Software Download. Bijoy 52 is a very old type of software for newcomers. Newcomers don’t want to use Bijoy Bayanno. They want to use Avro Keyboard. Because Avro is a freeware software and it is more user-friendly than Bijoy Bangla Typing Software.

    service_name:$ORACLE_HOME:Y N (forautoload)

  • Change the last letter from 'N' to 'Y'. Thistells Oracle that you want the database to start when the machineboots. It should look like this.

  • Save the file & quit the terminal.

• You need a script to automate startup and shutdown. Saveoracle8i.txt in /var/tmp. Then login as root and install the script. (Debian users:substitute /etc/init.d for/etc/rc.d/init.d throughoutthis section)

• Test the script by typing the following commands and checkingthe output. (Debian Users: as root, do mkdir /var/lock/subsys first)

• If it worked, then run these commands to make the startup andshutdown automatic.

• You also need some scripts to automate startup and shutdown ofthe Oracle8i listener. The listener is a name server that allowsyour Oracle programs to talk to local and remote databases using astandard naming convention. It is required for Intermedia Text andfull site search.

  Download these three scripts into /var/tmp

  Now issue the following commands (still as root).

  Test the listener automation by running the following commandsand checking the output.

  This test will verify that the listener is operating normally.Login into the database using the listener naming convention.

  sqlplususername/password/@SID

  • RedHat users:

    Now run chkconfig on thelistener8i script.

  • Debian users:

    Now run update-rc.d on thelistener8i script.

• Test the automation

  As a final test, reboot your computer and make sure Oracle comesup. You can do this by typing

  Log back in and ensure that Oracle started automatically.

Congratulations, your installation of Oracle 8.1.7 iscomplete.

Oracle has an internal representation for storing the data basedon the number of seconds elapsed since some date. However, for thepurposes of inputing dates into Oracle and getting them back out,Oracle needs to be told to use a specific date format. By default,it uses an Oracle-specific format which isn't copacetic. Youwant Oracle to use the ANSI-compliant date format which is of form'YYYY-MM-DD'.

To fix this, you should include the following line in$ORACLE_HOME/dbs/initSID.ora or for the default case, $ORACLE_HOME/dbs/initora8.ora

You test whether this solved the problem by firing upsqlplus and typing:

Oracle Client Software Version 8.1 7 Or Greater free. download full

You should see back a date like 2000-06-02. If some of the date is choppedoff, i.e. like 2000-06-0,everything is still fine. The problem here is that sqlplus is simply truncating the output.You can fix this by typing:

If the date does not conform to this format, double-check thatyou included the necessary line in the init scripts. If it stillisn't working, make sure that you have restarted the databasesince adding the line:

If you're sure that you have restarted the database sinceadding the line, check your initialization scripts. Make sure thatthe following line is not included:

Setting this environment variable will override the datesetting. Either delete this line and login again or add thefollowing entry to your login scripts after the nls_lang line:

Log back in again. If adding the nls_date_format line doesn't help, youcan ask for advice in our OpenACSforums.

• Dropping a tablespace

  • Run sqlplus as the dba:

  • To drop a user and all of the tables and data owned by thatuser:

  • To drop the tablespace: This will delete everything in thetablespace overriding any referential integrity constraints. Runthis command only if you want to clean out your databaseentirely.

For more information on Oracle, please consult the documentation.

We used the following defaults while installing Oracle.