Toad World® Forums

Error creating Team Coding repository

Beta .14

I have a brand new 12.1 DB and I was going to install team coding objects. I went to Utilities–>Team Coding–> configure team coding.

Then clicked the “Install Team Coding” button. From there I selected New Toad schema and I selected a tablespace for tables and indexes and clicked Next.

Then entered password for SYS and selected the default and temp tablespaces and clicked OK. After That I get an invalid character error.

Here is teh script output. Looks like all the statements are duplicated.

Ed

SQL> CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error at line 2

ORA-00911: invalid character

SQL> ALTER USER TOAD QUOTA UNLIMITED ON USERSALTER USER TOAD QUOTA UNLIMITED ON USERS

Error at line 5

ORA-01918: user ‘TOAD’ does not exist

SQL> GRANT SELECT ANY DICTIONARY TO TOADGRANT SELECT ANY DICTIONARY TO TOAD

Error at line 6

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SESSION TO TOADGRANT CREATE SESSION TO TOAD

Error at line 7

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT UNLIMITED TABLESPACE to TOADGRANT UNLIMITED TABLESPACE to TOAD

Error at line 8

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT ALTER SESSION to TOADGRANT ALTER SESSION to TOAD

Error at line 9

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SYNONYM TO TOADGRANT CREATE SYNONYM TO TOAD

Error at line 10

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ROLE TO TOADGRANT CREATE ROLE TO TOAD

Error at line 11

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TRIGGER TO TOADGRANT CREATE TRIGGER TO TOAD

Error at line 12

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TABLE TO TOADGRANT CREATE TABLE TO TOAD

Error at line 13

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE VIEW TO TOADGRANT CREATE VIEW TO TOAD

Error at line 14

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PROCEDURE TO TOADGRANT CREATE PROCEDURE TO TOAD

Error at line 15

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT DROP PUBLIC SYNONYM TO TOADGRANT DROP PUBLIC SYNONYM TO TOAD

Error at line 16

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PUBLIC SYNONYM TO TOADGRANT CREATE PUBLIC SYNONYM TO TOAD

Error at line 17

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SEQUENCE TO TOADGRANT CREATE SEQUENCE TO TOAD

Error at line 18

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ANY TRIGGER TO TOADGRANT CREATE ANY TRIGGER TO TOAD

Error at line 19

ORA-01917: user or role ‘TOAD’ does not exist

Hello Ed,

I am checking this on our 12C database.

Stephen

From: ed.klinger [mailto:bounce-eklinger@toadworld.com]

Sent: Tuesday, August 27, 2013 2:29 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Error creating Team Coding repository

Thread created by ed.klinger

Beta .14

I have a brand new 12.1 DB and I was going to install team coding objects. I went to Utilities–>Team Coding–> configure team coding.

Then clicked the “Install Team Coding” button. From there I selected New Toad schema and I selected a tablespace for tables and indexes and clicked Next.

Then entered password for SYS and selected the default and temp tablespaces and clicked OK. After That I get an invalid character error.

Here is teh script output. Looks like all the statements are duplicated.

Ed

SQL> CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error at line 2

ORA-00911: invalid character

SQL> ALTER USER TOAD QUOTA UNLIMITED ON USERSALTER USER TOAD QUOTA UNLIMITED ON USERS

Error at line 5

ORA-01918: user ‘TOAD’ does not exist

SQL> GRANT SELECT ANY DICTIONARY TO TOADGRANT SELECT ANY DICTIONARY TO TOAD

Error at line 6

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SESSION TO TOADGRANT CREATE SESSION TO TOAD

Error at line 7

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT UNLIMITED TABLESPACE to TOADGRANT UNLIMITED TABLESPACE to TOAD

Error at line 8

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT ALTER SESSION to TOADGRANT ALTER SESSION to TOAD

Error at line 9

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SYNONYM TO TOADGRANT CREATE SYNONYM TO TOAD

Error at line 10

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ROLE TO TOADGRANT CREATE ROLE TO TOAD

Error at line 11

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TRIGGER TO TOADGRANT CREATE TRIGGER TO TOAD

Error at line 12

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TABLE TO TOADGRANT CREATE TABLE TO TOAD

Error at line 13

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE VIEW TO TOADGRANT CREATE VIEW TO TOAD

Error at line 14

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PROCEDURE TO TOADGRANT CREATE PROCEDURE TO TOAD

Error at line 15

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT DROP PUBLIC SYNONYM TO TOADGRANT DROP PUBLIC SYNONYM TO TOAD

Error at line 16

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PUBLIC SYNONYM TO TOADGRANT CREATE PUBLIC SYNONYM TO TOAD

Error at line 17

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SEQUENCE TO TOADGRANT CREATE SEQUENCE TO TOAD

Error at line 18

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ANY TRIGGER TO TOADGRANT CREATE ANY TRIGGER TO TOAD

