Oracle question, 10 questions every day (1)

When applying Oracle, you may encounter many seemingly difficult problems. Especially for new users, today I will summarize it and release it to everyone. I hope it will be helpful to everyone! Discuss with everyone and make progress together!

For Oracle experts, you don't have to look at it.

1. What is the initial password after oracle is installed?

Internal/Oracle

Sys/change_on_install

System/Manager

Scott/Tiger

Sysman/oem_temp

2. What is the initial Default User and password of Oracle9iAS Web Cache?

Administrator/Administrator

3. How to Create a database in Oracle 8.0.5?

Use orainst. If there is a motif interface, you can use orainst/m

4. How to Create a database in Oracle 8.1.7?

Dbassist

5. How can I create a database in Oracle 9i?

Dbca

6. What does the bare device in Oracle mean?

A bare device is a storage space that is directly accessed by bypassing the file system.

7. How Does Oracle differentiate 64-bit/32bit versions ???

$ Sqlplus '/As sysdba'

SQL * Plus: Release 9.0.1.0.0-production on Mon Jul 14 17:01:09 2003

(C) Copyright 2001 Oracle Corporation. All rights reserved.

Connected:
　　
Oracle9i Enterprise Edition Release 9.0.1.0.0-Production
　　
With the partitioning Option

Jserver release 9.0.1.0.0-Production

SQL> select * from V $ version;
　
Banner
　　
----------------------------------------------------------------

Oracle9i Enterprise Edition Release 9.0.1.0.0-Production

PL/SQL release 9.0.1.0.0-Production
　　
Core 9.0.1.0.0 Production

TNS for Solaris: Version 9.0.1.0.0-Production

Nlsrtl version 9.0.1.0.0-Production

SQL>

8. What does svrmgr mean?

Svrmgrl, Server Manager.

No under 9i. I already used sqlplus.

Sqlplus/nolog

Changed to archive log type

9. How can I tell from which machine a user logs on to Oracle?

Select machine, terminal from V $ session;

10. What statements are used to query fields?

Desc table_name: You can query the table structure.

Select field_name,... from... can query the field value

Select * From all_tables where table_name like '%'

Select * From all_tab_columns where table_name = '?? '