Home of Tips and Tricks, specially on Oracle, PHP, MySql. Others different topics will also be provided.
USE Your_Database_Name;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE Your_Database_Name
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (Your_Database_Name_Log, 1); -- Will resize log file to 1 MB.
GO
ALTER DATABASE Your_Database_Name -- Reset the database recovery model.
SET RECOVERY FULL;
GO
First: Go to this path C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\Templates
Second: Copy and paste the database/file named model.mdf and modellog.ldf to this path C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA
Now, problem will be resolved !
GRANT SELECT ON SYS.USER$ TO ORAF
$ sqlplus -prelim "/as sysdba"
SQL> Conn sys as sysdba
SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
Disconnected from ORACLE
After this point the database could once again be restarted:
sqlplus / as sysdba
Then run below commands:
sql> alter system set processes=500 scope=spfile;
sql> alter system set sessions=555 scope=spfile;
sql> alter system set transactions=610 scope=spfile;
sql> shutdown abort
sql> startup
create view vw_duplicate_face as
Select Photo, COUNT(EmployeeCode) as aa,
min (EmployeeCode) AS EmployeeCode_min ,
max (EmployeeCode) AS EmployeeCode_max
from
(
select [EmployeeCode],
cast(cast([HDCPInfo] as varbinary(max))
as varchar(max))
as Photo
from [HWATT].[dbo].[KQZ_Employee]
)a
Group By Photo
Having COUNT(EmployeeCode)>1
Below trigger will be created after SYS login to Container database
CREATE OR REPLACE TRIGGER auto_open_pdb
AFTER STARTUP ON DATABASE
BEGIN
EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';
END auto_open_pdb
