In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Windows2012 installation 12c
-- confirm the current cdb
SQL > select name,cdb from v$database
NAME CDB
--
ORCL YES
SQL > col pdb_name for A30
SQL > select pdb_id,pdb_name,dbid,status,creation_scn from dba_pdbs
PDB_ID PDB_NAME DBID STATUS CREATION_SCN
3 PDBORCL 2852917416 NORMAL 2381167
2 PDB$SEED 952217794 NORMAL 2233959
READ WRITE
-- pdb is created directly when the database is installed. The graphical interface can be created in the form of dbca. It can also be created by command.
-- pdb created separately. Need to configure tnsnames.ora file
SQL > show con_name
CON_NAME
-
CDB$ROOT
SQL > alter session set container=PDBORCL
SQL > show con_name
Create a user
SQL > grant dba to newjw identified by newjw;-because the user who exported this package has dba permissions
Create a data tablespace
Create tablespace yldb
Datafile'e:\ app\ oracle\ oradata\ yl\ pdbyl\ yldb01.dbf'
Size 5G
Autoextend on
Create temporary space
Create temporary tablespace yltemp
Tempfile'e:\ app\ oracle\ oradata\ yl\ pdbyl\ yltemp01.dbf'
Size 1G
Specify the user's and temporary tablespaces
SQL > alter user yl default tablespace yldb temporary tablespace yltemp
Modify empty table export:
Alter system set deferred_segment_creation=false
Modify password expiration:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
Guide user packet
C:\ Users\ Administrator > imp yl/yl@pdbyl file=D:\ yl_ 09 / 03 / 2017. Dmp log=D:\ yl_ / 09 / 03 / 2017. Log full=y
Question:
Can't the web connect to the database?
Jdbc:oracle:thin:@//:/
Example: jdbc:oracle:thin:@//192.168.11.111:1521/pwdyl
What is the problem with the pl/sql connection?
64-bit installation package to install 32 clients, log in to PLSQL developer, choose not to connect to the database, cancel, log in and set the OCI library and Oracle main directory name in the tools-> preferences
12c problem with empty table import?
Sqlplus / as sysdba
Alter session set container=pdbyl
Alter system set deferred_segment_creation=false
Plsql connected to the garbled code?
Ora-01033?
This question appeared several times, Baidu did not find the answer, causing me to uninstall the database and reinstall it.
But this mistake was reported again the second time.
According to the Internet.
I can get in with sys. But yl users are not allowed to enter. It would be like reporting a mistake.
So I created another test user, and there was no problem logging in.
The solution that came to mind at that time was to delete the user and re-import the user's packet.
After leaving for a while, my colleague operated on the database. He said he could log in and did nothing.
So, the solution to this problem has yet to be determined. The cause remains to be determined.
Because the client is installed, there are two oci. I tried to overwrite the client oci to the 12c server installation directory. In this way, the oci path of pl\ sql can be unspecified. The problem was solved at that time. After a while, the database could not log in. Abnormal termination.
Baidu said that the dll file is a nonsense. I should have done this. To restore.
After the restore, the database can log in.
But it is not certain that the problem with ora-01033 is caused by doing this operation.
Solve TNS-12541: TNS: no listener?
Reconfigure snooping
Remote Desktop shortcuts
Mstsc
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.