Shulou(Shulou.com)06/01 Report--

I. the main file structure of Oracle

-Drive:\ Oracle\-Admin directory: log files-Ora90 directory: program files-Oradata directory: database files

Second, the startup and shutdown of the database.

1. Start at least two services: database service: OracleService "SID" listening service: Oracle "Oracle_home" TNSListener2, management tool-service 3, CMD command: Net start OracleService%SID%: on Net stop Oracle%Oracle_home%TNSListener: off

3. Uninstall the database

1. Run the wizard and execute the command to delete 2. Modify the registry: path of the regedit regedt32 key: HLM\ software\ oracle HLM\ system\ currentcontrolset\ service3, delete the file driver:\ oracle C:\ program file\ oracle

4. Use Oracle on this machine

1. Modify the files on the computer (9i): C:\ oracle\ ora90\ network\ ADMIN\ tnsnames.ora c:\ oracle\ ora90\ network\ ADMIN\ listener.ora2, modify the files on the computer (10g): C:\ oracle\ product\ 10.2.0\ db_1\ NETWORK\ ADMIN\ tnsnames.ora c:\ oracle\ product\ 10.2.0\ db_1\ NETWORK\ ADMIN\ listener.ora3, Change the content after HOST in the file to localhost or 127.0.0.1 View hostname: run cmd input: hostname View ip: run cmd input: ipconfig

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.