Error at line 19

ORA-01917: user or role ‘TOAD’ does not exist

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Hi Ed,

I am running here on our 12 database without any issue. Can you try running SQL Spool to see what output you are getting?

Thanks

Stephen

From: Stephen Beausang [mailto:bounce-StephenBeausang_734@toadworld.com]

Sent: Tuesday, August 27, 2013 3:00 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE: Error creating
Team Coding repository

Reply by Stephen Beausang

Hello Ed,

I am checking this on our 12C database.

Stephen

From: ed.klinger [mailto:bounce-eklinger@toadworld.com]

Sent: Tuesday, August 27, 2013 2:29 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Error
creating Team Coding repository

Thread created by ed.klinger

Beta .14

I have a brand new 12.1 DB and I was going to install team coding objects. I went to Utilities–>Team Coding–> configure team coding.

Then clicked the “Install Team Coding” button. From there I selected New Toad schema and I selected a tablespace for tables and indexes and clicked Next.

Then entered password for SYS and selected the default and temp tablespaces and clicked OK. After That I get an invalid character error.

Here is teh script output. Looks like all the statements are duplicated.

Ed

SQL> CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error at line 2

ORA-00911: invalid character

SQL> ALTER USER TOAD QUOTA UNLIMITED ON USERSALTER USER TOAD QUOTA UNLIMITED ON USERS

Error at line 5

ORA-01918: user ‘TOAD’ does not exist

SQL> GRANT SELECT ANY DICTIONARY TO TOADGRANT SELECT ANY DICTIONARY TO TOAD

Error at line 6

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SESSION TO TOADGRANT CREATE SESSION TO TOAD

Error at line 7

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT UNLIMITED TABLESPACE to TOADGRANT UNLIMITED TABLESPACE to TOAD

Error at line 8

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT ALTER SESSION to TOADGRANT ALTER SESSION to TOAD

Error at line 9

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SYNONYM TO TOADGRANT CREATE SYNONYM TO TOAD

Error at line 10

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ROLE TO TOADGRANT CREATE ROLE TO TOAD

Error at line 11

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TRIGGER TO TOADGRANT CREATE TRIGGER TO TOAD

Error at line 12

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TABLE TO TOADGRANT CREATE TABLE TO TOAD

Error at line 13

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE VIEW TO TOADGRANT CREATE VIEW TO TOAD

Error at line 14

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PROCEDURE TO TOADGRANT CREATE PROCEDURE TO TOAD

Error at line 15

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT DROP PUBLIC SYNONYM TO TOADGRANT DROP PUBLIC SYNONYM TO TOAD

Error at line 16

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PUBLIC SYNONYM TO TOADGRANT CREATE PUBLIC SYNONYM TO TOAD

Error at line 17

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SEQUENCE TO TOADGRANT CREATE SEQUENCE TO TOAD

Error at line 18

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ANY TRIGGER TO TOADGRANT CREATE ANY TRIGGER TO TOAD

Error at line 19

ORA-01917: user or role ‘TOAD’ does not exist

To reply, please reply-all to this email.

Stop receiving emails on this
subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Why do people always run everything as SYS? Please see my blog about not abusing SYS. Unless you’re starting/stopping an instance, performing a database patch/upgrade
or running an Oracle admin script that specifically says SYS required – unles those then you should NEVER be using SYS. That’s not the problem – but as Norm will say looks like Bert just needed to rant on one of his favorite topics
J

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/08/12/common-toad-security-connection-mistakes.aspx

From: Stephen Beausang [mailto:bounce-StephenBeausang_734@toadworld.com]

Sent: Tuesday, August 27, 2013 2:35 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE: Error creating
Team Coding repository

Reply by Stephen Beausang

Hi Ed,

I am running here on our 12 database without any issue. Can you try running SQL Spool to see what output you are getting?

Thanks

Stephen

From: Stephen Beausang [mailto:bounce-StephenBeausang_734@toadworld.com]

Sent: Tuesday, August 27, 2013 3:00 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE:
Error creating Team Coding repository

Reply by Stephen Beausang

Hello Ed,

I am checking this on our 12C database.

Stephen

From: ed.klinger [mailto:bounce-eklinger@toadworld.com]

Sent: Tuesday, August 27, 2013 2:29 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Error
creating Team Coding repository

Thread created by ed.klinger

Beta .14

I have a brand new 12.1 DB and I was going to install team coding objects. I went to Utilities–>Team Coding–> configure team coding.

Then clicked the “Install Team Coding” button. From there I selected New Toad schema and I selected a tablespace for tables and indexes and clicked Next.

Then entered password for SYS and selected the default and temp tablespaces and clicked OK. After That I get an invalid character error.

Here is teh script output. Looks like all the statements are duplicated.

