hte vergeben:
<code sql>
sqlplus / as sysdba
-- Create the Job User
create user job_control identified by job$100;
grant connect,resource to job_control;
grant... espace to job_control;
-- grant the main rights CREATE JOB, CREATE CREDENTIAL, and CREATE EXTERNAL JOB
grant create job, create credential, create external jo
und auf dem Serverbereitstellen:
<code bash>
# Create Working Directory
mkdir /srv/guacamole_source
#G... Passwort anmelden
mysql -h localhost -u root -p
CREATE DATABASE IF NOT EXISTS guacamole DEFAULT CHARACTE... ngKonsole2023');
-- Use database.
USE mysql;
-- Create user.
CREATE USER 'guacamole_user'@'10.10.10.155' IDENTIFIED BY PASSWORD '*D15600C362200601800BCF462D6190
s <del>deleted</del> as well.
**Paragraphs** are created from blank lines. If you want to **force a newli... zed, too.
==== Internal ====
Internal links are created by using square brackets. You can either just gi... nal [[pagename|link text]].
Internal links are created by using square brackets. You can either just gi... ki does not use [[wp>CamelCase]] to automatically create links by default, but this behavior can be enable
User für den Connect Through anlegen:
<code sql>
create user cman_tdm identified by "SecretPWD2023";
gran... ications-User anlegen und berechtigen:
<code sql>
create user gpipperr identified by "GanzAnderesPWD2023";... et mit dem User Credentials anlegen ===
mkstore -createCredential <DB Service Name> <DB Proxy User> <DB P...
mkstore -wrl /opt/oracle/wallet/wallet-cman-tdm -create
# User PWD für den Service hinterlegen
mkstore -
Beispiel ====
Ein sehr simples Macro:
<code sql>
create or replace function customerId
return varchar2
SQ... ...
=== Ein komplexeres Bespiel ===
<code sql>
create table Kunden(
SK number(11) GENERATED BY DEFAU... werden.
== Lösung PLSQL nativ ==
<code plsql>
create or replace function getInteralKDNr( p_institut... in SQL Macro umwandeln
Das SQL Macro:
<code sql>
create or replace function getInteralKDNrSQM
return varc
izieren:
<code sql>
-- as sys
-- grant rights to create the index
connect sys as sysdba
grant CTXAPP to gpi
connect gpi/gpi
create table texte ( id number(11) primary key, text var... ddl.drop_preference( 'gpi_lexer');
begin
ctx_ddl.create_preference( 'gpi_lexer', 'BASIC_LEXER' );
ctx_ddl... DROP_SECTION_GROUP('gpi_section');
begin
ctx_ddl.create_section_group ('gpi_section', 'NULL_SECTION_GROUP
der DESTINATION DB TST:
<code sql>
-- DB Link
create database link DP_TRANSFER connect to system ident... ed by hugo1oguh using 'gpi_db1';
-- DB Directory
create or replace directory import_dir as '/opt/oracle/i... ode sql>
ORA-39083: Object type TRIGGER failed to create with error:
ORA-00942: table or view does not exi... dpress.com/2016/08/12/impdb-with-schema_remap-may-createimport-trigger-on-table-in-wrong-schema/
=== ORA-
-S msdbCluster -U guacamole -d guacamole -i ./001-create-schema.sql
# Admin User guacadmin anlegen
/opt... -S msdbCluster -U guacamole -d guacamole -i ./002-create-admin-user.sql
# Login User guacamole_user anle... sql-tools/bin/sqlcmd -S msdbCluster -U guacamole
CREATE LOGIN guacamole_user WITH PASSWORD = 'SehrStrengGeheimesPWD';
GO
USE guacamole;
GO
CREATE USER guacamole_user;
GO
ALTER ROLE db_datawriter
verwenden]]
=== Weitere Themen ===
* [[dba:create_db_link_other_schema|Einen Oracle Datenbank Link ... f
* http://blog.grid-it.nl/index.php/2013/03/21/create-a-rpm-of-an-oracle-12c-agent/
Server Side THRES... racle Multitenant, then you may have up to 3 user-created PDBs in
a given container database at any time"/
through auf diesen User erlauben===
<code sql>
#create minimal user
create user gpi identifed BY gpi;
grant create session to gpi;
#alter the target user that GPI can connect as
nn frei gewählt werden:
<code bash>
pcs resource create cluster_ip ocf:heartbeat:IPaddr2 ip=10.10.10.98 c... ip cman21c-b
Warning: A move constraint has been created and the resource 'cluster_ip' may or may not mov... Knoten A mit:
<code bash>
#als root
pcs resource create gpicman oracman home="/opt/oracle/product/21c/cli