Oracle 9i Installation Note Author: Tansfdate: 2004-11-10
First, some information of the installation process Oracle 9i a total of three disc 1 global database name: tan.eyesomdbsid: TAN --- Need manual input
2 Database file directory C: / Oracle / ORADATA
3 Database Information Global Database Name: Tan.EyesomDBSID: Tan Global Database Name: Tan.EyesomDBSID: Tansys Password: Change_on_install - Change to: SYS123456System Password: Manager - Change to: System123456
Second, create a database 1) Open the program Oracle - ORAHOME90 -> Configuration and Migration Tools -> Database Configuration Assistant2 Select Template to create Database Template Name: Data Warehouse3) Specify Database Information Global Database Name: Ticket.Mishisid: Ticket4) Select The default mode 5) Initialization parameter 6) Database storage 7) Creating Options 8) Summary Creating a database seems to have a space to 1G, then cancel the creation of the database
Third, Enterprise Manager Console Management 1 Open the Administrator Oracle - ORAHOME90 -> Enterprise Manager console2 When you select "Separate" (1) When you enter the database, you will be prompted to enter the following information User Name: Password: Service: Tan.ADServer1 - This has appeared by default, and it is not changed - Active Directory is installed before, then delete Active Directory, and then add the domain AdServer1. - The system exits the domain adServer1, there is no connection to the identity: (there are several options)
(2) The host name is used by the IP address when adding a database to the tree, port 1521. An error occurred when connecting "ORA-12541: TNS: No Monitor" to start OracleraHome90TnsListener from the service, or use the command "net start oracleoraHome90tnslistener" to start the prompt OracleraHome90TnsListener started successfully, but still have such an error, OracleraHome90tnsListener is restored to No state of start
Remove the original monitor Listener by NET Configuration Assistant, re-add the monitor Listener, during the protocol option, add all protocols into the login database, ORA-01017: Invalid UserName / Password, User: SYSMAN Password: SYSTEM123456 (System Password) or Sys123456 (SYS Password) Connection Identity: Sysdba - Sign in Successful
File C: /oracle/ora90/network/admin/tnsnames.ora saved the tree database ....
(3) After the SQL operation login, after entering the management interface, select: Tool -> Database Application -> SQL Plus Worksheet
Connection database SQL> Connect / as sysdbasql> select sysdate from dual; sql> select * from dual;
The following creation table, inserts data, query data Create Table CompanyUser (CompanyID Int Not Null Primary Key, CompanyID, CompanyID, CompanyName) Values (105, 'Tan'); SELECT * from companyUser; 4) Creating a table Select: Object -> Create-> Table Wizard. In the part of the program, choose System. But when you created a SQL query, you can't find it, and you don't know where it is saved.
3 When logging in, if you select "Log in to Oracle Management Server" Default Administrator: Sysman Initial Password: OEM_TEMP Error Tip: VTK-1000: Unable to connect to Management Server, view it online, should not be installed in Management Server