Ed

SQL> CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error at line 2

ORA-00911: invalid character

SQL> ALTER USER TOAD QUOTA UNLIMITED ON USERSALTER USER TOAD QUOTA UNLIMITED ON USERS

Error at line 5

ORA-01918: user ‘TOAD’ does not exist

SQL> GRANT SELECT ANY DICTIONARY TO TOADGRANT SELECT ANY DICTIONARY TO TOAD

Error at line 6

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SESSION TO TOADGRANT CREATE SESSION TO TOAD

Error at line 7

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT UNLIMITED TABLESPACE to TOADGRANT UNLIMITED TABLESPACE to TOAD

Error at line 8

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT ALTER SESSION to TOADGRANT ALTER SESSION to TOAD

Error at line 9

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SYNONYM TO TOADGRANT CREATE SYNONYM TO TOAD

Error at line 10

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ROLE TO TOADGRANT CREATE ROLE TO TOAD

Error at line 11

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TRIGGER TO TOADGRANT CREATE TRIGGER TO TOAD

Error at line 12

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TABLE TO TOADGRANT CREATE TABLE TO TOAD

Error at line 13

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE VIEW TO TOADGRANT CREATE VIEW TO TOAD

Error at line 14

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PROCEDURE TO TOADGRANT CREATE PROCEDURE TO TOAD

Error at line 15

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT DROP PUBLIC SYNONYM TO TOADGRANT DROP PUBLIC SYNONYM TO TOAD

Error at line 16

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PUBLIC SYNONYM TO TOADGRANT CREATE PUBLIC SYNONYM TO TOAD

Error at line 17

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SEQUENCE TO TOADGRANT CREATE SEQUENCE TO TOAD

Error at line 18

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ANY TRIGGER TO TOADGRANT CREATE ANY TRIGGER TO TOAD

Error at line 19

ORA-01917: user or role ‘TOAD’ does not exist

To reply, please reply-all to this email.

Stop
receiving emails
on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this
subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Ed,

A few of us have tried unsuccessfully to make this happen. The only thing I notice is that that your script is duplicating some code, on the second line, as
if pasting the CREATE USER statement again. When I run Show SQL in the ‘Create Toad User’ dialog everything looks normal (see below). On the off chance, would you mind running the install again, and run Show SQL from the ‘Create Toad User Dialog’, to see
if your script is displaying correctly.

CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

My script looks like this.

CREATE
USER TOAD
IDENTIFIED
BY somepassword

DEFAULT
TABLESPACE
USERS

TEMPORARY
TABLESPACE TEMP;

Bert, I did try to run this as Sys as well, just to be sure
J

Thanks

Stephen

Your line is showing. It looks like an extra line is getting added somewhere. Just for the heck of it, it

CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

From: ed.klinger [mailto:bounce-eklinger@toadworld.com]

Sent: Tuesday, August 27, 2013 2:29 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Error creating Team Coding repository

Thread created by ed.klinger

Beta .14

I have a brand new 12.1 DB and I was going to install team coding objects. I went to Utilities–>Team Coding–> configure team coding.

Then clicked the “Install Team Coding” button. From there I selected New Toad schema and I selected a tablespace for tables and indexes and clicked Next.

Then entered password for SYS and selected the default and temp tablespaces and clicked OK. After That I get an invalid character error.

Here is teh script output. Looks like all the statements are duplicated.

Ed

SQL> CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error at line 2

ORA-00911: invalid character

SQL> ALTER USER TOAD QUOTA UNLIMITED ON USERSALTER USER TOAD QUOTA UNLIMITED ON USERS

Error at line 5

ORA-01918: user ‘TOAD’ does not exist

SQL> GRANT SELECT ANY DICTIONARY TO TOADGRANT SELECT ANY DICTIONARY TO TOAD

Error at line 6

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SESSION TO TOADGRANT CREATE SESSION TO TOAD

Error at line 7

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT UNLIMITED TABLESPACE to TOADGRANT UNLIMITED TABLESPACE to TOAD

Error at line 8

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT ALTER SESSION to TOADGRANT ALTER SESSION to TOAD

Error at line 9

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SYNONYM TO TOADGRANT CREATE SYNONYM TO TOAD

Error at line 10

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ROLE TO TOADGRANT CREATE ROLE TO TOAD

Error at line 11

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TRIGGER TO TOADGRANT CREATE TRIGGER TO TOAD

Error at line 12

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TABLE TO TOADGRANT CREATE TABLE TO TOAD

Error at line 13

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE VIEW TO TOADGRANT CREATE VIEW TO TOAD

Error at line 14

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PROCEDURE TO TOADGRANT CREATE PROCEDURE TO TOAD

Error at line 15

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT DROP PUBLIC SYNONYM TO TOADGRANT DROP PUBLIC SYNONYM TO TOAD

