Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Upgrade oralce 11g database to 12c

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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report