Oracle10g Database FAQs

1. start the listener to view the status lsnrctl start to view the listener status lsnrctl status
2. start and close the oracle master service. net start oracleserviceweb net stop oracleserviceweb
3. Connect to oracle sqlplus sys/123456 (password) as sysdba // sqlplus/nolog // conn sys/123456 @ myweb as sysdba
4. Start the instance, load and open the database startup
5. Disable database shutdown immediate
6. view the instance name: select instance_name from v $ instance;
7. view the database name select name from v $ datafile;
8. start em: emctl start/stop/status dbconsole
9. re-build em: emca-repos create
10. Delete em: emca-repos drop
11. set the window environment variable ORACLE_SID = database SID set oracle_sid web
12.6.ORACLE User Password modification method
Use OS authentication, that is, CONNECT/AS SYSDBA login, and then change the password.
Alter user sys identified ****
Alter user system identified ****
Then you can change it to password file authentication.
13. Create a tablespace
Create tablespace test_users
Logging
Datafile 'C: \ oracle \ product \ 10.2.0 \ oradata \ test_users_idx.dbf'
Size 32 m
Autoextend on
Next 32 m maxsize 2048 m
Extent management local;
14. Authorization
Create user zhh identified by "123456 ";
Grant connect to zhh;
Grant dba to zhh;
Grant imp_full_database to zhh;
Grant resource to zhh;
Grant create session to zhh;
Grant unlimited tablespace to zhh;
15. Enter em http: // localhost: 1158/em and sys sysdba to enter the em interface.
16. view the table names of all users:
1. select table_name from all_tables;
17. Relationship between instances, databases, and users
Relationship between databases and users and tablespaces
Relationship between users and tablespaces and profiles
In fact, these are basic things:
An instance is composed of some memory structures. A database may serve one or more instances, and one instance can only serve one database.
A database can have multiple users.
The database has multiple tablespaces. The database can have multiple users. The data of one user can exist in one or more tablespaces.
You can use a summary file. The summary file has nothing to do with the tablespace.

18. query select username from dba_users to view all users in oracle. // use as sysdba to access
19. After oracle 10g is installed, the system returns the em null error because the time zone is not configured. Find the file in the installation directory of oracle, for example, C: \ oracle \ product \ 10.2.0 \ db_1 \ MACHINE name _ orcl \ sysman \ config. in the properties file, change the last time zone of the file from agentTZRegion = GMT to agentTZRegion = Asia/Shanghai. Save the file and restart the OracleDBConsole service. Open IE and go to management. In addition, you can find the time zone reference in the installed directory, for example, 10.2.0 \ db_1 \ sysman \ admin \ supportedtzs. lst,
20. Create a database DBCA

Author: "There is a will !"