Error at line 16

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PUBLIC SYNONYM TO TOADGRANT CREATE PUBLIC SYNONYM TO TOAD

Error at line 17

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SEQUENCE TO TOADGRANT CREATE SEQUENCE TO TOAD

Error at line 18

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ANY TRIGGER TO TOADGRANT CREATE ANY TRIGGER TO TOAD

Error at line 19

ORA-01917: user or role ‘TOAD’ does not exist

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Ed, did you have any characters in your password that would require us to double-quote it?

Glancing at the code, I see that we aren’t adding double quotes if needed.

From: Stephen Beausang [mailto:bounce-StephenBeausang_734@toadworld.com]

Sent: Tuesday, August 27, 2013 2:00 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE: Error creating
Team Coding repository

Reply by Stephen Beausang

Hello Ed,

I am checking this on our 12C database.

Stephen

From: ed.klinger [mailto:bounce-eklinger@toadworld.com]

Sent: Tuesday, August 27, 2013 2:29 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Error
creating Team Coding repository

Thread created by ed.klinger

Beta .14

I have a brand new 12.1 DB and I was going to install team coding objects. I went to Utilities–>Team Coding–> configure team coding.

Then clicked the “Install Team Coding” button. From there I selected New Toad schema and I selected a tablespace for tables and indexes and clicked Next.

Then entered password for SYS and selected the default and temp tablespaces and clicked OK. After That I get an invalid character error.

Here is teh script output. Looks like all the statements are duplicated.

Ed

SQL> CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error at line 2

ORA-00911: invalid character

SQL> ALTER USER TOAD QUOTA UNLIMITED ON USERSALTER USER TOAD QUOTA UNLIMITED ON USERS

Error at line 5

ORA-01918: user ‘TOAD’ does not exist

SQL> GRANT SELECT ANY DICTIONARY TO TOADGRANT SELECT ANY DICTIONARY TO TOAD

Error at line 6

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SESSION TO TOADGRANT CREATE SESSION TO TOAD

Error at line 7

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT UNLIMITED TABLESPACE to TOADGRANT UNLIMITED TABLESPACE to TOAD

Error at line 8

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT ALTER SESSION to TOADGRANT ALTER SESSION to TOAD

Error at line 9

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SYNONYM TO TOADGRANT CREATE SYNONYM TO TOAD

Error at line 10

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ROLE TO TOADGRANT CREATE ROLE TO TOAD

Error at line 11

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TRIGGER TO TOADGRANT CREATE TRIGGER TO TOAD

Error at line 12

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TABLE TO TOADGRANT CREATE TABLE TO TOAD

Error at line 13

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE VIEW TO TOADGRANT CREATE VIEW TO TOAD

Error at line 14

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PROCEDURE TO TOADGRANT CREATE PROCEDURE TO TOAD

Error at line 15

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT DROP PUBLIC SYNONYM TO TOADGRANT DROP PUBLIC SYNONYM TO TOAD

Error at line 16

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PUBLIC SYNONYM TO TOADGRANT CREATE PUBLIC SYNONYM TO TOAD

Error at line 17

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SEQUENCE TO TOADGRANT CREATE SEQUENCE TO TOAD

Error at line 18

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ANY TRIGGER TO TOADGRANT CREATE ANY TRIGGER TO TOAD

Error at line 19

ORA-01917: user or role ‘TOAD’ does not exist

To reply, please reply-all to this email.

Stop receiving emails on this
subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

That password had a $ in it along with mixed case. That looks like it is the issue.

Session: SYS@SSDEV2

Timestamp: 16:35:40.503

CREATE USER TOAD IDENTIFIED BY $abcdef

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error: ORA-00911: invalid character

Seems if the password starts with a special character it requires it to be quoted

Ed

On Aug 27, 2013, at 4:29 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:

RE: Error creating Team Coding repository

Reply by John Dorlon
Ed, did you have any characters in your password that would require us to double-quote it?

Glancing at the code, I see that we aren’t adding double quotes if needed.

From: Stephen Beausang [mailto:bounce-StephenBeausang_734@toadworld.com]
Sent: Tuesday, August 27, 2013 2:00 PM
To: toadoraclebeta@toadworld.com
Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE: Error creating Team Coding repository

Reply by Stephen Beausang

Hello Ed,

I am checking this on our 12C database.

Stephen

From: ed.klinger [mailto:bounce-eklinger@toadworld.com]
Sent: Tuesday, August 27, 2013 2:29 PM
To: toadoraclebeta@toadworld.com
Subject: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Error creating Team Coding repository

Thread created by ed.klinger

Beta .14

I have a brand new 12.1 DB and I was going to install team coding objects. I went to Utilities–>Team Coding–> configure team coding.

Then clicked the “Install Team Coding” button. From there I selected New Toad schema and I selected a tablespace for tables and indexes and clicked Next.

Then entered password for SYS and selected the default and temp tablespaces and clicked OK. After That I get an invalid character error.

Here is teh script output. Looks like all the statements are duplicated.

Ed

SQL> CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error at line 2

ORA-00911: invalid character

SQL> ALTER USER TOAD QUOTA UNLIMITED ON USERSALTER USER TOAD QUOTA UNLIMITED ON USERS

Error at line 5

ORA-01918: user ‘TOAD’ does not exist

SQL> GRANT SELECT ANY DICTIONARY TO TOADGRANT SELECT ANY DICTIONARY TO TOAD

Error at line 6

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SESSION TO TOADGRANT CREATE SESSION TO TOAD

Error at line 7

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT UNLIMITED TABLESPACE to TOADGRANT UNLIMITED TABLESPACE to TOAD

Error at line 8

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT ALTER SESSION to TOADGRANT ALTER SESSION to TOAD

Error at line 9

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SYNONYM TO TOADGRANT CREATE SYNONYM TO TOAD

Error at line 10

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ROLE TO TOADGRANT CREATE ROLE TO TOAD

Error at line 11

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TRIGGER TO TOADGRANT CREATE TRIGGER TO TOAD

Error at line 12

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TABLE TO TOADGRANT CREATE TABLE TO TOAD

Error at line 13

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE VIEW TO TOADGRANT CREATE VIEW TO TOAD

Error at line 14

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PROCEDURE TO TOADGRANT CREATE PROCEDURE TO TOAD

Error at line 15

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT DROP PUBLIC SYNONYM TO TOADGRANT DROP PUBLIC SYNONYM TO TOAD

Error at line 16

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PUBLIC SYNONYM TO TOADGRANT CREATE PUBLIC SYNONYM TO TOAD

Error at line 17

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SEQUENCE TO TOADGRANT CREATE SEQUENCE TO TOAD

Error at line 18

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ANY TRIGGER TO TOADGRANT CREATE ANY TRIGGER TO TOAD

Error at line 19

ORA-01917: user or role ‘TOAD’ does not exist

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

OK. As a workaround, you can just double-quote yourself in the dialog.

From: ed.klinger [mailto:bounce-eklinger@toadworld.com]

Sent: Tuesday, August 27, 2013 3:45 PM

To: toadoraclebeta@toadworld.com

Subject: Re: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Re: Error creating
Team Coding repository

Reply by ed.klinger

That password had a $ in it along with mixed case. That looks like it is the issue.

Session: SYS@SSDEV2

Timestamp: 16:35:40.503

CREATE USER TOAD IDENTIFIED BY $abcdef

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error: ORA-00911: invalid character

Seems if the password starts with a special character it requires it to be quoted

Ed

On Aug 27, 2013, at 4:29 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:

RE:
Error creating Team Coding repository

Reply by John Dorlon

Ed, did you have any characters in your password that would require us to double-quote it?

Glancing at the code, I see that we aren’t adding double quotes if needed.

From: Stephen
Beausang [mailto:bounce-StephenBeausang_734@toadworld.com]

Sent: Tuesday, August 27, 2013 2:00 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE:
Error creating Team Coding repository

Reply by Stephen Beausang

Hello Ed,

I am checking this on our 12C database.

Stephen

From: ed.klinger
[mailto:bounce-eklinger@toadworld.com]

Sent: Tuesday, August 27, 2013 2:29 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Error
creating Team Coding repository

Thread created by ed.klinger

Beta .14

I have a brand new 12.1 DB and I was going to install team coding objects. I went to Utilities–>Team Coding–> configure team coding.

Then clicked the “Install Team Coding” button. From there I selected New Toad schema and I selected a tablespace for tables and indexes and clicked Next.

Then entered password for SYS and selected the default and temp tablespaces and clicked OK. After That I get an invalid character error.

Here is teh script output. Looks like all the statements are duplicated.

Ed

SQL> CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error at line 2

ORA-00911: invalid character

SQL> ALTER USER TOAD QUOTA UNLIMITED ON USERSALTER USER TOAD QUOTA UNLIMITED ON USERS

Error at line 5

ORA-01918: user ‘TOAD’ does not exist

SQL> GRANT SELECT ANY DICTIONARY TO TOADGRANT SELECT ANY DICTIONARY TO TOAD

Error at line 6

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SESSION TO TOADGRANT CREATE SESSION TO TOAD

Error at line 7

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT UNLIMITED TABLESPACE to TOADGRANT UNLIMITED TABLESPACE to TOAD

Error at line 8

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT ALTER SESSION to TOADGRANT ALTER SESSION to TOAD

Error at line 9

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SYNONYM TO TOADGRANT CREATE SYNONYM TO TOAD

Error at line 10

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ROLE TO TOADGRANT CREATE ROLE TO TOAD

Error at line 11

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TRIGGER TO TOADGRANT CREATE TRIGGER TO TOAD

Error at line 12

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TABLE TO TOADGRANT CREATE TABLE TO TOAD

Error at line 13

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE VIEW TO TOADGRANT CREATE VIEW TO TOAD

Error at line 14

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PROCEDURE TO TOADGRANT CREATE PROCEDURE TO TOAD

Error at line 15

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT DROP PUBLIC SYNONYM TO TOADGRANT DROP PUBLIC SYNONYM TO TOAD

Error at line 16

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PUBLIC SYNONYM TO TOADGRANT CREATE PUBLIC SYNONYM TO TOAD

Error at line 17

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SEQUENCE TO TOADGRANT CREATE SEQUENCE TO TOAD

Error at line 18

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ANY TRIGGER TO TOADGRANT CREATE ANY TRIGGER TO TOAD

Error at line 19

ORA-01917: user or role ‘TOAD’ does not exist

To reply, please reply-all to this email.

Stop
receiving emails
on this subject.

Or Unsubscribe
from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this
post as spam/abuse.

To reply, please reply-all to this email.

Stop
receiving emails
on this subject.

Or Unsubscribe
from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this
post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on
this subject.

Or Unsubscribe
from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this
post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
t

Ed and John,

Nice trouble shooting job …

Thanks for the help

Stephen

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Tuesday, August 27, 2013 4:50 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE: Error creating
Team Coding repository

Reply by John Dorlon

OK. As a workaround, you can just double-quote yourself in the dialog.

From: ed.klinger [mailto:bounce-eklinger@toadworld.com]

Sent: Tuesday, August 27, 2013 3:45 PM

To: toadoraclebeta@toadworld.com

Subject: Re: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Re:
Error creating Team Coding repository

Reply by ed.klinger

That password had a $ in it along with mixed case. That looks like it is the issue.

Session: SYS@SSDEV2

Timestamp: 16:35:40.503

CREATE USER TOAD IDENTIFIED BY $abcdef

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error: ORA-00911: invalid character

Seems if the password starts with a special character it requires it to be quoted

Ed

On Aug 27, 2013, at 4:29 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:

RE:
Error creating Team Coding repository

Reply by John Dorlon

Ed, did you have any characters in your password that would require us to double-quote it?

Glancing at the code, I see that we aren’t adding double quotes if needed.

From: Stephen
Beausang [mailto:bounce-StephenBeausang_734@toadworld.com]

Sent: Tuesday, August 27, 2013 2:00 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE:
Error creating Team Coding repository

Reply by Stephen Beausang

Hello Ed,

I am checking this on our 12C database.

Stephen

From: ed.klinger
[mailto:bounce-eklinger@toadworld.com]

Sent: Tuesday, August 27, 2013 2:29 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Error
creating Team Coding repository

Thread created by ed.klinger

Beta .14

I have a brand new 12.1 DB and I was going to install team coding objects. I went to Utilities–>Team Coding–> configure team coding.

Then clicked the “Install Team Coding” button. From there I selected New Toad schema and I selected a tablespace for tables and indexes and clicked Next.

Then entered password for SYS and selected the default and temp tablespaces and clicked OK. After That I get an invalid character error.

Here is teh script output. Looks like all the statements are duplicated.

Ed

SQL> CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error at line 2

ORA-00911: invalid character

SQL> ALTER USER TOAD QUOTA UNLIMITED ON USERSALTER USER TOAD QUOTA UNLIMITED ON USERS

Error at line 5

ORA-01918: user ‘TOAD’ does not exist

SQL> GRANT SELECT ANY DICTIONARY TO TOADGRANT SELECT ANY DICTIONARY TO TOAD

Error at line 6

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SESSION TO TOADGRANT CREATE SESSION TO TOAD

Error at line 7

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT UNLIMITED TABLESPACE to TOADGRANT UNLIMITED TABLESPACE to TOAD

Error at line 8

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT ALTER SESSION to TOADGRANT ALTER SESSION to TOAD

Error at line 9

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SYNONYM TO TOADGRANT CREATE SYNONYM TO TOAD

Error at line 10

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ROLE TO TOADGRANT CREATE ROLE TO TOAD

Error at line 11

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TRIGGER TO TOADGRANT CREATE TRIGGER TO TOAD

Error at line 12

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TABLE TO TOADGRANT CREATE TABLE TO TOAD

Error at line 13

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE VIEW TO TOADGRANT CREATE VIEW TO TOAD

Error at line 14

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PROCEDURE TO TOADGRANT CREATE PROCEDURE TO TOAD

Error at line 15

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT DROP PUBLIC SYNONYM TO TOADGRANT DROP PUBLIC SYNONYM TO TOAD

Error at line 16

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PUBLIC SYNONYM TO TOADGRANT CREATE PUBLIC SYNONYM TO TOAD

Error at line 17

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SEQUENCE TO TOADGRANT CREATE SEQUENCE TO TOAD

Error at line 18

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ANY TRIGGER TO TOADGRANT CREATE ANY TRIGGER TO TOAD

Error at line 19

ORA-01917: user or role ‘TOAD’ does not exist

To reply, please reply-all to this email.

Stop
receiving emails
on this subject.

Or Unsubscribe
from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this
post as spam/abuse.

To reply, please reply-all to this email.

Or create it with a simpler password, let the script run, then change the password.

Nate Schroeder

US Row Crops IT Data Management Team

Monsanto Company

800 N. Lindbergh Blvd. G3WB - Saint Louis, MO - 63167

314-694-2592

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Tuesday, August 27, 2013 3:50 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE: Error creating
Team Coding repository

Reply by John Dorlon

OK. As a workaround, you can just double-quote yourself in the dialog.

From: ed.klinger [mailto:bounce-eklinger@toadworld.com]

Sent: Tuesday, August 27, 2013 3:45 PM

To: toadoraclebeta@toadworld.com

Subject: Re: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Re:
Error creating Team Coding repository

Reply by ed.klinger

That password had a $ in it along with mixed case. That looks like it is the issue.

Session: SYS@SSDEV2

Timestamp: 16:35:40.503

CREATE USER TOAD IDENTIFIED BY $abcdef

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error: ORA-00911: invalid character

Seems if the password starts with a special character it requires it to be quoted

Ed

On Aug 27, 2013, at 4:29 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:

RE:
Error creating Team Coding repository

Reply by John Dorlon

Ed, did you have any characters in your password that would require us to double-quote it?

Glancing at the code, I see that we aren’t adding double quotes if needed.

From: Stephen
Beausang [mailto:bounce-StephenBeausang_734@toadworld.com]

Sent: Tuesday, August 27, 2013 2:00 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE:
Error creating Team Coding repository

Reply by Stephen Beausang

Hello Ed,

I am checking this on our 12C database.

Stephen

From: ed.klinger
[mailto:bounce-eklinger@toadworld.com]

Sent: Tuesday, August 27, 2013 2:29 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Error
creating Team Coding repository

Thread created by ed.klinger

Beta .14

I have a brand new 12.1 DB and I was going to install team coding objects. I went to Utilities–>Team Coding–> configure team coding.

Then clicked the “Install Team Coding” button. From there I selected New Toad schema and I selected a tablespace for tables and indexes and clicked Next.

Then entered password for SYS and selected the default and temp tablespaces and clicked OK. After That I get an invalid character error.

Here is teh script output. Looks like all the statements are duplicated.

Ed

SQL> CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error at line 2

ORA-00911: invalid character

SQL> ALTER USER TOAD QUOTA UNLIMITED ON USERSALTER USER TOAD QUOTA UNLIMITED ON USERS

Error at line 5

ORA-01918: user ‘TOAD’ does not exist

SQL> GRANT SELECT ANY DICTIONARY TO TOADGRANT SELECT ANY DICTIONARY TO TOAD

Error at line 6

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SESSION TO TOADGRANT CREATE SESSION TO TOAD

Error at line 7

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT UNLIMITED TABLESPACE to TOADGRANT UNLIMITED TABLESPACE to TOAD

Error at line 8

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT ALTER SESSION to TOADGRANT ALTER SESSION to TOAD

Error at line 9

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SYNONYM TO TOADGRANT CREATE SYNONYM TO TOAD

Error at line 10

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ROLE TO TOADGRANT CREATE ROLE TO TOAD

Error at line 11

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TRIGGER TO TOADGRANT CREATE TRIGGER TO TOAD

Error at line 12

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TABLE TO TOADGRANT CREATE TABLE TO TOAD

Error at line 13

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE VIEW TO TOADGRANT CREATE VIEW TO TOAD

Error at line 14

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PROCEDURE TO TOADGRANT CREATE PROCEDURE TO TOAD

Error at line 15

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT DROP PUBLIC SYNONYM TO TOADGRANT DROP PUBLIC SYNONYM TO TOAD

Error at line 16

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PUBLIC SYNONYM TO TOADGRANT CREATE PUBLIC SYNONYM TO TOAD

Error at line 17

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SEQUENCE TO TOADGRANT CREATE SEQUENCE TO TOAD

Error at line 18

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ANY TRIGGER TO TOADGRANT CREATE ANY TRIGGER TO TOAD

Error at line 19

ORA-01917: user or role ‘TOAD’ does not exist

To reply, please reply-all to this email.

Stop
receiving emails
on this subject.

Or Unsubscribe
from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this
post as spam/abuse.

`

Thanks Nate. Yes i was able to create it no problems after identifying the problem.

Thanks John and Stephen!

Ed

On Aug 27, 2013, at 5:00 PM, nathan.e.schroeder bounce-nathaneschroeder@toadworld.com wrote:

RE: Error creating Team Coding repository

Reply by nathan.e.schroeder
Or create it with a simpler password, let the script run, then change the password.

Nate Schroeder

US Row Crops IT Data Management Team

Monsanto Company

800 N. Lindbergh Blvd. G3WB - Saint Louis, MO - 63167

314-694-2592

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]
Sent: Tuesday, August 27, 2013 3:50 PM
To: toadoraclebeta@toadworld.com
Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE: Error creating Team Coding repository

Reply by John Dorlon

OK. As a workaround, you can just double-quote yourself in the dialog.

From: ed.klinger [mailto:bounce-eklinger@toadworld.com]
Sent: Tuesday, August 27, 2013 3:45 PM
To: toadoraclebeta@toadworld.com
Subject: Re: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Re: Error creating Team Coding repository

Reply by ed.klinger

That password had a $ in it along with mixed case. That looks like it is the issue.

Session: SYS@SSDEV2

Timestamp: 16:35:40.503

CREATE USER TOAD IDENTIFIED BY $abcdef

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error: ORA-00911: invalid character

Seems if the password starts with a special character it requires it to be quoted

Ed

On Aug 27, 2013, at 4:29 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:

RE: Error creating Team Coding repository

Reply by John Dorlon

Ed, did you have any characters in your password that would require us to double-quote it?

Glancing at the code, I see that we aren’t adding double quotes if needed.

From: Stephen Beausang [mailto:bounce-StephenBeausang_734@toadworld.com]
Sent: Tuesday, August 27, 2013 2:00 PM
To: toadoraclebeta@toadworld.com
Subject: RE: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

RE: Error creating Team Coding repository

Reply by Stephen Beausang

Hello Ed,

I am checking this on our 12C database.

Stephen

From: ed.klinger [mailto:bounce-eklinger@toadworld.com]
Sent: Tuesday, August 27, 2013 2:29 PM
To: toadoraclebeta@toadworld.com
Subject: [Toad for Oracle - Beta Discussion Forum] Error creating Team Coding repository

Error creating Team Coding repository

Thread created by ed.klinger

Beta .14

I have a brand new 12.1 DB and I was going to install team coding objects. I went to Utilities–>Team Coding–> configure team coding.

Then clicked the “Install Team Coding” button. From there I selected New Toad schema and I selected a tablespace for tables and indexes and clicked Next.

Then entered password for SYS and selected the default and temp tablespaces and clicked OK. After That I get an invalid character error.

Here is teh script output. Looks like all the statements are duplicated.

Ed

SQL> CREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMPCREATE USER TOAD IDENTIFIED BY somepassword

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

Error at line 2

ORA-00911: invalid character

SQL> ALTER USER TOAD QUOTA UNLIMITED ON USERSALTER USER TOAD QUOTA UNLIMITED ON USERS

Error at line 5

ORA-01918: user ‘TOAD’ does not exist

SQL> GRANT SELECT ANY DICTIONARY TO TOADGRANT SELECT ANY DICTIONARY TO TOAD

Error at line 6

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SESSION TO TOADGRANT CREATE SESSION TO TOAD

Error at line 7

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT UNLIMITED TABLESPACE to TOADGRANT UNLIMITED TABLESPACE to TOAD

Error at line 8

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT ALTER SESSION to TOADGRANT ALTER SESSION to TOAD

Error at line 9

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SYNONYM TO TOADGRANT CREATE SYNONYM TO TOAD

Error at line 10

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ROLE TO TOADGRANT CREATE ROLE TO TOAD

Error at line 11

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TRIGGER TO TOADGRANT CREATE TRIGGER TO TOAD

Error at line 12

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE TABLE TO TOADGRANT CREATE TABLE TO TOAD

Error at line 13

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE VIEW TO TOADGRANT CREATE VIEW TO TOAD

Error at line 14

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PROCEDURE TO TOADGRANT CREATE PROCEDURE TO TOAD

Error at line 15

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT DROP PUBLIC SYNONYM TO TOADGRANT DROP PUBLIC SYNONYM TO TOAD

Error at line 16

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE PUBLIC SYNONYM TO TOADGRANT CREATE PUBLIC SYNONYM TO TOAD

Error at line 17

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE SEQUENCE TO TOADGRANT CREATE SEQUENCE TO TOAD

Error at line 18

ORA-01917: user or role ‘TOAD’ does not exist

SQL> GRANT CREATE ANY TRIGGER TO TOADGRANT CREATE ANY TRIGGER TO TOAD

Error at line 19

ORA-01917: user or role ‘TOAD’ does not exist

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

To reply, please reply-all to this email.